Ask Your Question
0

household_objects database

asked 2011-08-01 22:15:58 -0600

Nutan gravatar image

Hi, all,

I followed those steps(http://www.ros.org/wiki/sql_database/Tutorials/Installing%20a%20PostgreSQL%20Server) to link the database, but it failed. The errors are as below. The version of Ubuntu is 11.04. Thanks.

/usr/bin/pg_restore --host 10.217.132.113 --port 5432 --username willow --dbname \"household_objects-0.2\" --verbose "/home/kptee/database/household_objects-0.2.backup"
pg_restore: connecting to database for restore
pg_restore: [archiver (db)] connection to database ""household_objects-0.2"" failed: FATAL:  database ""household_objects-0.2"" does not exist
pg_restore: *** aborted because of error

Process returned exit code 1.
edit retag flag offensive close merge delete

3 Answers

Sort by ยป oldest newest most voted
0

answered 2011-08-03 12:15:04 -0600

Matei Ciocarlie gravatar image

Nutan,

I have never used pg_restore from the command line, so can offer no advice there. I always use the pgadmin GUI, it works great for me, you can get it via sudo apt-get install pgadmin3

edit flag offensive delete link more

Comments

if figured it out. In pgadmin, i use the name of "household_objects-0.2", but it could not contain the point.
Nutan gravatar imageNutan ( 2011-08-03 19:16:20 -0600 )edit
thanks Nutan it worked when i removed the . in the name of the database :)
karthik gravatar imagekarthik ( 2012-01-09 04:53:14 -0600 )edit
0

answered 2011-10-06 21:32:19 -0600

kexiang gravatar image

I have encountered the same problem when I use ubuntu11.04. However 10.10 works well.

edit flag offensive delete link more
0

answered 2011-08-02 00:59:59 -0600

Guido gravatar image

updated 2011-08-02 01:00:31 -0600

Hi Nutan,

Are you sure you created the database "household_objects-0.2" on your server before trying to restore it ?

Guido

edit flag offensive delete link more

Comments

I am sure. It works good when I am using Ubuntu 10.4.
Nutan gravatar imageNutan ( 2011-08-02 14:31:37 -0600 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

Stats

Asked: 2011-08-01 22:15:58 -0600

Seen: 278 times

Last updated: Oct 06 '11