On Mon, 2003-02-03 at 04:55, Aris wendy wrote:
> > You can use symbolic links, if your operating system allows them.
...
> > 4. Move the relevant directories from $PGDATA/base to the desired
> > locations on the other disks -- their parent directories should have the
> > same ownership and permissi
> You can use symbolic links, if your operating system allows them.
>
>
> 1. For safety, make a full backup with pg_dumpall.
>
> 2. Identify the database directories -- they are named by the oid of the
> database in pg_databases:
>
> template1=# select datname, oid from pg_database;
>
On Thu, 2003-01-30 at 04:11, Aris wendy wrote:
> I am a new comer in this millis. Can you help me how to configure the
> postgreSQL server which has some databases. I mean 5 databses is spread to
> different hardisk. For example a_db to hda1, b_db to hdb1, etc...
You can use symbolic links,
I am a new comer in this millis. Can you help me how to configure the
postgreSQL server which has some databases. I mean 5 databses is spread to
different hardisk. For example a_db to hda1, b_db to hdb1, etc...
TIA
Best regards
Aris Wendy
---(end of broadcast)-
