i have a postgresql database on one server and i need to copy it to another server i also need the data not only structure.
pgadmin III only copies the structure not the the data i cannot find any way to change the setting.
the database where i want to dump / copy from asks for password for postgres but i never set one. perhaps another freelancer i dont know. how can i find it out when i have root access to the database?