Re: Postgres novice question

Bondok wrote:

On Nov 30, 9:54 pm, Michael Soibelman <in-...@xxxxxxxxx> wrote:
I am trying to use Postgres with another application and need to set up a
few things. To start out I tried logging in as the postgres superuser:

su postgres

where I am asked for the password. I've tried several passwords but none
work. What is the 'default' password after a new install on 10.3 ??

Thanks.

P.S. Tried my normal user password, my root password and 'admin'
and 'Admin".. and even left the password blank. None works.


You have to create one database user and one database schema. (Make
sure you create an Unicode database, otherwise the server won't start
correctly.)

The default superuser for PostgreSQL is called postgres. We will use
it below as an example. If you wish to use it as well, you may need to
login as this user first.

johndoe$ sudo su postgres
password: XXXXXXXXXX
postgres$

The default installation of PostgreSQL sets security to allow access
without password for localhost connections. This is called the trust
security model.

Yours,
Ahmed Samir - Managing Director


www.am4computers.com
Your online source for printing supplies, storage media, computer
paper,
hardware and accessories and full Business-to-Business e-procurement
services.


AM for Computers and Consulting
Heliopolis, Cairo
EGYPT

Thank you. That did it. Forgot to try using 'sudo' before the 'su
postgres' command. All is well :-)
.

Relevant Pages

  • Re: Postgres novice question
    ... To start out I tried logging in as the postgres superuser: ... You have to create one database user and one database schema. ... The default installation of PostgreSQL sets security to allow access ...
    (alt.os.linux.suse)
  • Re: PostgreSQL setup and use
    ... So now I have it installed and I try to create a database using ... I'm logged in as bpepers and just do "createdb foo" on the ... The pg_hba.conf is using "ident ... run createuser as postgres. ...
    (Fedora)
  • Re: Postgres PL/Python
    ... > I wonder if anyone on this list is using Python as Postgres ... It sounds like I have the whole Python ... code between database and clients when the clients are written in Python ...
    (comp.lang.python)
  • Re: Postrgres data restoration problem (which NG to post to?)
    ... I could not find a postgres group, nor a linux database group. ... what format is the backup in: is it a copy of the database ... Then, use psql to connect to template1, then restore the backup as ...
    (comp.os.linux.development.apps)
  • Re: PDO: Switch database user without reopening connection
    ... multiple users set up on my Postgres database with varying levels of ... the postgres user they are logged in as to one that can make ... modifications to the database as well (editors get update permission, ... Unless you are using persistent connections, there is not much use in changing. ...
    (comp.lang.php)