Skip site navigation (1) Skip section navigation (2)

database dirs very stange on solaris

From: Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar>
To: <pgsql-general(at)postgresql(dot)org>
Subject: database dirs very stange on solaris
Date: 2001-03-29 16:37:37
Message-ID: 01032919373701.00497@bugs (view raw or flat)
Thread:
Lists: pgsql-general
check this:

On Solaris SPARC:

postgres(at)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(at)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(at)bugs:/space/local/pgsql >

On Linux/Intel:

[postgres(at)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(at)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(at)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(at)unl(dot)edu(dot)ar
Programador, Administrador      |       Centro de Telematica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------

Responses

pgsql-general by date

Next:From: Tom LaneDate: 2001-03-29 16:43:43
Subject: Re: [SQL] inconsistent functionality with LIKE operator
Previous:From: Alvar FreudeDate: 2001-03-29 16:35:37
Subject: Re: Inserting possible dublicate unique keys

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group