Re: [GENERAL] unable to restore from a pgdump file

Thanks, Steve. You are exactly right. pg_restore was the right command to use! Janet On Feb 13, 2010, at 7:36 PM, Janet S Jacobsen wrote: Hi. I am trying to restore a database from a pgdump file, something that I've sucessfully done before. I created a new database cluster

Re: [GENERAL] could not read block 0... error followed by database does not exist

Thanks, Tom. I will give this a try and let you know what happens. I don't see anything in the logfile prior to the first could not read block 0... error. Thanks, Janet Janet S Jacobsen jsjacob...@lbl.gov writes: Hi. What I see when I do ls on the current (corrupt) $PGDATA/global

[GENERAL] unable to restore from a pgdump file

Hi. I am trying to restore a database from a pgdump file, something that I've sucessfully done before. I created a new database cluster, created the database that I want to restore using create database subptf with template = template0; and then I tried to restore the database using ./psql

[GENERAL] could not read block 0... error followed by database does not exist

Hi. I am running Postgres 8.2.7 on a Linux system for over a year now with no problems. Today one of the database users reported the following error: psql: FATAL: could not read block 0 of relation 1664/0/1262: read only 0 of 8192 bytes I tried stopping and restarting the Postgres

Re: [GENERAL] could not read block 0... error followed by database does not exist

: Janet S Jacobsen jsjacob...@lbl.gov writes: Hi. I am running Postgres 8.2.7 on a Linux system for over a year now with no problems. Today one of the database users reported the following error: psql: FATAL: could not read block 0 of relation 1664/0/1262: read only 0 of 8192 bytes Ugh