pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
HELP: I removed file pg_log, how can I recover?
2+ messages / 2 participants
[nested] [flat]

* HELP: I removed file pg_log, how can I recover?
@ 2007-11-09 23:27 joel zimmerli <baden32@yahoo.fr>
  2007-11-12 16:47 ` Re: HELP: I removed file pg_log, how can I recover? Scott Marlowe <scott.marlowe@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: joel zimmerli @ 2007-11-09 23:27 UTC (permalink / raw)
  To: pgsql-admin

I made a big mistake: I deleted the pg_log file and of course I've no backup of it. Now it seems I'm facing with big problem with my Postgres installation!

Actually, I'm running Postgres on Cobalt Raq4 server and Postgres is used to administrate virtual website definition.

As this is the "only" file I've deleted, is there a way to recover the data of this file?

Thank you in advnace for your help.

Joel




      _____________________________________________________________________________ 
Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail 

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: HELP: I removed file pg_log, how can I recover?
  2007-11-09 23:27 HELP: I removed file pg_log, how can I recover? joel zimmerli <baden32@yahoo.fr>
@ 2007-11-12 16:47 ` Scott Marlowe <scott.marlowe@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Scott Marlowe @ 2007-11-12 16:47 UTC (permalink / raw)
  To: joel zimmerli <baden32@yahoo.fr>; +Cc: pgsql-admin

On Nov 9, 2007 5:27 PM, joel zimmerli <baden32@yahoo.fr> wrote:
>
> I made a big mistake: I deleted the pg_log file and of course I've no backup
> of it. Now it seems I'm facing with big problem with my Postgres
> installation!

the pg_log directory on my machine just holds pg's log files.  No biggie.

> Actually, I'm running Postgres on Cobalt Raq4 server and Postgres is used to
> administrate virtual website definition.

I'm guessing this is an older version of postgresql, and you actually
mean you deleted the pg_xlog directory.

If this is the case then your database is toast

> As this is the "only" file I've deleted, is there a way to recover the data
> of this file?

pg_resetxlog for your version of postgresql might allow you to get it
up and running well enough to dump it out.  no promises.  google to
find it.  Search the archives on how it's used.  And stop deleting
things if you aren't sure what they do (unless you make a backup
first, etc...)



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2007-11-12 16:47 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-11-09 23:27 HELP: I removed file pg_log, how can I recover? joel zimmerli <baden32@yahoo.fr>
2007-11-12 16:47 ` Scott Marlowe <scott.marlowe@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox