From: Adrian Klaver <adrian.klaver@gmail.com>
To: Kjell Øygard <kjellinge.oygard@ecc.no>
Cc: pgsql-sql@postgresql.org
Subject: Re: pg_restore problem
Date: Fri, 14 Sep 2012 07:58:08 -0700
Message-ID: <50534600.6050801@gmail.com> (raw)
In-Reply-To: <CAGo6514biGWXSzSUCoSQNbhQ9Q0bDS8i56c4TZ1ZXvV4b03OXw@mail.gmail.com>
References: <CAGo6516nqQet8j9CF4OirVogFFcwqO65ePco=C7OsZ3Np4HQtA@mail.gmail.com>
<5051E39B.3080803@gmail.com>
<CAGo6514biGWXSzSUCoSQNbhQ9Q0bDS8i56c4TZ1ZXvV4b03OXw@mail.gmail.com>
On 09/14/2012 01:58 AM, Kjell Øygard wrote:
> 1 - Ok, I was not aware of that....
> 2 - I used version 9.1.4 of pg_dump
> 3 - The command was in a script, se below
>
> pdir=/usr/local/postgresql-9.1.4/
> bdir=/backup/`hostname -s`/dump/
> export PATH=${pdir}/bin:$PATH
>
> # make sure tmp files are not readable by others
> umask 0077
>
> for db in `psql -l -t -h localhost | awk '{print $1}' |grep -v
> template|grep -v postgres`
> do
> pg_dump -h localhost -F c -Z -b $db > ${bdir}/${db}.tmp && mv
> ${bdir}/${db}.tmp ${bdir}/${db}.dump
I do not see anything obviously wrong.
Two suggestions.
1) Use the 9.2 version of pg_dump. Newer versions know about changes in
data handling and are also backward compatible(to 7.0).
2) As of 8.3(I believe) the -b switch is redundant for whole database dumps.
When you do the above dump are there large objects in the 9.2 database
in spite of the errors?
>
>
> rgds Kjell Inge Ø
>
--
Adrian Klaver
adrian.klaver@gmail.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: adrian.klaver@gmail.com, kjellinge.oygard@ecc.no
Subject: Re: pg_restore problem
In-Reply-To: <50534600.6050801@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox