Re: [GENERAL] How to determine initdb parameters on old database?

2006-10-23 Thread brian

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 [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly


Re: [GENERAL] How to determine initdb parameters on old database?

2006-10-22 Thread Joost Kraaijeveld
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


Re: [GENERAL] How to determine initdb parameters on old database?

2006-10-22 Thread brian

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/


[GENERAL] How to determine initdb parameters on old database?

2006-10-22 Thread Joost Kraaijeveld
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

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings