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.
> >
>
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 s
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 writes:
> > Hi. What I see when I do ls on the current (corrupt)
:
> Janet S Jacobsen 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
&
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 server
