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.
PostgreSQL* DriverSQL

Avatar of undefined
Last Comment
Dan Craciun

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Dan Craciun

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Tamilarasu P

ASKER
out file means backup file name?.if i enter any file name without extension and quotes ?
Dan Craciun

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
Tamilarasu P

ASKER
If I run this command "pg_dump Test > TodayBAckup"  in my postgresql
 I got a this error message "'NoneType' object has no attribute 'connection'"
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Dan Craciun

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".
Tamilarasu P

ASKER
my database name was test
Dan Craciun

test or Test?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.