Postgres Pro
Downloads
Home   >   mailing lists

Thread: anything not backed up by pg_dumpall ?

anything not backed up by pg_dumpall ?

From
essam Ganadily
Date:
i am backing up my database with this batch file (win 10 with PostgreSQL 9.4 64 bit)

SET PGPASSWORD=11111
"C:\Program Files\PostgreSQL\bin\pg_dumpall.exe" --username=postgres --clean --superuser=postgres --host=127.0.0.1 --port=5432 -f dumbeveything.sql

anything in the database is NOT backed up by this ?

Re: anything not backed up by pg_dumpall ?

From
Shreeyansh Dba
Date:

On Tue, Oct 6, 2015 at 3:44 AM, essam Ganadily <doctoresam@gmail.com> wrote:
i am backing up my database with this batch file (win 10 with PostgreSQL 9.4 64 bit)

SET PGPASSWORD=11111
"C:\Program Files\PostgreSQL\bin\pg_dumpall.exe" --username=postgres --clean --superuser=postgres --host=127.0.0.1 --port=5432 -f dumbeveything.sql


Hi Essam,

Could you share ERROR what exactly you are getting on the screen after execution of the batch?


Rajesh Madiwale,
DBA,

anything in the database is NOT backed up by this ?

Re: anything not backed up by pg_dumpall ?

From
Albe Laurenz
Date:
essam Ganadily wrote:
> i am backing up my database with this batch file (win 10 with PostgreSQL 9.4 64 bit)
> 
> SET PGPASSWORD=11111
> "C:\Program Files\PostgreSQL\bin\pg_dumpall.exe" --username=postgres --clean --superuser=postgres --
> host=127.0.0.1 --port=5432 -f dumbeveything.sql
> 
> anything in the database is NOT backed up by this ?

No, this will back up the complete database.

The only things that you will lose are
a) objects you created in pg_catalog and
b) modifications to objects belonging to an extension.

But these things are unsupported anyway.

Yours,
Laurenz Albe