From: | "Oscar" <oscardaniel(at)grupobbva(dot)net> |
---|---|
To: | <pgsql-es-ayuda(at)postgresql(dot)org> |
Subject: | Error en creación de base de datos |
Date: | 2004-05-05 20:54:59 |
Message-ID: | 004101c432e3$3c464660$65f03b0f@FRY |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
César/Alvaro:
Gracias por vuestra ayuda, pero sigo sin poder crear la base de datos en una ubicación diferente de la preestablecida.
Os adjunto las instrucciones que tecleo:
Con usuario "root":
----------------------------------------------------------------
1) cd /
2) mkdir DATA_PG
3) chown postgres:postgres DATA_PG
4) su - postgres
---------------------------------------------------------------
Con usuario "postgres"
--------------------------------------------------------------
bash-2.05b$ echo $PGDATA
/var/lib/pgsql/data
bash-2.05b$ echo $PGDATA2
/DATA_PG
bash-2.05b$ initlocation PGDATA2
The location will be initialized with username "postgres".
This user will own all the files and must also own the server process.
Fixing permissions on pre-existing directory /DATA_PG
Creating directory /DATA_PG/base
initlocation is complete.
You can now create a database using
CREATE DATABASE <name> WITH LOCATION = 'PGDATA2'
in SQL, or
createdb -D 'PGDATA2' <name>
from the shell.
bash-2.05b$ createdb -D 'PGDATA2' prueba
ERROR: Postmaster environment variable 'PGDATA2' not set
createdb: database creation failed
bash-2.05b$ createdb -D $PGDATA2 prueba
ERROR: Absolute paths are not allowed as database locations
createdb: database creation failed
bash-2.05b$ createdb -D /DATA_PG prueba
ERROR: Absolute paths are not allowed as database locations
createdb: database creation failed
bash-2.05b$ createdb -D /DATA_PG/data prueba
ERROR: Absolute paths are not allowed as database locations
createdb: database creation failed
-------------------------------------------------------------------
Como podeis ver no hay manera de crearla.
Necesito crearla ahí ya que es otra partición (incluso otro disco) con mucho espacio libre.
Gracias...
---------------------------------
Oscar
Madrid - España
--------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Patricio Muñoz | 2004-05-05 20:56:37 | Re: Consulta tablas temporarias |
Previous Message | Fernando Papa | 2004-05-05 20:43:14 | Re: Consulta tablas temporarias |