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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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