Trouble with postgresql
NickName:David Kim Ask DateTime:2015-07-17T22:02:36

Trouble with postgresql

I have uploaded a question about this but it hasn't been solved so I am re-posting it.

I am experiencing a problem in installing Postgresql on Ubuntu 14.04. What I did was:

  1. sudo su -
  2. sudo apt-get install postgresql postgresql-contrib
  3. update-rc.d postgresql enable
  4. service postgresql start

Doing #3, I got:

    update-rc.d: warning:  start runlevel arguments (none) do not match postgresql Default-Start values (2 3 4 5)
    update-rc.d: warning:  stop runlevel arguments (none) do not match postgresql Default-Stop values (0 1 6)
    Enabling system startup links for /etc/init.d/postgresql ...
    Removing any system startup links for /etc/init.d/postgresql ...
    /etc/rc0.d/K21postgresql
    /etc/rc1.d/K21postgresql
    /etc/rc2.d/S19postgresql
    /etc/rc3.d/S19postgresql
    /etc/rc4.d/S19postgresql
    /etc/rc5.d/S19postgresql
    /etc/rc6.d/K21postgresql
    Adding system startup for /etc/init.d/postgresql ...
    /etc/rc0.d/K21postgresql -> ../init.d/postgresql
    /etc/rc1.d/K21postgresql -> ../init.d/postgresql
    /etc/rc6.d/K21postgresql -> ../init.d/postgresql
    /etc/rc2.d/S19postgresql -> ../init.d/postgresql
    /etc/rc3.d/S19postgresql -> ../init.d/postgresql
    /etc/rc4.d/S19postgresql -> ../init.d/postgresql
    /etc/rc5.d/S19postgresql -> ../init.d/postgresql

In doing #4, I am getting this error:

    The PostgreSQL server failed to start. Please check the log output:
    2015-07-17 21:54:24 PHT LOG:  could not open secondary authentication file "@admins" as "/etc/postgresql/9.3/main/admins": No such file or directory
    2015-07-17 21:54:24 PHT LOG:  could not open secondary authentication file "@admins" as "/etc/postgresql/9.3/main/admins": No such file or directory
    2015-07-17 21:54:24 PHT LOG:  could not open secondary authentication file "@demodbs" as "/etc/postgresql/9.3/main/demodbs": No such file or directory
    2015-07-17 21:54:24 PHT LOG:  end-of-line before authentication method
    2015-07-17 21:54:24 PHT CONTEXT:  line 75 of configuration file "/etc/postgresql/9.3/main/pg_hba.conf"
    2015-07-17 21:54:24 PHT FATAL:  could not load pg_hba.conf

I thought I installed Postgresql correctly. What is wrong?

Copyright Notice:Content Author:「David Kim」,Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/31477677/trouble-with-postgresql

More about “Trouble with postgresql” related questions

Trouble with postgresql

I have uploaded a question about this but it hasn't been solved so I am re-posting it. I am experiencing a problem in installing Postgresql on Ubuntu 14.04. What I did was: sudo su - sudo apt-get

Show Detail

Trouble connecting to virtualbox postgresql on rails

I'm having trouble connecting to postgres from my local copy of rails. Postgresql is running on a virtualbox with user postgres, but when I try to run rake db:migrate, I get a FATAL: password

Show Detail

Having trouble in Connecting exist PostgreSQL in DBeaver

I'm having trouble with connecting my existing PostgreSql Database in DBeaver. This is message I received while connecting... > Connection to localhost:5432 refused. Check that the hostname and ...

Show Detail

trouble with moving data from PostgreSQL to Vertica

I want to move some tables from PostgreSQL to Vertica, but having trouble with saving column's types as they were. After moving table to Vertica all my columns' types are VARCHAR. To copy table from

Show Detail

Trouble starting postgresql

I just got a copy of a VM running SLES10 in which I have Postgresql. I try to start it using the command "postgresql start" but it returns an error message: "could not start postmaster". On the old

Show Detail

Trouble connecting to PostgreSQL database using libpqxx

I am using a simple C++ console app to communicate with a PostgreSQL 13 database. To do so, I use the libpqxx 7.3.1, and get some trouble when trying to connect to the database. Here is my code : #

Show Detail

Having trouble importing CSV file into PostgreSQL

I am a beginner with PostgreSQL, I am trying to import a csv file into pgAdmin4, but seem to be having some trouble. I have the CSV file saved on my desktop and there is no header in the CSV file. ...

Show Detail

Having trouble running postgresql with vagrant

So I'm working on a ruby on rails project with a team, and they use ubuntu through vagrant to host the database (in postgresql), so all the rails commands are still executed from the host machine (

Show Detail

Trouble with connecting PostgreSQL in docker-compose

I am trying to create a Laravel project on Docker with a PostgreSQL database locally. The structure of my project is described below: nginx conf.d default.conf php Dockerfile src Lar...

Show Detail

Bash Deployment of PostgreSQL - Installtion Trouble

I am trying to build postgreSQL from source on my Debian 6.0 server using a bash shell script but I am running into problems. This is the code I have made so far: # Initial apt-get update ...

Show Detail