Most wanted question:
1. How do I access PostgreSQL through the network?
1.1. Open postgresql.conf (in Ubuntu 8.04 at /etc/postgresql/8.3/main/postgresql.conf) and change listen_addresses = ‘localhost’ to listen_addresses = ‘*’.
1.2. Uncomment password_encryption = on.
1.3. Open /etc/postgresql/8.3/main/pg_hba.conf
host all all [...]
Popularity: 1% [?]
Continue reading about Enable PostgreSQL access through the Network
From linux command prompt:
su – postgres
psql -d template1 -U postgres
alter user postgres with password ‘postgres_password’;
ctrl+d
Popularity: 1% [?]
Popularity: 1% [?]