database dirs very stange on solaris - Mailing list pgsql-general

From Martín Marqués
Subject database dirs very stange on solaris
Date
Msg-id 01032919373701.00497@bugs
Whole thread Raw
Responses Re: database dirs very stange on solaris
List pgsql-general
check this:

On Solaris SPARC:

postgres@bugs:/space/local/pgsql > ls -l data/base/
total 15
drwx------   2 postgres staff        1536 Mar 29 10:57 1
drwx------   2 postgres staff        1536 Mar 29 10:10 18719
drwx------   2 postgres staff        1536 Mar 29 10:58 18723
drwx------   2 postgres staff        2048 Mar 29 10:58 18816
drwx------   2 postgres staff        1536 Mar 29 10:58 19057
drwx------   2 postgres staff        2560 Mar 29 10:58 19169
drwx------   2 postgres staff        1536 Mar 29 10:58 19941
postgres@bugs:/space/local/pgsql > psql -l
    List of databases
   Database   |  Owner
--------------+----------
 horde        | postgres
 lismarch     | postgres
 pruebas      | postgres
 resoluciones | postgres
 template0    | postgres
 template1    | postgres
 unl          | postgres
(7 rows)

postgres@bugs:/space/local/pgsql >

On Linux/Intel:

[postgres@math pgsql]$ ls -l data/base/
total 14
drwx------   2 postgres postgres     2048 Jan 29 12:16 horde
drwx------   2 postgres postgres     3072 Feb 27 09:51 katedra
drwx------   2 postgres postgres     3072 Feb 12 09:44 template1
drwx------   2 postgres postgres     4096 Jan 25 18:49 tesis
drwx------   2 postgres postgres     2048 Feb 12 19:01 test
[postgres@math pgsql]$ psql -l
        List of databases
 Database  |  Owner   | Encoding
-----------+----------+-----------
 horde     | postgres | SQL_ASCII
 katedra   | postgres | SQL_ASCII
 template1 | postgres | SQL_ASCII
 tesis     | postgres | SQL_ASCII
 test      | postgres | SQL_ASCII
(5 rows)

[postgres@math pgsql]$

Why does solaris use that horrable denomination for the different directories
of the databases?

Saludos... :-)

--
El mejor sistema operativo es aquel que te da de comer.
Cuida tu dieta.
-----------------------------------------------------------------
Martin Marques                  |        mmarques@unl.edu.ar
Programador, Administrador      |       Centro de Telematica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: missing data
Next
From: Soma Interesting
Date:
Subject: dynamic field names in a function.