easy resetting - Search results in mailing lists
Mailing lists >> pgsql-admin >> Thread
2025-03-06 11:28:00 | Re: Comparing Parameters PRE- and POST- Upgrade - Any script? (Achilleas Mantzios - cloud)
settings are your friends to find differences. Across more "distant" upgrades (I did pgsql10 -> pgsql16 recently) it becomes more painful. Across more close upgrades it is easier
Mailing lists >> pgsql-admin >> Thread
2024-12-08 10:41:59 | Re: Postgres compatibility with RHEL (Deepak Pahuja .)
easiest I think too.
Thanks Deepak
Sent from Outlook for Android
Mailing lists >> pgsql-admin >> Thread
2024-07-18 11:38:22 | Re: Queries waiting on SyncRep even though synchronous_standby_names is absent (Nikhil Shetty)
setting. Forcefully truncate long or stuck transactions; if it still doesn't help, This is an easy
Mailing lists >> pgsql-admin >> Thread
2024-06-13 13:17:47 | Re: Get PG primary version without substring manipulation? (Keith Fiske)
easier to work with than the strings you were getting with other methods. keith=# select current_setting
Mailing lists >> pgsql-admin >> Thread
2024-04-08 17:27:41 | Re: Work_mem (Jeff Janes)
easy to tune for. You should figure out which queries cause those temp files, and if those queries are timing sensitive then test those queries with various settings
Mailing lists >> pgsql-admin >> Thread
2023-12-25 18:04:43 | RE: Query Performance after pg_restore (Murthy Nunna)
easy to jump into explain-plan land. No, this is not that! I don't run "select count(*) of tables" every day. I ran this only to show the performance issue and only for comparison
Mailing lists >> pgsql-admin >> Thread
2023-08-10 16:26:59 | Re: Automate to rename table (Keith Fiske)
easier to keep track of the age of the data itself you're dealing with. Could just be a simple "created_at" column that is just set as a default of CURRENT_TIMESTAMP
Mailing lists >> pgsql-admin >> Thread >> Search in thread (3)
2023-05-15 14:40:18 | Re: Options for more aggressive space reclamation in vacuuming? (Jeff Janes)
easier to deal with after the fact (reindex concurrently) 50 GB out of 200 GB seems roughly in accord with the default setting
Mailing lists >> pgsql-admin >> Thread
2022-02-21 14:10:53 | Programmatic access to the SQL tab of pgadmin (Thomas Kaliakos)
setting the csrf headers to an empty list ( PGADMIN_CONFIG_WTF_CSRF_HEADERS=[]), but none of those worked. Is there any easy
Mailing lists >> pgsql-admin >> Thread
2022-02-12 23:37:12 | setting up postgres replication FATAL: database system identifier differs between the primary and standby (Noah)
Ahoy there, I am attempting to set up postgres12 with replication between two servers. I
Mailing lists >> pgsql-admin >> Thread
2022-01-19 21:46:12 | Re: Setting effective_cache_size in integer form with the 8kb block units (David G. Johnston)
On Wed, Jan 19, 2022 at 2:39 PM Wells Oliver
Mailing lists >> pgsql-admin >> Thread
2021-06-16 19:21:40 | Re: compression in replication (LEROY TENNISON)
easy to do and opted for external (to Postgresql) compression.
On Wednesday, June 16, 2021, 2:56:09 PM UTC, Vijaykumar Jain
Mailing lists >> pgsql-admin >> Thread
2021-01-22 19:36:16 | Re: Create Read only user (Tim Cross)
easier to backup, restore and migrate data between environments. Some people don't like using schemas because they don't like having to prefix object names with the schema name, but I find this
Mailing lists >> pgsql-admin >> Thread
2020-12-03 11:41:52 | Re: pg_upgrade + replica servers + rsync --size-only is unsafe (Rob Emery)
setting --size-only guarantees disaster in this flow? However we are definitely confused as to why this isn't hit more often, as it seems that this would always happen? I've attached the following
Mailing lists >> pgsql-admin >> Thread
2020-11-06 08:53:10 | Re: Remote Access Help (Tim Cross)
setting of the firewall on the Linux system. By default, Ubuntu uses gufw to configure a basic firewall. You need to ensure that it has a rule allowing remote connections to the pg port (typically