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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org/

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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly