database dirs very stange on solaris
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
-----------------------------------------------------------------
You didn't mention which version either of those machines are running. I
believe in 7.1 Postgres the database filenames changed to a numerical
database id of some sort. Prior to that, they were named the same as the
database. I don't know the reasoning behind the switch, but I'm fairly sure
it was to make some future features easier to implement. Anyway, I suspect
that your Solaris machine is running a version of 7.1 (RC1?) while your
Linux box has 7.0.3?
Greg
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
Show quoted text
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
--------------------------------------------------------------------------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
Mart�n Marqu�s writes:
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
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
Of course you neglected to mention that those are two completely different
versions of PostgreSQL...
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/