Re: configuracion de postgresql

[dan rojas <danielrojass gmail com>]

Hola Mario, cuando dices que postgresql debe estar funcionado, es que la base
este corriendo ...verdad 

eso esta claro, ejecutare los comandos que me recomiendas ... ahora te envio
la siguiente información 
ya que el postgresql..segun yo es activo :

cuando inicializo base de datos 

daniel ubuntu:~$ su - postgres
Password:
postgres ubuntu:~$ mkdir -p /var/pgsql/data
postgres ubuntu:~$ chown postgres /var/pgsql/data
postgres ubuntu:~$ su - postgres
Password:
postgres ubuntu:~$ /usr/local/pgsql/bin/initidb -D /var/pgsql/data
-su: /usr/local/pgsql/bin/initidb: No such file or directory
postgres ubuntu:~$ /usr/local/pgsql/bin/initdb -D /var/pgsql/data
The files belonging to this database system will be owned by user
"postgres".
This user must also own the server process.

The database cluster will be initialized with locale C.

initdb: directory "/var/pgsql/data" exists but is not empty
If you want to create a new database system, either remove or empty
the directory "/var/pgsql/data" or run initdb
with an argument other than "/var/pgsql/data".

me dice que tengo que removerla o borrala para crear una nueva 


postgres ubuntu:~$ /usr/local/pgsql/bin/postmaster -D /var/pgsql/data
LOG:  database system was shut down at 2006-05-02 01:03:25 CLT
LOG:  checkpoint record is at 0/A38A70
LOG:  redo record is at 0/A38A70; undo record is at 0/0; shutdown TRUE
LOG:  next transaction ID: 544; next OID: 17230
LOG:  database system is ready                               ( esta activa )


cuando hago la prueba si esta arriba : 

daniel ubuntu:~$ netstat -aptn
(Not all processes could be identified, non-owned process info
 will not be shown, you would have to be root to see it all.)
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address           Foreign Address         State
PID/Program name
tcp        0      0 127.0.0.1:32769         0.0.0.0:*               LISTEN    
-
tcp        0      0 127.0.0.1:32770         0.0.0.0:*               LISTEN    
-
tcp        0      0 127.0.0.1:631           0.0.0.0:*               LISTEN    
-
tcp        0      0 127.0.0.1:5432          0.0.0.0:*               LISTEN    
-
tcp        0      0 127.0.0.1:49211         127.0.0.1:32769        
ESTABLISHED-
tcp        0      0 127.0.0.1:60962         127.0.0.1:631          
ESTABLISHED8812/gnome-cups-ico
tcp        0      0 127.0.0.1:631           127.0.0.1:60962        
ESTABLISHED-
tcp        0      0 127.0.0.1:32769         127.0.0.1:49211        
ESTABLISHED-
daniel ubuntu:~$ su
Password:
root ubuntu:/home/daniel# netstat -aptn
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address           Foreign Address         State
PID/Program name
tcp        0      0 127.0.0.1:32769         0.0.0.0:*               LISTEN    
8299/hpiod
tcp        0      0 127.0.0.1:32770         0.0.0.0:*               LISTEN    
8354/python
tcp        0      0 127.0.0.1:631           0.0.0.0:*               LISTEN    
8989/cupsd
tcp        0      0 127.0.0.1:5432          0.0.0.0:*               LISTEN    
9282/postmaster
tcp        0      0 127.0.0.1:49211         127.0.0.1:32769        
ESTABLISHED8354/python
tcp        0      0 127.0.0.1:60962         127.0.0.1:631          
ESTABLISHED8812/gnome-cups-ico
tcp        0      0 127.0.0.1:631           127.0.0.1:60962        
ESTABLISHED8989/cupsd
tcp        0      0 127.0.0.1:32769         127.0.0.1:49211        
ESTABLISHED8299/hpiod
root ubuntu:/home/daniel#

cual seria tu conclusión,  a todos esto.... estoy en la lista  u estado
buscando información toda la mañana 



--
View this message in context: http://www.nabble.com/configuracion-de-postgresql-t1264601.html#a4198657
Sent from the Gnome - Chile forum at Nabble.com.