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:   MANAGE POSTGRES   PhpPGadmin : Install No se puede logear: Usuario […]


PostgreSQL: Not Listening

Posted on ERROR 1 could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host “” 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 “”, user “postgres”, database “postgres”, SSL on FATAL Edit pg_hba.conf Add the following line: host     […]