pgdump question

From: Kenny H Klatt <kklatt(at)csd(dot)uwm(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: pgdump question
Date: 2002-06-18 16:28:56
Message-ID: 20020618162856.GA32085@alpha3.csd.uwm.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi:
PGVERSION=7.2

I have a backup/restore question. Reading the manpages from pg_dump
I have noticed a reference to the -o qualifier for OIDS.. Following a
somewhat general model where an administrator is responsible for backups
and restores of the database, the admin may not know how an application
programmer uses postgres (oid reference for example)..

If the database backup uses the following call to pg_dump, is there
any information or object that is not in the backup where PGDB is the
name of the database, PGEXPORT is directory for the dump, and PGDB-DATE
is the pg_dump file name? The backup plan assumes all postgress on the machine
databases are included in the backup. Would for example groups be included
in the backup?

pg_dump -Ft -b -o $PGDB > $PGEXPORT/$PGDB-$DATE.pgtar

Ken Klatt

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2002-06-18 16:30:16 Re: db grows and grows
Previous Message Scott Marlowe 2002-06-18 16:14:58 Re: Wierd Explain