pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedChecking database version
4+ messages / 3 participants
[nested] [flat]
* Checking database version
@ 2007-07-27 14:49 George Wilk <gwilk@ellacoya.com>
0 siblings, 2 replies; 4+ messages in thread
From: George Wilk @ 2007-07-27 14:49 UTC (permalink / raw)
To: pgsql-admin; +Cc: 'Gez Saunders' <gez.saunders@virgin.net>
Is there a reliable way of verifying version of the database by looking at
the PGDATA directory?
Let me explain why this is important in our case. Originally, our product
utilized version 8.1 of Postgres. We have since moved on to version 8.2.
Our existing customer base will need to be upgraded to version 8.2 as well.
There might be legitimate cases where our customers might be running other
software products on their systems, which utilize earlier versions of
Postgres, therefore we cannot uninstall earlier packages and install ours
indiscriminately. Our install scripts must reliably determine if the
database files related to our product need to be upgraded or not, before
installing Postgres 8.2 package, performing dump, etc.
What I'm looking for is a sure way of determining version of Postgres based
on the files contained in a specific PGDATA location. Is it possible, and
if so how can it be done?
Thanks in advance,
~george
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Checking database version
@ 2007-07-27 15:19 Richard Broersma Jr <rabroersma@yahoo.com>
parent: George Wilk <gwilk@ellacoya.com>
1 sibling, 1 reply; 4+ messages in thread
From: Richard Broersma Jr @ 2007-07-27 15:19 UTC (permalink / raw)
To: George Wilk <gwilk@ellacoya.com>; pgsql-admin; +Cc: Gez Saunders <gez.saunders@virgin.net>
--- George Wilk <gwilk@ellacoya.com> wrote:
> Is there a reliable way of verifying version of the database by looking at
> the PGDATA directory?
Does the file "PG_VERSION" not tell what you need?
Regards,
Richard Broersma Jr.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Checking database version
@ 2007-07-27 15:20 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: George Wilk <gwilk@ellacoya.com>
1 sibling, 0 replies; 4+ messages in thread
From: Kevin Grittner @ 2007-07-27 15:20 UTC (permalink / raw)
To: George Wilk <gwilk@ellacoya.com>; pgsql-admin; +Cc: 'Gez Saunders' <gez.saunders@virgin.net>
>>> On Fri, Jul 27, 2007 at 9:49 AM, in message
<02b201c7d05d$56cf9890$1f7ca8c0@ellacoya.com>, "George Wilk"
<gwilk@ellacoya.com> wrote:
> Is there a reliable way of verifying version of the database by looking at
> the PGDATA directory?
Could you use the first couple lines of output from pg_controldata?
-Kevin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Checking database version
@ 2007-07-27 15:43 George Wilk <gwilk@ellacoya.com>
parent: Richard Broersma Jr <rabroersma@yahoo.com>
0 siblings, 0 replies; 4+ messages in thread
From: George Wilk @ 2007-07-27 15:43 UTC (permalink / raw)
To: 'Richard Broersma Jr' <rabroersma@yahoo.com>; pgsql-admin
Yes, it does. However, in one test case after running dump, restoring, and
upgrading to 8.2 the PG_VERSION was still showing 8.1. This could have been
a result of us monkeying around, but still I wasn't sure when the PG_VERSION
was being updated, and whether it provided reliable source of versioning
information.
-----Original Message-----
From: Richard Broersma Jr [mailto:rabroersma@yahoo.com]
Sent: Friday, July 27, 2007 11:19 AM
To: George Wilk; pgsql-admin@postgresql.org
Cc: 'Gez Saunders'
Subject: Re: [ADMIN] Checking database version
--- George Wilk <gwilk@ellacoya.com> wrote:
> Is there a reliable way of verifying version of the database by looking at
> the PGDATA directory?
Does the file "PG_VERSION" not tell what you need?
Regards,
Richard Broersma Jr.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2007-07-27 15:43 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-07-27 14:49 Checking database version George Wilk <gwilk@ellacoya.com>
2007-07-27 15:19 ` Richard Broersma Jr <rabroersma@yahoo.com>
2007-07-27 15:43 ` George Wilk <gwilk@ellacoya.com>
2007-07-27 15:20 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
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