Make varcache (the pg parameters cached ...
👋 hello friends, I'm wondering how to take pg_dumps of my (pooled) db. There are lots of warnings on Neon saying it will break things, but this merged PR seems to fix that (maybe?) https://github.com/pgbouncer/pgbouncer/pull/867
Do we know what version of pgbouncer Neon uses?
GitHub
Make varcache (the pg parameters cached per connection) dynamically...
This change enables caching other postgres parameters in addition to the static list {"client_encoding", "DateStyle", "TimeZone", "standard_conforming_strings&quo...
16 Replies
robust-apricot•2y ago
Ok now I feel silly. I somehow thought per project all connections were only pooled or only unpooled. I removed "-pooler" off the path and it works great.
Maybe this could be cleared up in the docs/banners warning about pooled connections?
dependent-tan•2y ago
what warnings are you referring to
robust-apricot•2y ago
robust-apricot•2y ago
Neon
Import data from Postgres - Neon Docs
This topic describes migrating data from another Postgres database to Neon using the pg_dump and pg_restore command line utilities. Avoid using pg_dump over a pooled Neon connection (see PgBouncer iss...
dependent-tan•2y ago
Why should we remove the warnings?
robust-apricot•2y ago
The warning points to people having problems with pg_dump setting search_path globally across connections, which caused things to fail. But the merged PR that I found tracks search_path per connection, so perhaps the problem is no longer a problem (I'm not sure though)
If it is still a problem, perhaps in the warning you can mention that removing "-pooler" from the connection string is how you can use an unpooled connection to run pg_dump
dependent-tan•2y ago
The issues that we call out in the warning are still open
@Daniel perhaps it is worth adding an example of an endpoint with and with out the -pooled suffix here?
sensitive-blue•2y ago
I'll fix that up so it's clearer. Thanks for the feedback!
xenial-black•2y ago
Also, neon doesn't support replicas right?
dependent-tan•2y ago
we have read replicas
and logical replication
xenial-black•2y ago
So where can I see the replication section?
dependent-tan•2y ago
Neon
Read replicas - Neon Docs
Neon read replicas are independent read only compute instances designed to perform read operations on the same data as your read write computes. Neon read replicas do not replicate data across databas...
xenial-black•2y ago
So this compute section in dashboard is related to replica
xenial-black•2y ago
as there is a option called upgrade to RO replicas
add*
sensitive-blue•2y ago
Right. Your branch can have one read-write (RW) compute. That's what you see in the screen cap you posted above. If you upgrade to Scale or Launch, you get access to read replicas, which are read-only (RO) computes. You can add more than one RO compute to a branch.
The primary use case for RO replicas is offloading read workloads to another compute instance.
xenial-black•2y ago
Understood. Thanks for explanation. Can you suggest a resource where I can understand different types of db replicas