In Fedora 20, when I installed PG on 2014-8-27, the PG version was 9.3.5.1 I do not know whether it will be automatically updated by the PG Development group or something else, but it is generally the latest version after installation.
Installation:
Yum install PostgreSQL yum install postgresql-server yum install pgadmin3 yum install postgresql-contrib yum update postgr Esql-setup initdb Systemctl Enable Postgresql.service
Use pgadmin3 directly, and then found the following error: Error connecting to the server: Fatal error: User "Postgres" Ident authentication failed to switch to Postgres user, #su-postgres $ps QL into the Postgres control shell, \PASSWD, specify the new password modification pg_hba.conf its authentication method from ident to MD5 and Pg_ctrl Restart, restart, easy to use.
But I have changed the user's password, cannot log in, thus did the following actions
Password Login:
1, edit pg_hba.conf, will MD5 certification modified into trust certification, edit and Exit save
[Postgres @ pgsqldb-master bin]$ VI. /data/pg_hba.conf
2, the implementation of PG_CTL reload load effective
[Postgres @ pgsqldb-master bin]$ pg_ctl Reload
Server signaled
3. Psql connection, change password with alter role
[Postgres @ pgsqldb-master bin]$ psql
Psql (9.2.3)
Type ' help ' for help.
postgres=# alter role postgres with password ' 123 ';
ALTER ROLE
postgres=#
4. Exit Psql
5, edit pg_hba.conf, will Turst certification modified to MD5 certification, edit and Exit save
6, the implementation of PG_CTL reload load effective
Installing the PostgreSQL database in Fedora 20