Questions tagged [postgresql]
PostgreSQL is a community developed, open source, relational database, made available under a BSD-like license. The PostgreSQL documentation is expansive and incredibly useful.
554
questions
1
vote
2
answers
10k
views
How to change root password for PostgreSql phpPgAdmin?
What is the simplest way to change root password for PostgreSql phpPgAdmin ?
- 3,682
1
vote
2
answers
3k
views
Postgresql unix domain socket with password authentication
It looks like postgresql supports either of the below
Use tcp (i.e. localhost:5432) with password authentication
Use Unix domain scoket (i.e /var/run/postgresql/.s.PGSQL.5432 ) with peer/trust ...
- 127
1
vote
2
answers
8k
views
pgAdmin4 "Unauthorized" error
I am using kUbuntu 18.04(bionic) on my local machine and I installed postgresql11 and pgadmin4 step by step from this guide https://wiki.postgresql.org/wiki/Apt. And when i start pgAdmin4 firefox ...
1
vote
1
answer
1k
views
How can I drop a PostgreSQL table with double quotes in its name?
I've inadvertedly created the following table, which I can't remove:
db=> \dt
List of relations
Schema | Name | Type | Owner
--------+-----------------...
- 113
1
vote
2
answers
13k
views
Connect to PostgreSQL database from Excel 2013 Power Query with Npgsql
I want to pull data from a PostgreSQL database on my local network with Power Query. By default my version of Excel lists three options under the "Get External Data/From Database" menu on the Power ...
- 461
1
vote
1
answer
5k
views
Connect to PgSQL, DROP existent DB, recreate it using CREATE and run some queries alone and from files using Bash script
I need some advice creating a script for help me with repetitive task I do all the time on a development environment. I've a PostgreSQL server and since I'm developing a web application I need to drop,...
- 365
1
vote
1
answer
14k
views
How to reset the postgres super user password on mac os x
I installed postgres on my mac running 10.6.8 and I would like to reset the password for the postgres user (I believe this is the super user password) and then restart it.
All the directions I found ...
1
vote
1
answer
960
views
How do I give MacPorts privileges?
I tried to install PostgreSQL server development libraries using MacPorts and got the following:
Warning: MacPorts running without privileges. You may be unable to complete certain actions (e.g. ...
- 161
1
vote
3
answers
1k
views
Postgresql by network
I have running PostgreSQL sever on 192.168.0.102:5432.
postgresql.conf has this line:
listen_addresses = '*'
and pg_hba.conf has this one:
host all all 127.0.0.1/32 ...
- 63
1
vote
2
answers
819
views
How to get ONLY the variable output of a PSQL statement
If have a variable:
var=$(psql -U chh1 -d crewdb -c '\t' -c "SELECT MAX(date_linkid) + 1 FROM date_link;")
When I run:
echo "$var"
I get:
Tuples only is on.
284
How can I ...
- 331
1
vote
1
answer
1k
views
Fedora 28 cannot upgrade Postgres to 10
When starting the Postgres server on Fedora 28, I get this error:
May 25 14:36:14 localhost.localdomain systemd[1]: Starting PostgreSQL database server...
May 25 14:36:14 localhost.localdomain ...
- 1,594
1
vote
1
answer
148
views
dd fails in postgres backup from one server to another
I've got a server which is running out of space. Unfortunately it doesn't even have enough space anymore to backup a postgres database I've got running on it. So I now want to backup the running ...
- 1,434
1
vote
2
answers
8k
views
How to start only one version of PostgreSQL database, in this case 9.1?
I have installed PostgreSQL 8.4 and 9.1 on same Ubuntu machine and I want to try to run only 9.1 and 8.4 to stay off. When I run /etc/init.d/postgresql start it starts both. How to start only one ...
- 229
1
vote
3
answers
586
views
Difference between `/sbin/service postgresql-9.1 start` and `/etc/init.d/postgresql-9.1 start`
I have seen two ways to start a postgresql server:
/sbin/service postgresql-9.1 start
/etc/init.d/postgresql-9.1 start
Could anyone explain the difference between these two? Or there's no ...
- 125
1
vote
1
answer
109
views
How can I build an old application for 64bit?
I am trying to build postgresql 7.4.6 on a 64bit machine for 64bit. I'm not sure whether this code is 64bit compatible. Is there a way to check?
If it is 64bit compatible, do I need to do anything ...
- 1,729
1
vote
1
answer
3k
views
Why pg_dump 'trust' authentication fails under root and works under another user?
I have pg_dump command in cron that accesses PostgreSQL under user postgres and does not provide a password.
pg_dump --username=postgres ...
I have set in pg_hba.conf that user postgres should be ...
- 1,138
1
vote
1
answer
1k
views
Where does Cygwin setup.exe keep PostgreSQL?
Basically I just chose to install PostgreSQL from the Cygwin Setup.exe. The process went fine so I reckon it is installed successfully.
I found several links to this question like this one
However, I ...
- 493
1
vote
1
answer
6k
views
XAMPP with PostgreSQL
I'm looking for a package like XAMPP, but instead of MySQL it would use PostgreSQL. I've done some searching and haven't turned up anything other than doing a full server setup of both.
fred smith
1
vote
1
answer
1k
views
Connecting to a Postgres database, hosted within a Windows Subsystem for Linux, from a separate device
I have two devices:
HOST: a Windows device, on which I have installed a Windows Subsystem for Linux.
CLIENT: a Linux device.
I have then taken the following steps.
I have installed Postgres within ...
- 111
1
vote
1
answer
2k
views
E: Unable to correct problems, you have held broken packages
Linux Mint 21
I try to install postgresql 9.6 like this:
sudo apt-get install postgresql-9.6
But get error:
Reading package lists... Done
Building dependency tree... Done
Reading state information... ...
- 433
1
vote
1
answer
220
views
disable (or trim) logging of bytea requests in postgres
Our application store some big blob (bytea) in a separate database every 30 minutes. It's fine and we want to keep it like, this, but it's causing crazy logging:
2021-01-25 11:11:00 UTC postgres109432 ...
- 180
1
vote
1
answer
968
views
PostgreSQL Peer Authentication User Mapping Failed
Logged in to the server as user root, I need to enter a database as user postgres via Unix socket. This is my pg_ident.conf:
# MAPNAME SYSTEM-USERNAME PG-USERNAME
testmap ...
- 11
1
vote
1
answer
2k
views
How to create an odbc string connection in an excel spreadsheet to make it portable instead of setting up an odbc connection on every computer?
I'm setting up an excel reporting using Excel 2013 for that.
The spreadsheet is retrieving data, through an odbc connection that I need to set on every computer in order to retrieve the data.
I ...
- 392
1
vote
1
answer
3k
views
Remove Empty Second Line From Very Large CSV File in Windows 10
I have an very large CSV file (data for all the taxi trips in NYC during March). The second line is empty which angers PostgreSQL's import. I can run
(gc file.csv) | ? {$_.trim() -ne "" } | set-...
- 123
1
vote
1
answer
2k
views
How to uncompress .sqz files (PostgreSQL custom-format dumps)
I have a *.sqz file that I want to uncompress.
file says it is "PostgreSQL custom database dump - v1.12-0", but I do not want to use PostgreSQL for the job.
I suppose the file is just a large bunch of ...
- 618
1
vote
2
answers
4k
views
pg_restore fails on zlib compressed dump
Created a dump of a postgresql (windows version 9.3 or 9.4) database with the command:
C:\>pg_dump -U user -Z 6 database > db.dump
restoring it with psql or pg_restore fails:
C:\>psql....
- 416
1
vote
1
answer
110
views
Why does my Postgres users have execute permission on a table?
I log in as a PostgreSQL superuser using psql, and issue a \dp, and the output contains the following line:
public | account | table | someuser=arwdx/someuser+|
If I ...
- 125
1
vote
2
answers
2k
views
How to move postgresql database from one computer to another?
I've been created an Internet service on Debian server. I want to move all data from one server to a new one.
So, how can I move the postresql database? What is the best pipeline?
- 147
1
vote
1
answer
9k
views
CentOS 7 install PostgreSQL dependency error
When running yum install postgresql-server.x86_64, I encounter the following error:
--> Processing Dependency: libreadline.so.5()(64bit) for package: postgresql-server-8.1.23-10.el5_10.x86_64
--&...
1
vote
1
answer
873
views
Is there a way to test Postgresql connection from VMware Fusion on a Mac?
I have some reasons to believe that VMware Fusion is not connecting to my postgresql database hosted on my Mac OS.
Is there a way to test this connection from my Windows portion through VMware?
- 719
1
vote
2
answers
4k
views
PhpPgAdmin: Edit contents
How can I edit the contents of a table in phpPgAdmin without using SQL? Or is there an alternative tool that allows me to edit datasets?
- 111
1
vote
2
answers
13k
views
How to configure Postgresql (Ubuntu)
I installed postgresql in ubuntu but I am unclear how to start or configure it for a local server (apache)
I tried typing (at the terminal prompt)
psql
but I am getting this error message:
psql: ...
- 779
1
vote
2
answers
963
views
How can I install Postgres GUI in Fedora 10?
On my server I have Postgres 8.4, but there is no GUI included, so I need to install one. Is that possible? How is it done?
chandrasekhar
1
vote
1
answer
77
views
PostgreSQL traffic analysis - Wireshark - how many bytes in total are being received by the client?
<TL;DR>
How many bytes are being received in total when a SELECT * command is issued for a (small) table?
</TL;DR>
I have a PostgreSQL table - very simple (see fiddle here):
CREATE TABLE ...
- 111
1
vote
1
answer
732
views
How to test in VSCode a postgreSQL SQL expression in Python's interactive notebook (= Jupyter Notebook, iPython) in a venv with package manager conda?
How to test in VSCode a postgreSQL SQL expression in Python's interactive notebook (= Jupyter Notebook, iPython) in a venv with package manager conda?
- 2,331
1
vote
1
answer
1k
views
PostgreSQL Client on SUSE Linux
On an SUSE Linux server I need the tools psql, pg_dump and pg_restore, without the whole database server installation. Other distributions provide an postgresql-client package (Ubuntu) but I am unable ...
- 1,318
1
vote
1
answer
2k
views
How to install pgBench on Mac Os Big Sur?
How can I install pgBench on mac os Big Sur . I have postgres 12.5 already installed and stack builder does not have the option to install pgbench . And once installed how to connect pgbench to a ...
darth_vader
1
vote
1
answer
2k
views
psql command not taking password from .pgpass file
psql -U postgres -h 127.0.0.1 postgres
I am using the above command to connect to the postgres running on my system. It asks for password
Whereas I have setup .pgpass file in the current directory ...
- 11
1
vote
3
answers
5k
views
cannot start postgres - not able to create lockfile
I have installed postgres from pacman repo on Manjaro but am running into trouble trying to get it to start.
I have followed the instructions from the arch wiki and have created my db. initdb -D /var/...
- 113
1
vote
1
answer
6k
views
dbeaver: Kerberos-auth PostgreSQL connection fails with "No LoginModules configured"
I'm trying to connect to a PostgreSQL server using GSSAPI (Kerberos) authentication using dbeaver. The command line psql client works nicely, and yet, the dbeaver connection fails, returning an error ...
- 712
1
vote
2
answers
5k
views
postfix virtual_alias_maps map lookup failed [fixed]
Running postfix on archlinux with virtual user configuration, I get the following error message:
postfix/cleanup[17859]: warning: 1C0F715008: virtual_alias_maps map lookup problem for < ...
- 11
1
vote
1
answer
2k
views
could not connect to database postgres: could not connect to server: No such file or directory
Freshly installed Debian Jessie. I've installed: aptitude install postgresql postgresql-contrib
root@vps: createuser
createuser: could not connect to database postgres: could not connect to server: ...
- 177
1
vote
1
answer
310
views
Connection timeout numbers for PostgreSQL
In PostgreSQL JDBC driver documentation, it is written:
The timeout value used for socket connect operations. If connecting to the server takes longer than this value, the connection is broken. The ...
- 167
1
vote
1
answer
748
views
IPTABES & Docker - Why can I not connect to containerized PostgreSQL services?
I am learning how to implement iptables rules. I currently have the following rules:
#!/bin/sh
iptables -F
iptables -P INPUT DROP
iptables -P OUTPUT DROP
iptables -P FORWARD DROP
iptables -A INPUT ...
- 115
1
vote
2
answers
243
views
Host a sql server for remote access when isp uses NAT
I want remote access to a postgresql(any free relational db) that I will set up at office.
However the static IP provided to me by my ISP is not the same as the IP I get when I use whatismyipaddress.
...
- 13
1
vote
1
answer
964
views
How do I use Postgres on Linux when the databases themselves reside on a Windows server?
I am using Oracle VirtualBox on a Windows host. The Windows host has a regular Windows file share. I want to use this folder for storage (of Postgres databases).
I know how to create Windows file ...
- 11
1
vote
1
answer
220
views
Populating fields in existing records in postgresql using record ID to determine what goes where
The Scenario
I have a postgresql database containing a list of product variants, which has been populated automatically, however, without the part numbers. I exported the table in order to run some ...
1
vote
1
answer
1k
views
Can not find script file prerun_checks.vbs when installing postgresql 9.4.4 on Windows x64
I am getting the following error in the bitrock_installer log when I try to install postgresql (postgresql-9.4.4-3-windows x64):
Script output:
Input Error: Can not find script file "C:\Users\...
- 21
1
vote
1
answer
81
views
NAS suitable for this situation?
I work from home and am considering getting a NAS. Would using a NAS be suitable for my situation:
I alternate working from a desktop and laptop, both of which run Linux
I use PostgreSQL a lot along ...
- 131
1
vote
1
answer
168
views
Check the contents of a PostgreSQL data directory
I have found an old unlabeled backup of mine with a PostgreSQL data directory in it. Is it possible to check its contents somehow, without installing PostgreSQL itself?
- 303