pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDatabases there, tables away
2+ messages / 2 participants
[nested] [flat]
* Databases there, tables away
@ 2005-03-22 15:48 KÖPFERL Robert <robert.koepferl@sonorys.at>
0 siblings, 1 reply; 2+ messages in thread
From: KÖPFERL Robert @ 2005-03-22 15:48 UTC (permalink / raw)
To: pgsql-admin
Hi,
I am concerned.
I played around with test database clusters of postgres. I wanted to
simulate a WAL-Replay. So what I did was:
I have a data dir, where some databases exist.
I stressed them to produce a couple of Wal files.
Then I shut down postgres (SIGQUIT *hm*)
created + initdb'ed another dir
put the wal files in the pg_xlog
restarted the server on the new dir.
I made it wrong, so forget this dir and shut down postgres
So
restarting postgres on the former data directory lead to the
situation where all databases exist but with no objects populated. No table
no function. What can hav happened?
It is not do bar that someone else did something. But what can happen do a
data dir if postgres is run on another dir?
There's nothing lost, but I want to unterstand that
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Databases there, tables away
@ 2005-03-22 18:37 Tom Lane <tgl@sss.pgh.pa.us>
parent: KÖPFERL Robert <robert.koepferl@sonorys.at>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2005-03-22 18:37 UTC (permalink / raw)
To: KÖPFERL Robert <robert.koepferl@sonorys.at>; +Cc: pgsql-admin
=?ISO-8859-1?Q?K=D6PFERL_Robert?= <robert.koepferl@sonorys.at> writes:
> restarting postgres on the former data directory lead to the
> situation where all databases exist but with no objects populated. No table
> no function. What can hav happened?
Possibly you managed to reset the transaction counter to some point "in
the past"?
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-03-22 18:37 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-22 15:48 Databases there, tables away KÖPFERL Robert <robert.koepferl@sonorys.at>
2005-03-22 18:37 ` Tom Lane <tgl@sss.pgh.pa.us>
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