Community mailing list archives

community@mail.odoo.com

Re: Cannot remove a database from web client or terminal

by
gunnar wagner
- 01/06/2015 04:47:34
maybe an obsolete question ... you have done a sudo - su openerp before trying the dropdb command, right?
The '+' sign as the db's name looks weird (said with 0 to nothing experince in psql) but I'd try dropdb + (because + is listed as the db's name)

sudo su - openerp
dropdb +



On 1/6/2015 5:37 PM, Janice Ng wrote:
<blockquote cite="mid:CADeE75bOc05sO=Ac9QM_Dr5haAfST5dX0pFtV_3jvnvAHk9OOg@mail.gmail.com" type="cite">

Hi community ,

I'm using openerp 7.0 and I was trying to remove a old database created long time ago through the user database. An error message popped out:

"Drop Database

Could not drop database !"

 

And when trying to drop it via terminal:

"dropdb:  database removal failed:   ERROR:  database "testdb" does not exist"

 

List out all the databases in postgresql and get a mysterious "+" sign before the database name which jumps to the next line instead:

                                        List of databases

     Name    |    Owner     |   Encoding  |        Collate      |        Ctype        |  Access privileges

-------------+--------------+---- ---------+-----------------+------------------+-----------------------------

                + |   openerp   |  UTF8         |  en_US.UTF-8  | en_US.UTF-8  |

testdb    

database1    |   openerp   |  UTF8         |  en_US.UTF-8  | en_US.UTF-8  |

database2    |   openerp   |  UTF8         |  en_US.UTF-8  | en_US.UTF-8  |

.......



I guess this is the reason why I can't access this database and any idea how to solve it?  I can still see it in the drop-down menu in the login screen but couldn't use it. 


Thanks,

Janice

 

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


--

Gunnar Wagner | Iris Germanica Ltd. | JinQian Gong Lu 385, 8-201 | FengXian Qu, 201404 Shanghai | P.R. CHINA
+86 159 0094 1702 | +49 (0)176 7808 9090 | skype: professorgunrad | www.fashionsupermarket.net