4

There isn’t a default password. The default authentication mode for PostgreSQL is set to ident, not to sql DB user/password. Running cat /var/lib/pgsql/9.3/data/pg_hba.conf will show you that. What that actually means is that in order correctly connect to PostgreSQL you must be logged in as the correct OS user that was used to install it. You practically ...


2

Assuming that you already have a PostgreSQL user bob, who corresponds to the system user bob with a home directory of /home/bob, and you wish to store PostgreSQL data under /home/bob/pg, which already exists and has permissions appropriate for access by the PostgreSQL database server, the following procedure may work, if you're running a relatively recent ...


1

I think that you are going to find that users cannot simply create their own Postgress database and have it properly integrated into the server function. I believe that several permissions greater than the simple user will be required. Furthermore, another problem you are going to run into is SELinux labeling. The new area would have to be properly ...


1

You're not trying to connect as root but as dbadmin. Your entry in pg_hba.conf should look like this: local all dbadmin peer map=mymap then you need to run psql with the user aswell: # psql -U dbadmin


1

Well, the default user is postgres and no password of a new installation. So in the user box put this and clear the password box. Click. done. If you used pgAdmin4 and entered a password on first login that is the password you using for the user postgres. Now in phppgadmin type postgres as user name and that password in the password box. Click. Done. Thank ...


Only top voted, non community-wiki answers of a minimum length are eligible