Results 1 to 2 of 2

Thread: PostgreSQL 9.1 Setup on Ubuntu 12 / 13 - Confusion with PSQL run

  1. #1
    Join Date
    Oct 2009

    PostgreSQL 9.1 Setup on Ubuntu 12 / 13 - Confusion with PSQL run

    My questions are on PostgreSQL and PSQL on Ubuntu. Hope this is the right place. I will post it on Server Platforms as well.
    I have installed PostgreSQL 9.1 on Ubuntu 13.04.
    I am a little confused on using PSQL.

    I have DBMS background with Oracle / MySQL, so I am expecting psql shell to behave with some similarities - after initial setup.

    1. On the Ubuntu doc it says after install to setup password for user: postgres:
    Log in using: sudo -u postgres psql postgres --- I am able to log in.

    2. Change password:
    \password postgres -- I am able to change password, asks for new password twice and accepts.

    3. Now I log out of the psql shell and expect I can directly run psql giving -d / -U options.
    So I run: psql -d postgres -U postgres -W
    Password for user postgres: -- Here I enter password I set up above
    psql: FATAL: Peer authentication failed for user "postgres"

    4. Also I had expected that if I just run psql I should get the psql command line like sqlplus or mysql.
    But it does not. - Says psql does not exist.

    5. So when I log in again using: sudo -u postgres psql postgres -- I run following commands:
    postgres=# select version();
    PostgreSQL 9.1.9 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 64-bit

    postgres=# select current_user;
    (1 row)

    postgres=# select current_database();
    (1 row)

    postgres=# select inet_server_port(); -- SHOULD this not return a port number: 5432?
    (1 row)

    postgres=# select inet_server_addr(); -- SHOULD this not return
    (1 row)

    My confusion with 3, 4 is I am expecting to log in with psql and not use sudo to get to the psql shell.

    Is there a setup aspect I am missing?

    Also, as I mention in point 2, I set the password with \password.
    It seems to completely ignore that.
    It does as the password if I run: sudo -u postgres psql postgres -W
    But logs in anyway if I run: sudo -u postgres psql postgres -- as well.

    Please note I am able to create database, roles etc. grant them and such.

    Put since I cannot run this command at bash:
    psql -d postgres -U postgres -W
    psql -U postgres (or user created)

    I cannot log in with those users.

    What do I do to bypass sudo as the psql command using args -d / -U / -W is makes sense to me but this command:
    sudo -u postgres psql postgres -- does not.

    Thank you for your help.


  2. #2
    Join Date
    Nov 2008
    S.H.I.E.L.D. 6-1-6
    Ubuntu Development Release

    Re: PostgreSQL 9.1 Setup on Ubuntu 12 / 13 - Confusion with PSQL run

    Hi, please do not post multiple threads with the same topic as this dilutes community effort.

    Don't waste your energy trying to change opinions ... Do your thing, and don't care if they like it.

Tags for this Thread


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts