Skip to content

Instantly share code, notes, and snippets.

@earthling-shruti
Created January 29, 2013 23:07
Show Gist options
  • Save earthling-shruti/4668868 to your computer and use it in GitHub Desktop.
Save earthling-shruti/4668868 to your computer and use it in GitHub Desktop.
Server started:
postgres@shruti-Inspiron-N5010:/home/shruti/git_stuff/grails_stuff$ /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data
LOG: database system was shut down at 2013-01-29 15:46:28 MST
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
-----------------------------------------------------------------------------------------------------------------------
Client connection error
postgres@shruti-Inspiron-N5010:~$ createdb mydb
createdb: could not connect to database postgres: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
----------------------------------------------------------------------------------------------------------------------
pg_hba.conf
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 trust
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment