Link to home
Start Free TrialLog in
Avatar of Tamilarasu P
Tamilarasu P

asked on

How to backup in postgresql


   how to take PostgreSQL backup in local driver and restore also.please tell me easiest way of backup & restore.
Avatar of Dan Craciun
Dan Craciun
Flag of Romania image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Tamilarasu P
Tamilarasu P


out file means backup file name?.if i enter any file name without extension and quotes ?
Yes, outfile is the backup file name.

In Windows is something like D:\backups\dailybackup20170331.sql
In Linux is something like /home/backups/dailybackup20170331.sql
If I run this command "pg_dump Test > TodayBAckup"  in my postgresql
 I got a this error message "'NoneType' object has no attribute 'connection'"
Do you have a database called Test?
That error basically says it could not find (or could not access due to insufficient rights) a database called "Test".
my database name was test
test or Test?