Community mailing list archives

community@mail.odoo.com

Re: Odoo 8 on AWS EC2 + Postgres on AWS DBS

by
Interpreta solucions empresarials S.L., Toni Mas
- 08/03/2016 04:30:34
Is strange, you can connect to that database from Odoo? The username is
the database one? Try a listing of DBs to see if it's there.

psql --list --host=xxxxx.xxxxxxx.rds.amazonaws.com --username=xxxxx



El 01/08/16 a las 21:22, Apoorv Soral escribió:
> I got -> pg_dump: [archiver (db)] connection to database "xxxxxx"
> failed: FATAL:  database "xxxxxx" does not exist
> 
> What do I do now?
> 
> 
> On Mon, Aug 1, 2016 at 4:17 PM, Antonio Mas <amas@interpreta.es
> <mailto:amas@interpreta.es>> wrote:
> 
>     Hi.
> 
>     Try to reproduce the error in the shell. Login as the user who owns the
>     Odoo server and exec the command as shown in the error message, ex:
> 
>     /usr/bin/pg_dump --no-owner --username=xxxxx
>     --host=xxxxx.xxxxxxx.rds.amazonaws.com  --port=5432
>     --file=/tmp/tmpAf_WRY/dump.sql xxxx
> 
>     With a bit of luck that will show you a more verbose message than 'error 1'.
> 
> 
> 
> 
>     El 30/07/16 a las 21:37, Apoorv Soral escribió:> Thanks for your detailed answer, Amas. But it didn't work for me.
>     The > error has now changed to what is pasted below- please help me
>     community... > > Postgres subprocess ('/usr/bin/pg_dump',
>     '--no-owner', '--username=xxxxx > ',
>     '--host=xxxxx.xxxxxxx.rds.amazonaws.com
>      > ', '--port=5432',> '--file=/tmp/tmpAf_WRY/dump.sql', u'xxxx') error 1 > > > On Jul
>     29, 2016 11:47 PM, "Antonio Mas" <amas@interpreta.es
>     <mailto:amas@interpreta.es> > <mailto:amas@interpreta.es
>     <mailto:amas@interpreta.es>>> wrote: > > Sorry for my previous
>     message, I was doing several things and it's not > understandable. >
>     > 1) Find the version of Postgres running on your RDS instance. You
>     can > see it on the instance parameters. > > 2) Search for that
>     version of Postgres client for the linux flavour > running on the
>     Odoo server, if you can find it on any repo. If not, > compile it or
>     perhaps you can find some binary that works for you. In my > case I
>     found them for centos on the repos of Scientific Linux. > > Good
>     luck! > > > > > > El 29/07/16 a las 18:02, Apoorv Soral escribió:>
>     Could you please tell me the commands you typed to install that... >
>     Thanks > > > On Jul 29, 2016 8:04 PM, "Antonio Mas" > > > wrote: > >> El 29/07/16 a las 16:03, Apoorv Soral escribió:> It didn't work
>     out. > I installed postgreSQL 9.5 on the app server > too. > > > >
>     It's > working for me on 9.4.5. I had to install the client same
>     minor > > version on my server than the one of the server on my RDS
>     instance > to be > able to backup / drop DBs, that was all. > > > >
>     On Jul 29, > 2016 12:38 AM, "Antonio Mas" > > wrote: > >> El
>     28/07/16 a las 12:22, Apoorv Soral escribió:> Please help me, I > >
>     have installed odoo 8 on AWS EC2 ubuntu > AMI/server and > >
>     connected > it to the DB hosted on AWS RDS. Somehow I > was able to
>     > connect > > the two and launch odoo chnaging the config > file >
>     db_host parameter > but > now I am not able to take backup or > >
>     restore a DB backup. > > > I think I am missing the path to bin >
>     folder > but how do I do it on > a RDS > server DB instance. > > >
>     Please help. > > > Hi. > > Ensure > you have the same version of >
>     Postgres utils as the Postgres > server > running on RDS, else you >
>     wouldn't be able to manage the databases. > > > Regards. > > >
>     _______________________________________________ > > Mailing-List: >
>     https://www.odoo.com/groups/community-59 > Post to: > >
>     mailto:community@mail.odoo.com <mailto:community@mail.odoo.com>
>      >  >  >> Unsubscribe: https://www.odoo.com/groups?unsubscribe > > >> _______________________________________________ > Mailing-List: >
>     > https://www.odoo.com/groups/community-59 > Post to: > >
>     mailto:community@mail.odoo.com <mailto:community@mail.odoo.com>
>      >  >> > Unsubscribe: https://www.odoo.com/groups?unsubscribe > > > >
>     _______________________________________________ > Mailing-List: >
>     https://www.odoo.com/groups/community-59 > Post to: >
>     mailto:community@mail.odoo.com <mailto:community@mail.odoo.com>
>      >  >> Unsubscribe: https://www.odoo.com/groups?unsubscribe > > >
>     _______________________________________________ > Mailing-List: >
>     https://www.odoo.com/groups/community-59 > Post to: >
>     mailto:community@mail.odoo.com <mailto:community@mail.odoo.com>
>      >
>     > Unsubscribe: https://www.odoo.com/groups?unsubscribe > > >
>     _______________________________________________ > Mailing-List:
>     https://www.odoo.com/groups/community-59 > Post to:
>     mailto:community@mail.odoo.com <mailto:community@mail.odoo.com>
>      >
>     Unsubscribe: https://www.odoo.com/groups?unsubscribe > >
>     _______________________________________________ > Mailing-List:
>     https://www.odoo.com/groups/community-59 > Post to:
>     mailto:community@mail.odoo.com <mailto:community@mail.odoo.com> >
>     Unsubscribe: https://www.odoo.com/groups?unsubscribe >
> 
>     _______________________________________________
>     Mailing-List: https://www.odoo.com/groups/community-59
>     Post to: mailto:community@mail.odoo.com <mailto:community@mail.odoo.com>
>     Unsubscribe: https://www.odoo.com/groups?unsubscribe
> 
> 
> _______________________________________________
> Mailing-List: https://www.odoo.com/groups/community-59
> Post to: mailto:community@mail.odoo.com
> Unsubscribe: https://www.odoo.com/groups?unsubscribe
>