[GENERAL] 2 postgresql server on the same station : conflict?

2013-05-28 Thread image
Hello, On the same station, i have 2 postgresql server: one for my postgis db (v9.1) and so another installed with opener^7 (9.2). Unfortunalty, i noticed i'm obliged to stop service for my postgresql postgis (9.1) in order to use openerp7 (postgres9.2). I 'm surprised about that. There is there a

[GENERAL] Restore a pgsql base from openERP v5(ubuntu) to v7(windows7)

2013-05-28 Thread image
Hello, Up to now, we're working with openERP v.5. The server has installed on our ubuntu server station. I succeed in sauvegarding database (v8.3 of pgsql) via pg_dump. I would like now restore this database into my new OPENerp server station (windows7). I succeed in doing it thanks to psql but

[GENERAL] 2 postgresql server on the same station : conflict?

2013-05-28 Thread image
Hello, On the same station, i have 2 postgresql server: one for my postgis db (v9.1) and so another installed with opener^7 (9.2). Unfortunalty, i noticed i'm obliged to stop service for my postgresql postgis (9.1) in order to use openerp7 (postgres9.2). I 'm surprised about that. There is there a

[GENERAL] Psycopg2 : error message.

2014-05-16 Thread image
the 2 usefull files below : pg_test.py <http://postgresql.1045698.n5.nabble.com/file/n5804197/pg_test.py> SS_dos.JPG <http://postgresql.1045698.n5.nabble.com/file/n5804197/SS_dos.JPG> In advance, thank you to throw light for me. Regards. IMAGE -- View this message

Re: [GENERAL] Psycopg2 : error message.

2014-05-16 Thread image
Hello, Thanks. Ok i deleted the except. Please find below the 2 updates usefull liles : pg_test.py <http://postgresql.1045698.n5.nabble.com/file/n5804203/pg_test.py> SS_dos.JPG <http://postgresql.1045698.n5.nabble.com/file/n5804203/SS_dos.JPG> In advance, thank you. Rega

Re: [GENERAL] Psycopg2 : error message.

2014-05-16 Thread image
8.n5.nabble.com/file/n5804207/SS_dos.JPG> In advance, thank you. IMAGE. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Psycopg2-error-message-tp5804197p5804207.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-gen

Re: [GENERAL] Psycopg2 : error message.

2014-05-16 Thread image
Dear all, Thank you for your replies.Before taking into account your last proposals, I would like to tell you : I noticed that i don't get error message when i use the default user (postgres). But when i use my new user account (laurent), i get the error message. With pgadmin3 i would like edit

Re: [GENERAL] Psycopg2 : error message.

2014-05-19 Thread image
Dear all, Thank you again for your replies. So regarding my issue with my 'laurent' user account, i remove double quote and i add punctuation between the parameters. But it's always the same result. I succeed in connecting to my pg database with the postgres user. But i have the same problem w

[GENERAL] Problem with postgis raster

2014-05-19 Thread image
Dear all, I tried to import via pgraster2pgsql several DEM raster files. Below, i paste a screenshot representing my DOS interface : SS_pg_raster.JPG After the import, it's impossible to visualize the postgis raster layer via qgis. And via qgis db manager or pgadmin3, we can notice thaht th