/usr/pgsql-11/bin/pg_dumpall -p 5432 -U postgres -r | /usr/pgsql-11/bin/psql -p 5433
Related Posts
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 […]
Foreign data wrappers en Postgres
- Don Diego Puramagia
- 2017/11/03
- 0
Quien no se encontro alguna vez con la necesidad de traer algun dato desde un SQL Server a un Postgres…??? Bien, tenia esto: Un postgres […]
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 […]