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 query
pg_rest OPTIONS (
password 'X',
"user" 'user'
);
Regards.
De: Adrian Klaver
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 m
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 wor
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 4335;
al@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:
>
>
> /CREATE ROLE dlapuser;/
> /ALT
o:* 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 TOC entry 4997;
"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 just ignore the errors re
iembre 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 TOC entry 4997; 0
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/
/Comma
"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
representation of where you
egclass);
Thanks in advance.
De: Adrian Klaver
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:
> Hi,
&g
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 superu
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
13 matches
Mail list logo
