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

asked on

How to backup in postgresql

Hi,

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

Link to home
membership
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

ASKER

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?