Re: BUG #15213: unable to login on PostgreSQL by postgres user

1.       Step : stope postgresql service $ sudo systemctl stop postgresql-9.3 and verify by command sudo systemctl status postgresql-9.3

2.       Created new directory/ location for db data ($ sudo mkdir postgresql)

3.       Sudo chown postgres:postgres postgresql

4.       Then copy all data by command (sudo rsync -av /var/lib/pgsql/9.3/data /opt/postgresql/)

5.       Login with (sudo –u postgres –i) on server

1. Open (vim /opt/postgresql/data/postgresql.conf)
2. Connented out (#data_directory = 'ConfigDir')
3. Added new line below above line (data_directory = '/opt/postgresql/data')

6.       Updated (sudo vim /usr/lib/systemd/system/postgresql-9.3.service) by adding (Environment=PGDATA=/opt/postgresql/data) line below line and commented line (#Environment=PGDATA=/var/lib/pgsql/9.3/data/) 7. unable to run show data_directory to verify data directory location due to below error same error