Thread: How to determine initdb parameters on old database?

How to determine initdb parameters on old database?

From
Joost Kraaijeveld
Date:
Is it possible to find out the parameters used with initdb on an old
database or is this a matter of deduction?

TIA

--
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
web: www.askesis.nl

Re: How to determine initdb parameters on old database?

From
brian
Date:
Joost Kraaijeveld wrote:
> Is it possible to find out the parameters used with initdb on an old
> database or is this a matter of deduction?
>
> TIA
>

pg_controldata - display control information of a PostgreSQL database
cluster

pg_controldata [ datadir ]

brian

Re: How to determine initdb parameters on old database?

From
Joost Kraaijeveld
Date:
On Mon, 2006-10-23 at 02:11 -0400, brian wrote:

> pg_controldata - display control information of a PostgreSQL database
> cluster
>
> pg_controldata [ datadir ]
I was hoping for the actual command but this suggests deduction ;-)

--
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
web: www.askesis.nl

Re: How to determine initdb parameters on old database?

From
brian
Date:
Joost Kraaijeveld wrote:
> On Mon, 2006-10-23 at 02:11 -0400, brian wrote:
>
>
>>pg_controldata - display control information of a PostgreSQL database
>>cluster
>>
>>pg_controldata [ datadir ]
>
> I was hoping for the actual command but this suggests deduction ;-)
>

That is it.

given:

PG_DIR=/usr/local/pgsql

do:

$PG_DIR/bin/pg_controldata $PG_DIR/data

or:

man pg_controldata

brian