/usr/pgsql-11/bin/pg_dumpall -p 5432 -U postgres -r | /usr/pgsql-11/bin/psql -p 5433
Related Posts
DELETE con LIMIT en Postgres
- Don Diego Puramagia
- 2019/10/04
- 0
Sucio y desprolijo: WITH cte AS ( SELECT my_rowid /* your PK */ FROM batch WHERE bat_close_time_stamp <= 1507381943.93144 /* your condition */ /* ORDER […]
Paranoid SQL Execution on Postgres
- Don Diego Puramagia
- 2021/07/06
- 0
Suppose that you want to be completely over-the-top paranoid about making sure that when you execute some particular SQL statement on your Postgres database, you’re […]
PostgreSQL Readonly User
- Don Diego Puramagia
- 2019/10/16
- 0
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 […]