I am new to postgresql. I have pgadmin installed on my windows machine locally using which i m connecting to the client server and accessing the database. I want to take the backup of client database. but it seems hard the database is very large. and when i select any database and hit backup for that database it does not give me any error message but it hangs at that point. To fix this i have to restart the pgadmin.
Large means I have a database which has number of records in each table. Also as i said.... it might because of network...but i want to understand when pgadmin is executing this backup process i m getting why the admin tool is getting hangged and say "Not Responding". right now i just tried to backup 1 table which has around 300000 rows in it. it is been more than 15 mins now my pgadmin says "not responding".