Обсуждение: anything not backed up by pg_dumpall ?
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 ?
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 ?
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