Hola Ricardo Eureka!:
2006/11/2, Marcos Guglielmetti <[email protected]>:
Hola Ricardo Eureka!:
mmm como instalaste el postgresql?
apt-get
te acordas el nombre del/los paquetes?
sudo apt-get install postgresql-8.1 libqt3-mt-psql Se instalarán los siguientes paquetes extras: postgresql-client-8.1 postgresql-client-common postgresql-common ssl-cert Se instalarán los siguientes paquetes NUEVOS: libqt3-mt-psql postgresql-8.1 postgresql-client-8.1 postgresql-client-common postgresql-common ssl-cert
Por otro lado creo recordar que hay un postgresql-server a instalar, verificalo con:
sudo aptitude search postgresql
Está instalado (gracias por la ayuda igual, entre gente que en vez de ayudar juzgó la creencia/ciencia, esta ayuda es valiosa!)
0 actualizados, 6 se instalarán, 0 para eliminar y 915 no actualizados. Se necesita descargar 5891kB/5930kB de archivos. Se utilizarán 17,2MB ..................................................................
* Y para administrar la base de datos se necesita:
* El problema es que no puedo iniciar postgresql:
sudo ./postgresql-8.1 start Starting PostgreSQL 8.1 database server: main* Insecure directory in $ENV{PATH} while running with -T switch at /usr/bin/pg_ctlcluster line 52. failed!
Fijate que aca no introducis lo que yo te indique: sudo /etc/init.d/postgresql-8.1 start
Es porque estoy en ese directorio: /etc/init.d/, por eso sólo hago sudo ./postgresql-8.1 start Si lo hago del modo en que me dijiste, sucede lo mismo, ya respondí a eso.
Intenta entrar a la bbdd desde linea de comandos para verificar que este corriendo
No sé cómo se hace eso.
y, ademas, corrobora la configuracion del pg_hba.conf para ver si esta aceptando las peticiones que necesita es programa, el cual no tengo NPI como funciona, por cierto.
Les muestro ph_hba.conf (GRACIAS): # PostgreSQL Client Authentication Configuration File # =================================================== # # Refer to the PostgreSQL Administrator's Guide, chapter "Client # Authentication" for a complete description. A short synopsis # follows. # # This file controls: which hosts are allowed to connect, how clients # are authenticated, which PostgreSQL user names they can use, which # databases they can access. Records take one of these forms: # # local DATABASE USER METHOD [OPTION] # host DATABASE USER CIDR-ADDRESS METHOD [OPTION] # hostssl DATABASE USER CIDR-ADDRESS METHOD [OPTION] # hostnossl DATABASE USER CIDR-ADDRESS METHOD [OPTION] # # (The uppercase items must be replaced by actual values.) # # The first field is the connection type: "local" is a Unix-domain socket, # "host" is either a plain or SSL-encrypted TCP/IP socket, "hostssl" is an # SSL-encrypted TCP/IP socket, and "hostnossl" is a plain TCP/IP socket. # # DATABASE can be "all", "sameuser", "samerole", a database name, or # a comma-separated list thereof. # # USER can be "all", a user name, a group name prefixed with "+", or # a comma-separated list thereof. In both the DATABASE and USER fields # you can also write a file name prefixed with "@" to include names from # a separate file. # # CIDR-ADDRESS specifies the set of hosts the record matches. # It is made up of an IP address and a CIDR mask that is an integer # (between 0 and 32 (IPv4) or 128 (IPv6) inclusive) that specifies # the number of significant bits in the mask. Alternatively, you can write # an IP address and netmask in separate columns to specify the set of hosts. # # METHOD can be "trust", "reject", "md5", "crypt", "password", # "krb5", "ident", or "pam". Note that "password" sends passwords # in clear text; "md5" is preferred since it sends encrypted passwords. # # OPTION is the ident map or the name of the PAM service, depending on METHOD. # # Database and user names containing spaces, commas, quotes and other special # characters must be quoted. Quoting one of the keywords "all", "sameuser" or # "samerole" makes the name lose its special character, and just match a # database or username with that name. # # This file is read on server startup and when the postmaster receives # a SIGHUP signal. If you edit the file on a running system, you have # to SIGHUP the postmaster for the changes to take effect. You can use # "pg_ctl reload" to do that. # Put your actual configuration here # ---------------------------------- # # If you want to allow non-local connections, you need to add more # "host" records. In that case you will also need to make PostgreSQL listen # on a non-local interface via the listen_addresses configuration parameter, # or via the -i or -h command line switches. # # DO NOT DISABLE! # If you change this first entry you will need to make sure that the # database # super user can access the database using some other method. # Noninteractive # access to all databases is required during automatic maintenance # (autovacuum, daily cronjob, replication, and similar tasks). # # Database administrative login by UNIX sockets local all postgres ident sameuser # TYPE DATABASE USER CIDR-ADDRESS METHOD # "local" is for Unix domain socket connections only local all all ident sameuser # IPv4 local connections: host all all 127.0.0.1/32 md5 # IPv6 local connections: host all all ::1/128 md5
* Skylendar hace un crash y sale luego de que ingreso nombre de base de datos y esas cosas que me pregunta. (también hacía el crash antes de instalar postrgresql)
-- Marcos Guglielmetti * Director del desarrollo de Musix GNU+Linux, 100% Software Libre * CD Donwload: (http://www.musix.org.ar/en/) * Videos, programas y otras cosas en: ftp://musix.ourproject.org/pub/musix/ * Reporte de errores a: https://www.musix.org.ar/wiki/index.php?title=Problemas-Bugs *IRC: #musix channel on freenode * Torrent Download: https://e.ututo.org.ar/utiles/torrent/MusixGNU-Linux0.59.iso.torrent
-- Marcos Guglielmetti * Director del desarrollo de Musix GNU+Linux, 100% Software Libre * CD Donwload: (http://www.musix.org.ar/en/) * Videos, programas y otras cosas en: ftp://musix.ourproject.org/pub/musix/ * Reporte de errores a: https://www.musix.org.ar/wiki/index.php?title=Problemas-Bugs *IRC: #musix channel on freenode * Torrent Download: https://e.ututo.org.ar/utiles/torrent/MusixGNU-Linux0.59.iso.torrent