Re: ERROR: could not open segment 1 of relation 1663/743352/743420 (target block 6407642): No such file or directory - Mailing list pgsql-admin

From ALEXANDER JOSE
Subject Re: ERROR: could not open segment 1 of relation 1663/743352/743420 (target block 6407642): No such file or directory
Date
Msg-id SNT114-W53A0EA56F0BDE515EBC445A5200@phx.gbl
Whole thread Raw
In response to Re: ERROR: could not open segment 1 of relation 1663/743352/743420 (target block 6407642): No such file or directory  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Good morning

You have to revise the base folder to create postgres when you perform the initial installation and verify the relation fallanado that I spend And it turned out he had a folder in C: \ Program Files \ PostgreSQL \ 8.2 \ data \ base folder exists the number 1, this is where the file belongs to the database that lost the connection does not exist, determine why and try to copy again, delete the database that you are creating and then think again.


Alexander Angel
Venezuela


Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy! Try it!

pgsql-admin by date:

Previous
From: "Martin Münstermann"
Date:
Subject: Re: Migration of PGDATA
Next
From: Tom Lane
Date:
Subject: Re: Migration of PGDATA