Thread: database names are all numbers now
after i ran vacuum analyze, i see that all my database directories with respect to their database names have changed to all numbers: # ls -l /var/pgsql/data total 17 -rw------- 1 pgsql wheel 4 Dec 30 15:45 PG_VERSION drwx------ 6 pgsql wheel 512 Jan 8 05:28 base drwx------ 2 pgsql wheel 512 Jan 3 14:21 global -rw------- 1 pgsql wheel 7399 Dec 30 15:45 pg_hba.conf -rw------- 1 pgsql wheel 1118 Dec 30 15:45 pg_ident.conf drwx------ 2 pgsql wheel 512 Jan 8 16:45 pg_xlog -rw------- 1 pgsql wheel 595 Jan 8 04:14 postgresql.conf -rw------- 1 pgsql wheel 93 Jan 8 10:22 postmaster.opts -rw------- 1 pgsql wheel 22 Jan 8 10:22 postmaster.pid # ls -l /var/pgsql/data/base total 8 drwx------ 2 pgsql wheel 1536 Dec 30 16:02 1 drwx------ 2 pgsql wheel 1536 Dec 30 15:45 18719 drwx------ 2 pgsql wheel 2048 Jan 8 16:31 397915 drwx------ 2 pgsql wheel 1536 Jan 8 05:28 9829118 is this normal?
Thomas T. Thai writes: > after i ran vacuum analyze, i see that all my database directories with > respect to their database names have changed to all numbers: > is this normal? Yes, and it surely was like that before the vacuum analyze as well. This is new with 7.1. -- Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
On Tue, 9 Jan 2001, Peter Eisentraut wrote: > > after i ran vacuum analyze, i see that all my database directories with > > respect to their database names have changed to all numbers: > > > is this normal? > > Yes, and it surely was like that before the vacuum analyze as well. This > is new with 7.1. how would one now use symblinks to use another drive for one of the larger files? this is what i did with mysql before.
> Thomas T. Thai writes: > > > after i ran vacuum analyze, i see that all my database directories with > > respect to their database names have changed to all numbers: > > > is this normal? > > Yes, and it surely was like that before the vacuum analyze as well. This > is new with 7.1. > I am going to write a utility that will map file names to table names. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026