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;
@dpwiz
Copy link

dpwiz commented Apr 5, 2013

I've had a similar problem when upgrading from 9.1 to 9.2 from postgres repository.

During a security upgrade apt were broken and i've reinstalled postgresql-9.1 whil accidentally forgoting to install postgresql-contrib-9.1 back. I've noticed that i really don't have hstore.so in my 9.1 library directory.

Installing the 9.1 contrib package solved the issue.

@HiGarethDavies
Copy link

I had the same issue just now trying to run a backup on a slave server, I didn't realise the master was using hstore, so the slave didn't have it.

Try installing postgres-contrib package, that fixed this for me (as it adds the hstore capability).

@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