Re: [GENERAL] Database migration to RDS issues permissions

On 11/21/2016 03:34 PM, Fran ... wrote: Hi Adrian, I followed you link and I had again errors: What was the command you used? /pg_restore: [archiver (db)] Error from TOC entry 4368; 2606 151317 FK CONSTRAINT type_id_3940becf ownersuser/ /pg_restore: [archiver (db)] could not execute

Re: [GENERAL] Database migration to RDS issues permissions

PTIONS ( password 'X', "user" 'user' ); Regards. De: Adrian Klaver <adrian.kla...@aklaver.com> Enviado: sábado, 19 de noviembre de 2016 23:49 Para: Fran ...; pgsql-general@postgresql.org; t...@sss.pgh.pa.us Asunto: Re: [GENERAL] Database mig

Re: [GENERAL] Database migration to RDS issues permissions

On 11/19/2016 11:12 AM, Fran ... wrote: > Hi, > > > You were right and I have tried to grant that role to user and I get > following errors.. > > > /pg_restore: [archiver (db)] Error while PROCESSING TOC:/ > /pg_restore: [archiver (db)] Error from TOC entry 4335; 2606 151422 FK > CONSTRAINT

Re: [GENERAL] Database migration to RDS issues permissions

On 11/19/2016 11:12 AM, Fran ... wrote: > Hi, > > > You were right and I have tried to grant that role to user and I get > following errors.. GRANT what role to what user? > > > /pg_restore: [archiver (db)] Error while PROCESSING TOC:/ > /pg_restore: [archiver (db)] Error from TOC entry

Re: [GENERAL] Database migration to RDS issues permissions

e de 2016 18:41 Para: Fran ...; pgsql-general@postgresql.org; t...@sss.pgh.pa.us Asunto: Re: [GENERAL] Database migration to RDS issues permissions On 11/19/2016 09:33 AM, Fran ... wrote: > Hi, > > > I run "pg_dumpall" command and there are the permissions por the user: >

Re: [GENERAL] Database migration to RDS issues permissions

er.com> *Enviado:* sábado, 19 de noviembre de 2016 18:24 *Para:* Fran ...; pgsql-general@postgresql.org *Asunto:* Re: [GENERAL] Database migration to RDS issues permissions On 11/19/2016 07:21 AM, Fran ... wrote: Hi Adrian, these are some of them: /pg_restore: [archiver (db)] Error from

Re: [GENERAL] Database migration to RDS issues permissions

"Fran ..." writes: > I think I would solve the problem granting "superuser" permission but this is > not possible in RDS. It looks like your other errors are also due to doing the restore as a non-superuser. Not sure if you have any good alternatives here --- you could

Re: [GENERAL] Database migration to RDS issues permissions

eneral@postgresql.org Asunto: Re: [GENERAL] Database migration to RDS issues permissions On 11/19/2016 07:21 AM, Fran ... wrote: > Hi Adrian, > > > these are some of them: > > > /pg_restore: [archiver (db)] Error from TOC entry 4997; 0 0 SEQUENCE SET > account_id_seq owneruser

Re: [GENERAL] Database migration to RDS issues permissions

On 11/19/2016 07:21 AM, Fran ... wrote: Hi Adrian, these are some of them: /pg_restore: [archiver (db)] Error from TOC entry 4997; 0 0 SEQUENCE SET account_id_seq owneruser/ /pg_restore: [archiver (db)] could not execute query: ERROR: permission denied for sequence account_id_seq/ /

Re: [GENERAL] Database migration to RDS issues permissions

"Fran ..." writes: > these are some of them: These look to be cascading damage from some earlier failure. I'd advise looking at the first one or two errors and solving them, then repeat as necessary. In general, though, pg_dump of a single database is not a complete

Re: [GENERAL] Database migration to RDS issues permissions

in advance. De: Adrian Klaver <adrian.kla...@aklaver.com> Enviado: sábado, 19 de noviembre de 2016 15:41 Para: Fran ...; pgsql-general@postgresql.org Asunto: Re: [GENERAL] Database migration to RDS issues permissions On 11/19/2016 05:21 AM, Fran ... wrote

Re: [GENERAL] Database migration to RDS issues permissions

On 11/19/2016 05:21 AM, Fran ... wrote: Hi, I have to migrate a production database to RDS. This is the size and info: database | owneruser | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =Tc/owneruser+| 32 GB | pg_default | Origin database: 1 database 1 owneruser with

[GENERAL] Database migration to RDS issues permissions

Hi, I have to migrate a production database to RDS. This is the size and info: database | owneruser | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =Tc/owneruser+| 32 GB | pg_default | Origin database: 1 database 1 owneruser with superuser permission Backup archived size is