PostgreSQL

PostgreSQL: Relevant Commands

Posted on

Connecting to Postgress Shell psql -U postgres -d postgres List Users select * from pg_shadow; usename | usesysid | usecreatedb | usesuper | usecatupd | passwd | valuntil | useconfig Change User Password   ALTER USER colin WITH PASSWORD ‘letmein’; Reference: http://www.davidpashley.com/articles/postgresql-user-administration/   MANAGE POSTGRES   PhpPGadmin : Install https://help.ubuntu.com/community/phpPgAdmin No se puede logear: http://www.unixmen.com/install-postgresql-and-phppgadmin-on-debian-7-wheezy/ Usuario […]

PostgreSQL

PostgreSQL: Not Listening

Posted on

http://stackoverflow.com/questions/12286886/postgresql-server-doesnt-listen ERROR 1 could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host “xxx.xxx.xxx.xxx” and accepting TCP/IP connections on port 5432? listen_addresses = ‘*’ in /etc/postgresql/9.1/main/postgresql.conf. ERROR 2 FATAL: no pg_hba.conf entry for host “xxx.xx.xxx.xxx”, user “postgres”, database “postgres”, SSL on FATAL Edit pg_hba.conf Add the following line: host     […]