| 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: | Whole Thread | Raw Message | 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 |