X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 7CB7611F6C68 for ; Mon, 24 Apr 2006 15:52:08 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 62778-07-3 for ; Mon, 24 Apr 2006 15:52:02 -0300 (ADT) X-Greylist: delayed 00:06:35.254734 by SQLgrey- Received: from smtp-01.arnet.com.ar (smtp-01.arnet.com.ar [200.45.191.24]) by postgresql.org (Postfix) with SMTP id 1747611F708C for ; Mon, 24 Apr 2006 15:04:07 -0300 (ADT) Received: (qmail 22799 invoked from network); 24 Apr 2006 14:56:26 -0000 Received: from unknown (HELO ?192.168.0.49?) (201.252.28.111) by smtp-01.arnet.com.ar with SMTP; 24 Apr 2006 14:56:26 -0000 Message-ID: <444D1185.8020905@gmail.com> Date: Mon, 24 Apr 2006 14:57:25 -0300 From: Martin Marrese User-Agent: Mail/News 1.5 (X11/20060228) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Trouble with pg_dump and sequences Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/248 X-Sequence-Number: 21417 Hi, I'm having problems trying to make a full backup of a database. I search in many places but I can't find where is te mistake of my procedure. I'm running this command: $ pg_dump -C -F P -o -h db1 -U postgres MAINDB > backup1 But I can't make pg_dump to backup all the sequences in the DB, only those that are asociated with a serial field column of a table are backed up. All the other things, such as table, data, stored procedures, triggers are backed up normaly. Also tried with -n SCHEMA, and with pg_dumpall but the results remains the same. I'm cofused about this, I don't see where is my mistake. Anyone can help me? My Architecture is : Postgres 8.0 running on a RedHat Enterprise 4, Gentoo an Debian. In this 3 machines I obtain the same result. Thanxs Martin -- Slds Martin Marrese (Debian GNU/Linux - SID) -- Cel: 1554824007 JID: kyheo en lugmen.org.ar MSN: martin en marrese.com.ar