469,134 Members | 1,290 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,134 developers. It's quick & easy.

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

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
0 1663

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Andrew E | last post: by
3 posts views Thread by Thiko | last post: by
2 posts views Thread by nt | last post: by
1 post views Thread by | last post: by
reply views Thread by raj.raghavan | last post: by
reply views Thread by Massimiliano Campagnoli | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.