dump and restore postgresql database

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?

Taidot: Linux, SQL

Näytä lisää: postgres dump restore, where can i find a freelancer, root freelancer, postgresql freelancer, i want freelancer database, freelancer sql database, freelancer sql c#, freelancer password change, freelancer on linux, freelancer need database, freelancer it sql, find set-root, find freelancer c# sql server, find a freelancer access database, c# & sql server freelancer, postgresql any, where can i find it freelancer, postgresql c++, postgres, linux freelancer, freelancer sql, freelancer linux, find root, database freelancer, linux need root

Tietoa työnantajasta:
( 162 arvostelua ) Steyr, Austria

Projektin tunnus: #1714878

Myönnetty käyttäjälle:


Hello, i can do it for you.

$30 USD 0 päivässä
(9 Arvostelua)

5 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hi, please see PM

$70 USD 0 päivässä
(2 arvostelua)

i ll help you to backup and restore full DB . Please check your PMB

$100 USD 0 päivässä
(0 arvostelua)

I am working carefully and complete it step by step. I am manually copy all your data and copy them in your new server. You can give me this project

$30 USD 7 päivässä
(0 arvostelua)

Check your PMB(inbox). Thank you.

$55 USD 1 päivässä
(0 arvostelua)