Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
pg_dump mydb > mydb.dmp
postgres=#drop database mydb; postgres=#create database mydb; postgres=#grant all privileges on database mydb to myuser;
psql mydb < mydb.dmp
ERROR: value too long for type character varying(80)
|delete table if exist then create table postgres||1||406|
|PostgreSQL 9.2 - SQL import error||1||155|
|Could you point the better approach on PostgreSQL backup/ restore ?||4||54|
|Postgresql create field from "as " then reuse it but it say does not exist||2||41|