© 2026 Hedgehog Software, LLC
Twitter
GitHub
Discord
System
Light
Dark
More
Communities
Docs
About
Terms
Privacy
Search
Star
Feedback
Setup for Free
Use of --disable-triggers in pg_restore - Neon
N
Neon
•
2y ago
•
1 reply
wet-aqua
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
.
.
.
Neon
Join
The official Neon Database Discord
10,545
Members
View on Discord
Resources
ModelContextProtocol
ModelContextProtocol
MCP Server
Similar Threads
Was this page helpful?
Yes
No
Recent Announcements
Similar Threads
pg_restore & Size Limits
N
Neon / ❓|questions-and-answers
9mo ago
Use pg_rrule extension
N
Neon / ❓|questions-and-answers
16mo ago
Cannot use `pg_ivm` extension
N
Neon / ❓|questions-and-answers
8mo ago
PG_Restore a sample DB in a tutorial ... you think it would be easy
N
Neon / ❓|questions-and-answers
11mo ago