Stack Overflow
Stack Overflow

Questions tagged [pg-dumpall]

27 questions
8
votes
1 answer

pg_dumpall without prompting password

We are trying to automate the backup of all PostgreSQL databases of a cluster, and we decided to use 'pg_dumpall' utility. But we couldn't find a way to execute 'pg_dumpall' without prompting password. We are using PostgreSQL-10. We are trying to…
jithin giri
  • 733
  • 2
  • 6
  • 17
6
votes
1 answer

How to run pg_dump/pg_dumpall command on Linux?

Hello everyone i am try to create backup in postgres through dump. when i run the command through command line it wants password when i give the password it will give some error pg_dump: [archiver (db)] connection to database "nsdgpkidb" failed:…
Vivek Kumar Ray
  • 8,323
  • 5
  • 21
  • 28
3
votes
1 answer

pg_dumpall - Azure Database for PostgreSQL - permission denied for database "azure_maintenance"

PGPASSWORD=mypassword pg_dumpall -h mydbname.postgres.database.azure.com -p 5432 -U admin@mydbname pg_dump: [archiver (db)] connection to database "azure_maintenance" failed: FATAL: permission denied for database "azure_maintenance" DETAIL:…
sirkubax
  • 885
  • 2
  • 10
  • 19
3
votes
1 answer

Can Npgsql dump/restore an entire database?

Is it possible to use Npgsql in a way that basically mimics pg_dumpall to a single output file without having to iterate through each table in the database? Conversely, I'd also like to be able to take such output and use Npgsql to restore an…
G_Hosa_Phat
  • 976
  • 2
  • 18
  • 38
2
votes
1 answer

Custom format (-Fc) when backing up postgres with pd_dumpall instead of pg_dump

pg_dump has a great option, it allows you to select custom format for the output of the backup. Output a custom-format archive suitable for input into pg_restore. Together with the directory output format, this is the most flexible output format in…
ald
  • 31
  • 5
1
vote
0 answers

Duplicating an entire RDS instance PostgreSQL DB to another DB within the same instance

I'm trying to create a new DB (as a perfect copy of an existing RDS Instance DB, including data) when developers open a pull request. Since it's temporary, I need it to be created as fast as possible, and therefore I would not want to create a new…
Sammy
  • 3,395
  • 7
  • 49
  • 95
1
vote
1 answer

How can I run pg_dumpall with Heroku?

How can I use pg_dumpall with Heroku? The default "database backup" feature from Heroku is pg_dump with the click of a button, which doesn't include roles, so I want to do pg_dumpall ... I'm trying pg_dumpall -h myherokuurl.compute-1.amazonaws.com…
George Pickett
  • 71
  • 1
  • 1
  • 11
1
vote
1 answer

How to pg_dumpall from remote server to local machine and local machine to remote server

I need to do the new installation for which i need to copy my database from current installation. i need the pg_dumpall command for remote server to local machine. I have already tried this but it works only for dump and doesnt work for…
jagtar
  • 23
  • 8
1
vote
2 answers

Can I use pg_dumpall withtout installing postgresQL?

I tried in my docker container(from alpine3.6) to run command to install pg_dumpall I've seen in the web: apk update && apk upgrade and then apk add --no-cache postgresql-client-common and finally apk add --no-cache postgresql-client Only the…
Ayra
  • 328
  • 2
  • 12
1
vote
2 answers

PostgreSQL Backup from pg_dumpall (Ubuntu)

I was tasked with writing a python script to backup our current instance of Alfresco ECM. The backup works like a charm. I am running into problems with restoring PostgreSQL from the text dump .sql file. Here is my command: psql -f…
sruffatti
  • 37
  • 3
0
votes
0 answers

postgres backup restoration failing

I am trying to restore backup taken by pg_dumpall (filesize 16 GB) command: psql -f backup_filename but it is showing me out of memory error and process stops. During restore when I see duplicate window using top command it is showing 100% cpu…
jadhav aniket
  • 1
0
votes
1 answer

Necessary Camunda db tables for application to run

I have a bash script that dumps globals and all schemas in cluster but dumps data only from 1 schema then imports the dump files in a new database inside a docker container. Anything regarding Camunda is in a separate schema (not the one which data…
dev-rifaii
  • 217
  • 2
  • 9
0
votes
0 answers

Export a postgresql database

I want to export a postgresql database named "kd" with all roles, tablespaces, etc. I run the command pg_dumpall -U sce -h localhost -p 5450 -d kd > /tmp/db.sql I get the error pg_dumpall: missing "=" after "kd5" in connection info string I run…
mourad semi
  • 47
  • 5
0
votes
1 answer

how to decompress .sql extension file in windows server

I have taken full backup of postgresql database which consists of 100 databases. The backup format is .sql (eg pg_dumpall.exe -U postgres > D:\Backup\fullbkp.sql) now one of my database got crashed and I want to extract this file to get that…
Sadamh Hussain
  • 1
  • 2
  • 6
0
votes
0 answers

Migrating db from pgsql 9.5 to 12.4 via pg_dumpall does not include all tables

I am trying to migrate three databases to a new server (Linux centos 8 - pgsql 12.4) So I am using "pg_dumpall" and target the old server - backups are getting created, then I am using psql to import the dump. I noticed that in one db there are…
Marc
  • 1
1
2