ROS Resources: Documentation | Support | Discussion Forum | Index | Service Status | ros @ Robotics Stack Exchange

Attention: Answers.ros.org is deprecated as of August the 11th, 2023. Please visit robotics.stackexchange.com to ask a new question. This site will remain online in read-only mode during the transition and into the foreseeable future. Selected questions and answers have been migrated, and redirects have been put in place to direct users to the corresponding questions on Robotics Stack Exchange. Additional details are available here.

0

household_objects database

household_objects_database

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

Nutan
92 ●12 ●14 ●20

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 -0500

Matei Ciocarlie
586 ●6 ●9

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

Comments

if figured it out. In pgadmin, i use the name of "household_objects-0.2", but it could not contain the point.

Nutan ( 2011-08-03 19:16:20 -0500 )edit

thanks Nutan it worked when i removed the . in the name of the database :)

karthik ( 2012-01-09 04:53:14 -0500 )edit

0

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

kexiang
1 ●4 ●5 ●8

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

edit flag offensive delete link

0

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

Guido
514 ●23 ●29 ●39

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

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

Comments

I am sure. It works good when I am using Ubuntu 10.4.

Nutan ( 2011-08-02 14:31:37 -0500 )edit

Question Tools

Stats

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

Seen: 370 times

Last updated: Oct 06 '11

Related questions

ROS Answers is licensed under Creative Commons Attribution 3.0 Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.

Powered by Askbot version 0.10.2