pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
database creation date
2+ messages / 2 participants
[nested] [flat]

* database creation date
@ 2007-06-25 16:55 Pradeep Chandru <chandru.dba@gmail.com>
  2007-06-25 18:40 ` Re: database creation date Chris Browne <cbbrowne@acm.org>
  0 siblings, 1 reply; 2+ messages in thread

From: Pradeep Chandru @ 2007-06-25 16:55 UTC (permalink / raw)
  To: pgsql-admin

Hi,
  I have two questions.
1. Is there a way to find the database creation time?
2. Is WAL implementation possible in postgres7.1.1? If so simple steps for
the same? This is required to migrate from the older setup to the latest
version in parallel without disturbing the current setup.

Regards,
Pradeep Chandru.

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

* Re: database creation date
  2007-06-25 16:55 database creation date Pradeep Chandru <chandru.dba@gmail.com>
@ 2007-06-25 18:40 ` Chris Browne <cbbrowne@acm.org>
  0 siblings, 0 replies; 2+ messages in thread

From: Chris Browne @ 2007-06-25 18:40 UTC (permalink / raw)
  To: pgsql-admin

chandru.dba@gmail.com ("Pradeep Chandru") writes:

>                                                                                                                                                                           Hi,
>                                                                                                                                                         I have two questions.
>                                                                                                                         1. Is there a way to find the database creation time?

Elderly timestamps on files in the database's directory would be an
approximation to that.

>       2. Is WAL implementation possible in postgres7.1.1? If so
>       simple steps for the same? This is required to migrate from
>       the older setup to the latest version in parallel without
>       disturbing the current setup.

There isn't a reasonable way, as far as I know, to 'replicate' from
PostgreSQL 7.1 to anything newer.  

You would need to:

1. shut down all apps accessing the database, 

2. do a pg_dump to extract current data, 

3. load that into a newer version of PostgreSQL,

4. verify that all looks good, and

5. point the apps to the new database on the new version.

If the database is fairly large, the time between steps 1 and 5 could
be fairly substantial.

If you were on a newer version of PostgreSQL, say 7.3, you might be
able to use something like Slony-I to replicate data into a newer
version; that could make the outage time pretty short.

But PostgreSQL 7.1.1 is *very* old.
-- 
(reverse (concatenate 'string "ofni.secnanifxunil" "@" "enworbbc"))
http://cbbrowne.com/info/slony.html
"... the open research model is justified. There is a passage in the
Bible (John 8:32, and on a plaque in CIA HQ), "And ye shall know the
truth, and the truth shall set ye free." -- Dave Dittrich 



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


end of thread, other threads:[~2007-06-25 18:40 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-06-25 16:55 database creation date Pradeep Chandru <chandru.dba@gmail.com>
2007-06-25 18:40 ` Chris Browne <cbbrowne@acm.org>

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