Check the installed version(s) of pg_dump: find / -name pg_dump -type f 2>/dev/null My output was: /usr/pgsql-9.3/bin/pg_dump /usr/bin/pg_dump There are two versions installed. To update pg_dump with the newer version: sudo ln -s /usr/pgsql-9.3/bin/pg_dump /usr/bin/pg_dump –force This will create the symlink to the newer version.
Postgres 9.2 I quote Andrew Dunstan on the pgsql-hackers list: At some stage there will possibly be some json-processing (as opposed to json-producing) functions, but not in 9.2. Doesn’t prevent him from providing an example implementation in PLV8 that should solve your problem. (Link is dead now, see modern PLV8 instead.) Postgres 9.3 Offers an … Read more
What bout this query (based on the description from manual)? SELECT table_name FROM information_schema.tables WHERE table_schema=”public” AND table_type=”BASE TABLE”;
You can prevent future connections: REVOKE CONNECT ON DATABASE thedb FROM public; (and possibly other users/roles; see \l+ in psql) You can then terminate all connections to this db except your own: SELECT pid, pg_terminate_backend(pid) FROM pg_stat_activity WHERE datname = current_database() AND pid <> pg_backend_pid(); On older versions pid was called procpid so you’ll have … Read more
GRANT on the database is not what you need. Grant on the tables directly. Granting privileges on the database mostly is used to grant or revoke connect privileges. This allows you to specify who may do stuff in the database if they have sufficient other permissions. You want instead: GRANT ALL PRIVILEGES ON TABLE side_adzone … Read more
You can enter the following psql meta-command to get some details about a specified database, including its size: \l+ <database_name> And to get sizes of all databases (that you can connect to): \l+