Community mailing list archives

community@mail.odoo.com

Re: Cannot remove a database from web client or terminal

by
janice
- 01/06/2015 05:05:12
Thanks Samba and Gunnar, I have tried these methods but still couldn't access that "testdb" database. Also, "+" is not regarded as a db's name and the database "+" does not exist error msg came up as expected. I suppose this plus sign has some meanings but I just couldn't find the answer anywhere. Anyway, thanks for your suggestion.

Thanks and regards,
Janice

On Tue, Jan 6, 2015 at 5:52 PM, Gunnar Wagner <gunnar.wagner@irisgermanica.com> wrote:

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

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