/usr/pgsql-11/bin/pg_dumpall -p 5432 -U postgres -r | /usr/pgsql-11/bin/psql -p 5433
Related Posts
Copiar una base de datos en Postgres
Para copiar una base, primero hay que tenerla sin usuarios conectados… los sacamos: SELECT pg_terminate_backend(pid) –* FROM pg_stat_activity WHERE pid <> pg_backend_pid() –and query = […]
Como ver el estado del servidor postgressql sin ser superuser
CREATE FUNCTION get_sa() RETURNS SETOF pg_stat_activity AS $$ SELECT * FROM pg_catalog.pg_stat_activity; $$ LANGUAGE sql VOLATILE SECURITY DEFINER; CREATE VIEW pg_stat_activity_allusers AS SELECT * FROM […]
PostgreSQL Readonly User
Rational When you create a user in postgresql, even with only select only permission, your user has a lot more privileges. Solution Connect with root […]