By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,811 Members | 1,978 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,811 IT Pros & Developers. It's quick & easy.

Can't backup! pg_dump/pg_restore not updated with 7.4.1

P: n/a
Hello all,

I'm running a debian server and recently updated my version of
PostgreSQL to "unstable", that being v7.4.1. I had no trouble at all
getting everything up to date and going.

But my auto-database backup scripts do not work any more:

I get this error when I try to do a pg_dump with the new version of
Postgres:

pg_dump: server version: PostgreSQL 7.4.1 on i386-pc-linux-gnu,
compiled by GCC i386-linux-gcc (GCC) 3.3.3 20031206 (prerelease)
(Debian); pg_dump version: 7.3.4
pg_dump: aborting because of version mismatch (Use the -i option to
proceed anyway.)

So I try to force it, but when I want to restore it (I have to force
it again) I get:

pg_restore: [archiver (db)] could not execute query: ERROR: schema
"information_schema" already exists

I searched high and low over my hard drive in the debian packages and
the latest build I can get 7.3.4 of pg_dump/pg_restore. Does anyone
know how to get around this? Are people aware of this problem? Does
pg_dump/restore v7.4.1 exsist? Am I going to have to manually build it
from source?

Thanks in advance,
Aienthiwan
Nov 22 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.