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.
558
questions
1
vote
0
answers
269
views
UTF8 error message in postgresql
I installed postgresql on windows using the guide on this page:
http://www.postgresqltutorial.com/
And I also loaded their dvdrental database from this site:
http://www.postgresqltutorial.com/...
1
vote
0
answers
1k
views
How to improve postgresql query execution time
Problem Statement:
we have a Enterprise product with Postgresql db as a backend. one of the tables has 5 columns and respective data type is (bigint time , bigint store_time , varchar category, ...
3
votes
1
answer
3k
views
Postgres SQL undefined symbol : pqsignal
Hi I am trying to install Postgres on my CentOS 7 server.
Installation was successful, But when I type psql I get this error
psql: symbol lookup error: psql: undefined symbol: pqsignal
I am ...
2
votes
1
answer
503
views
Why can't i open text editor when working with postgresql on terminal?
I know command "\e" when working with POSTGRESQL will open text editor so I can insert text and execute queries from there. But when I use "\e", the terminal just simply inserts a new line with ...
0
votes
1
answer
990
views
Postgresql pg_dump not working with anacron (cron.daily) on Ubuntu 18.04
I have two files called lb and z-backup. z-backup is a sh script placed in cron.daily which calls the lb (sh) script as an anacron job.
These are the files and their locations:
ls -l ~/bin/lb
-...
0
votes
2
answers
324
views
Pg_dump and rsync backup script not working in anacron
I have two sh scripts called Z-backup and lb. Z-backup is a script that I have placed in cron.daily so it is run as an anacron job and calls the lb script. The content of the Z-backup script is:
#!/...
1
vote
2
answers
2k
views
SSL certificate error when connecting to PostgreSQL database with Oracle SQL Developer on Fedora 30
I have a postgresql 9.3 database running in a RHEL 6.2 kvm virtual machine. It's part of the application I support for work, and I cannot make any configuration changes to the contents of the VM ...
1
vote
0
answers
185
views
postgresql configuration for gitlab
Does anybody know how to configure an external postgresql db instance for gitlab by stopping existing postgresql db.
I have configured and getting below error :
There was an error running gitlab-ctl ...
1
vote
1
answer
102
views
Why do I get error "/var/lib/pgsql/.role.sh: not found" from postgres in docker?
I have PostgreSQL running in Docker. The host system is Ubuntu 18.04.3. Every time I execute some SQL in PostgreSQL I get
/var/lib/pgsql/.role.sh: not found
Does anyone know why this is or at least ...
0
votes
1
answer
2k
views
Error installing Postgres on Mac
I'm trying to install Postgres on my Mac using brew but for some reason it's unable to finish the installation and is displaying the error below.
"initdb: file "/usr/local/share/postgresql/postgres....
0
votes
1
answer
907
views
pg_dump with -w flag does not read from .pgpass file
I am trying to backup my PostgreSQL database called crewdb on Ubuntu 18.04 LTS from a script with the following command in it:
pg_dump -h localhost -p 5432 -U postgres -w -C -F p -b -v -f ~/Dropbox\/...
-2
votes
1
answer
196
views
All my tables inserted with a .sql file are gone when I close a session in Postgres
So I'm new to psql so sorry for the noob question. Not sure if relevant but I'm using Ubuntu 19.04 installed on a USB stick with persistent memory (used mkdisk). Everything works fine but I have ...
1
vote
0
answers
83
views
Can't add new System ODBC to PostgreSQL db
I am working on HP 64-bit machine on Windows 10.
Already have a working System ODBC connection to a "Production" PosgreSQL db, it is postgreSQL ANSI(x64), using it for a while now.
The problem is, ...
0
votes
0
answers
59
views
Snapshot a database by creating a copy
As part of backup script I want to create a consistent backup of my application and database by stopping the service and then creating snapshots of database and file system.
With PostgreSQL I can ...
0
votes
0
answers
28
views
PostrgreSQL not portforwarding
Im having an ubuntu server 16.04 that i have installed postgresql server onto with ufw but even after allowing the port 5432 and as well as checking the conf for postgresql.
I even tried follow ...