Set default password for Postgresql 9.1 on Ubuntu 12.04:
Open a terminal
sudo -u postgres psql postgres
(run psql client as a linux user postgres and connect to postgres database)
ALTER USER postgres WITH PASSWORD '<newpassword>';
(change password for user postgres to <newpassword>)
Just what I was looking for! Thanks!
ReplyDeletedobrze.
ReplyDeleteGracias !!!
ReplyDeleteOn OPEN SUSE remember to change pg_hba.conf settings. Otherwise you won't be able to log in to postgresql.
ReplyDeleteIn file /var/lib/pgsql/data/pg_hba.conf you should replace peer and ident authentication method with trust method, so this lines:
# "local" is for Unix domain socket connections only
local all all peer
# IPv4 local connections:
host all all 127.0.0.1/32 ident
… should be replaced on:
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust
please i need a help, i'm new in postgresql SGBDR, i installed it on ubuntu 12, and i can't open these files pg_hba.conf and postgresql.conf. when i perform this command:
ReplyDeletesudo gedit /ect/postgresql/9.1/main/postgresql.conf
or this one :
sudo gedit /ect/postgresql/9.1/main/pg_hba.conf
i'm invited to enter postgres password
[sudo] password for postgres:
when i enter the password i receive a message saying sorry, try again
please help ;e to understand what can be the problem.
You need to enter your 'root' password or a 'sudo user password'... Which means that only a superuser can edit the files in /etc/ folder. Alternatively you can login as root and just enter "gedit /ect/postgresql/9.1/main/pg_hba.conf"
Deleteplease is there any difference between a database postgres's password and a system postgres's password???? because i can login in pgamin with postgres and his password without a problem but to open config file or to restart the postgresql server, the same password is not going.
ReplyDeleteYES, of course there is a difference. Postgres is a linux user which postgresql runs on. To log in a linux postgres user you can first log in as root an then enter: su postgres.
DeleteOn the other hand you can log in as root, and enter:
"sudo -u postgres psql postgres" which will run the psql command as postgres user. Hope that helpful.
thanks a lot for your explanations, i will try what you said and let you know the result.
DeleteGOOOOOODDDD i logged as root user and i configured the two system files. now i need to restart the postgresql server. can i do it as root? or i must be a postgres user for that?
ReplyDeletei came back, please hier is my ip adress 198.168.178.139, i'm on windows 7, i installed postgresql on a virtual ubuntu machine wo has 192.168.255.139 like ip.
Deletenow i want to connect on the postgres server trough pgadmin on windows, here is what i place in the postgresql.conf : listen_addresses = '*' and
in the pg_hba.conf:
#Database administrative login by unix domain socket
local all postgres trust
# "local" is for unix domain socket connection only
local all all trust
# ipv4 local connection
host all all 192.168.178.139/32 md5
host all all 127.0.0.1/32 md5
host all all 192.168.0.0/24 md5
mit that configuration i still not having acces to the server on my windows pgadmin. but on ubunto in local there's no problem of connexion.
thanks for any help please.
You can restart postgres as root by entering: "service postgresql restart"
DeleteThere are only 2 things you need to do:
Deletea) set postgres password
b)allow remote access in pg_hba.conf
If that's a Virtual machine you need to have traffic enabled to and from the host and VM. Try sending pings to check whether the traffic is working properly.
yes the ping on the ubuntu OS ( 192.168.255.129) is going wihtout a problem. i've restarted the postgresql server. even like that i'm stell not have acces on postgres serveur from my host (pgadmin on windows 7)
Deletegreat tutorial!!! Tks a lot!
ReplyDeleteHow would I settle on the off chance that I overlook my Postgres User Password? Contact to Postgres SQL Support for Windows
ReplyDeleteAll things considered, on the off chance that you overlook your secret key when you entered amid Postgres Installation at that point rapidly check either overlooked or mistyped watchword to the default client of Postgres. Yet, in the event that you are not fulfilling in the wake of attempting these things then without a doubt in implies there is something urgent and you need to connect with a few experts to unravel this secret key related issue. Presently, you have one better alternative i.e. Postgres SQL Support for Linux or PostgreSQL Relational Database Service.
For More Info: https://cognegicsystems.com/
Contact Number: 1-800-450-8670
Email Address- info@cognegicsystems.com
Company’s Address- 507 Copper Square Drive Bethel Connecticut (USA) 06801
Unfit to Start Postgres After Changing to Nologin? Contact to Postgres SQL Support for Windows
ReplyDeleteThere might be where you find that your Postgres database can't begin as a result of some specialized issues. Be that as it may, with Cognegic's PostgreSQL Remote Database Service or Postgres SQL Support for Linux. In the event that you found that you Postgres Database is running gradually or neglecting to serve questions for any reason at that point don't squander your valuable time in scanning for another help supplier. Basically contact our specialized specialists and get the most confided in help which you never found in some other help.
For More Info: https://cognegicsystems.com/
Contact Number: 1-800-450-8670
Email Address- info@cognegicsystems.com
Company’s Address- 507 Copper Square Drive Bethel Connecticut (USA) 06801