| From: | "John P(dot) Looney" <valen(at)tuatha(dot)org> |
|---|---|
| To: | postgres <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Postgres db corrupted ? |
| Date: | 2003-07-29 09:28:10 |
| Message-ID: | 1059470890.5588.41.camel@cosimo.hosting365.ie |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
What's up here ? Google is deathly silent.
bash-2.05a$ pg_dumpall > db.out
connected to template1...
dumping database "MyPgSQLTest"...
dumping database "bb1"...
dumping database "bbadmin"...
pg_dump: [archiver (db)] connection to database "bbadmin" failed: FATAL
1: SetDatabaseEncoding(): invalid database encoding
pg_dump failed on bbadmin, exiting
Hmm. Curiously, the database I'm playing with;
bbadmin | | SQL_ASCII
Says it is SQL_ASCII...but it doesn't have an owner.
Would this mean the database is corrupt ? This is on 7.2.3 - I had been
running 7.1.3 and upgraded with the assistance pg_dumpall. Is this an
artifact of the upgrade ?
John
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dani Oderbolz | 2003-07-29 11:47:15 | Re: Partition DB Tables by month |
| Previous Message | Dani Oderbolz | 2003-07-29 09:27:38 | Script to recreate indexes? |