Received: from mail.interchange.ca (ns.interchange.ca [216.126.79.2]) by hub.org (8.10.1/8.10.1) with ESMTP id e71IWaB60804 for ; Tue, 1 Aug 2000 14:32:36 -0400 (EDT) Received: by mail.interchange.ca (Fastmailer, from userid 555) id B2C4A9CA3; Tue, 1 Aug 2000 14:32:27 -0400 (EDT) MIME-Version: 1.0 Message-Id: <398717BB.00003D.01145@frodo.searchcanada.ca> Content-Type: Multipart/Mixed; boundary="------------Boundary-00=_36MMSPG00M3NTT4D7TH0" To: pgsql-sql@postgresql.org Subject: Re: on line numbers, drop table errors, and log files Cc: jlapham@gandalf.bioqmed.ufrj.br From: "Michael Richards" X-Fastmail-IP: 24.42.110.18 Date: Tue, 1 Aug 2000 14:32:27 -0400 (EDT) X-Archive-Number: 200008/5 --------------Boundary-00=_36MMSPG00M3NTT4D7TH0 Content-Type: Text/Plain Content-Transfer-Encoding: 7bit Hi. Here are the options for pg_dump: -a dump out only the data, no schema -c clean (drop) schema prior to create -d dump data as INSERT, rather than COPY, commands -D dump data as INSERT commands with attribute names -h server host name -i proceed when database version != pg_dump version -n suppress most quotes around identifiers -N enable most quotes around identifiers -o dump object ids (oids) -p server port number -s dump out only the schema, no data -t dump for this table only -u use password authentication -v verbose -x do not dump ACL's (grant/revoke) So you are dumping it with the following: Proper INSERT commands/attribs, pwd auth, data only I would consider running: pg_dump -D -u -c -f backup.dump This will dump the schema and drop the objects before creating them. -Michael > 4) I run pg_dump this way: "pg_dump -D -u -a -f backup.dump > main_v0_6" in order to create a backup of my "main_v0_6" database. > In order to regenerate the database, I first run a "\i > create_tables.sql" script, then I run "\i backup.dump". However, > I end up having to hand edit the "backup.dump" file to place "drop > sequence" statements before the "create sequence" statements > because they are created by my "create_tables.sql" script. I'm > sure you Postgres gurus out there are not doing it this way, what > is your method of database backup/recovery? _________________________________________________________________ http://fastmail.ca/ - Fast Free Web Email for Canadians --------------Boundary-00=_36MMSPG00M3NTT4D7TH0--