People who code: we want your input. Take the Survey

Questions tagged [pg-dump]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
95 views

pg_dump complains PostgreSQL version 11 is not installed after installing postgres-client-13

We just upgraded our PostgreSQL servers to v13. We heavily use pg_dump on Ubuntu 18 systems to transfer data between databases. After upgrading the servers, pg_dump would complain about a version ...
0
votes
0answers
205 views

Not able to pg_dump due to permission, despite having root permissions

I am trying to run this command sudo pg_dump -U bm_clients -Z 9 -v baydb |aws s3 cp - s3://thebay.com/bay.dump.gz The output is as follows: pg_dump: reading extensions pg_dump: identifying extension ...
0
votes
1answer
72 views

how to run a bash backup script with simultaneous processes without getting stuck with infinite looping?

I wrote this script for run postgresql pg_dump of multiples schemas. Since it takes much time to finishes all i'd improved it by running simultaneous dumps with this: for SCHEMA in $SCH do while [ $(...
0
votes
1answer
43 views

Will the DB dump be consistent if a table is being inserted each second?

I want to create a consistent backup (dump) of a PostgreSQL database using sudo -u postgres pg_dump database_name > db_backup.sql. There some multiple tables that are being inserted a row each ...
1
vote
1answer
2k 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\/...
0
votes
1answer
509 views

Postgres pg_dump using compression - Keeping schema only for some tables

I am currently taking nightly exports of a Postgres 10.5 database, but taking schema only for 2 very large tables that I don't need the data for. I am compressing the export when done, and would ...
4
votes
1answer
2k views

Using pg_dump when connecting via a service

I connect to my postgres server using psql "service=subscription". How do I use the service with pg_dump? I tried to do the following: pg_dump -h "service=subscription" > /home/fogest/dump.out ...