Sorry to miss these points: 1. on first attempt, password 'postgres' is given assuming it would be the default password for the database user "postgres" 2. on second attempt, password of system user "ganu" is given
Regards, Ganapathy On 31 December 2014 at 02:44, Ganapathy S A <[email protected]> wrote: > Running postgresql 14.3.0 instance under smartos-20141225T170427Z. > Created a user for database purpose: > > > > *[root@psqlz ~]# useradd -c GanapathySA -d /home/ganu -m ganu[root@psqlz > ~]# su - ganuganu@psqlz:~$ svcs | grep postgres *online > 2:05:46 svc:/pkgsrc/postgresql:default > > Tried these but couldn't run psql successfully! > > *ganu@psqlz:~$ psql -U postgres *Password for user postgres: > psql: FATAL: password authentication failed for user "postgres" > > *ganu@psqlz:~$ sudo psql -U postgres *Password: > ganu is not in the sudoers file. This incident will be reported. > > */var/pgsql/data/pg_hba.conf* > # TYPE DATABASE USER ADDRESS METHOD > > # "local" is for Unix domain socket connections only > local all all password > # IPv4 local connections: > host all all 127.0.0.1/32 password > # IPv6 local connections: > host all all ::1/128 password > # Allow replication connections from localhost, by a user with the > # replication privilege. > #local replication postgres password > #host replication postgres 127.0.0.1/32 password > #host replication postgres ::1/128 password > host all all 192.168.1.102/32 password > > What am I missing here? Could someone please guide me in running psql > without issues? > > Regards, > Ganapathy > ------------------------------------------- smartos-discuss Archives: https://www.listbox.com/member/archive/184463/=now RSS Feed: https://www.listbox.com/member/archive/rss/184463/25769125-55cfbc00 Modify Your Subscription: https://www.listbox.com/member/?member_id=25769125&id_secret=25769125-7688e9fb Powered by Listbox: http://www.listbox.com
