On Tue, Jan 20, 2009 at 11:15 AM, Dennis C <dcswest@gmail.com> wrote:
> Greetings;
> And thanks for your reply! I tried the following:
> less xaa | grep "^;"
> "xaa" may be a binary file. See it anyway? y
> Binary file (standard input) matches
>
> And so am not sure which version I did the following from:
> pg_dump -c -F c -Z 9 [databasename]
It's kind of important, but... PostgreSQL's dump and restore commands
are designed to work from the same versions or going a new version
from an older version. Going backwards is not supported.
> But I installed it about a year ago, so whichever was the release then.
> Am trying to restore to the following:
8.2 or 8.3. Unless you were using a version supplied by a distro,
which could go further back.
> postgresql-client-7.4.21 PostgreSQL database (client)
> postgresql-plpython-7.4.21_1 A module for using Python to write SQL
> functions
> postgresql-server-7.4.21 The most advanced open-source database available
> anywhere
Now's the time to upgrade. 7.4 is the oldest supported version, which
means it's next for the chopping block. It's also A LOT slower than
8.3. Can you get and install a newer version of pgsql, preferably 8.3
and try restoring there?
> cat * | pg_restore -d [databasename]
The normal way to run it is to use the -f switch for the file
pg_restore -d dbname -f filename
Not sure there's anything wrong with your way, but I've never used
pg_restore like that.