Hello!
I got into a situation I don't know how the get out ..
First, I could not access to my biggest database in postgre anymore
because it suddenly gave the error (after long time working with no
problems)
ERROR: could not open relation 1663/392281/530087: No such file
or directory
Af
On Fri, 2009-07-03 at 15:00 +0100, Vanessa Lopez wrote:
> I don't know much about postgre, I have no clue what else I can do.
> Please, please any help is very very much appreciated I have lots of
> databases and months of work in postgre (also lots of backups for the
> data in /data)
When you s
On Jul 4, 2009, at 8:06 AM, Craig Ringer wrote:
On Fri, 2009-07-03 at 15:00 +0100, Vanessa Lopez wrote:
I don't know much about postgre, I have no clue what else I can do.
Please, please any help is very very much appreciated I have lots of
databases and months of work in postgre (also lots of b
Hello,
Thanks for all your answers!
I discovered the table that was causing the error, delete it and
create it again (I miss some data but at least everything else is
working now)
Yes, for the backup we copy everything we had under /data (the
directory containing "base", "global", and so
Vanessa Lopez writes:
> What do you mean by we can't simply take a filesystem copy of a
> running database? :-O ... How should we then do the backups (so next
> time I will not have the same problem again) ?
Read the fine manual ...
http://www.postgresql.org/docs/8.3/static/backup.html
Sectio
On Friday 10 July 2009, Vanessa Lopez wrote:
> What do you mean by we can't simply take a filesystem copy of a
> running database? :-O ... How should we then do the backups (so next
> time I will not have the same problem again) ?
There is extensive documentation on how to do backups. For filesys
On Jul 10, 2009, at 6:47 AM, Vanessa Lopez wrote:
I discovered the table that was causing the error, delete it and
create it again (I miss some data but at least everything else is
working now)
Yes, for the backup we copy everything we had under /data (the
directory containing "base", "glo