Skip to content

Instantly share code, notes, and snippets.

@gisborne

gisborne/gist:3315906

Created August 10, 2012 17:24
Show Gist options
  • Save gisborne/3315906 to your computer and use it in GitHub Desktop.
Save gisborne/3315906 to your computer and use it in GitHub Desktop.
Download ZIP
pg_dump fails could not access file "$libdir/hstore": No such file or directory
Raw
gistfile1.txt
$ pg_dump -h localhost -U webserver -p 5433 production -f backup/12-08-10.dump
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR:  could not access file "$libdir/hstore": No such file or directory
pg_dump: The command was: COPY public.event_logs (id, auth_token, text, created_at, updated_at, user_id, data, remote_creation_date) TO stdout;
@apinsard
Copy link

apinsard commented May 16, 2016 •
edited
Loading

Had a similar issue as well. In my case I installed postgresql 9.5 and uninstalled postgresql 9.4 afterwards, without stopping postgresql 9.4 daemon. I had to kill postgresql process manually and delete PID/LOCK files in order to start postgresql-9.5 daemon.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment