Use of --disable-triggers in pg_restore
Hi there,
I am new to neon and trying to figure things out. I am trying to run pg_restore with the --disable-triggers flag.
I think this requires running as a superuser (https://stackoverflow.com/a/36971024) but on your docs it says we can't connect as a superuser.
Is this understanding correct, and if so, how can I run pg_restore?
Thank you 🙂
Stack Overflow
pg_restore is not disabling triggers
Using PostgreSQL 9.2.8, I'm trying to restore just my data from one database into another but the triggers seem to still be running. I've written the script, shown below, to do the copy.
Basical...
1 Reply
other-emerald•2y ago
Hi, that's correct. As a managed service, we don't support superuser. Would it be possible for you to create a dump without the triggers, similar to what's described here: https://stackoverflow.com/questions/64999047/how-to-do-a-pg-dump-for-only-tables-only-and-not-triggers-and-functions
Stack Overflow
How to do a pg_dump for only tables only and not triggers and funct...
What I want:
I want a pg_dump of a database (let's call the database as 'test').
In this pg_dump I want only the tables without the following: data, triggers, functions, sequences, etc.
What I am d...