Thank you all
From: Laurenz Albe
Sent: Friday, October 21, 2022 8:56 PM
To: Julie Nishimura ; pgsql-gene...@postgresql.org
Subject: Re: constantly updated table in Amazon RDS
On Fri, 2022-10-21 at 18:51 +, Julie Nishimura wrote:
> A table is constan
Hello,
A table is constantly updated by inserting new rows. Will it affect select if
where clause is based on > date?
Does "where clause" to specify > date and < now?
Thanks!
Hello, we currently have 9.4 hot_standby master-slave pair. Going forward, we
can keep only one server. How can I convert the system properly?
These are some snippets from master postgresql.conf file:
==
wal_level = hot_standby # minimal, archive,
Hello there,
One of our PostgreSQL 9.4.1 databases has been backed up as *.gz file with the
compression 9 "pg_dump -Z 9". What is the right format of restore this file
when needed? Can I run the restore from a compressed file or I need to unzip
the file first, then run pg_restore? Thanks
I'd like to copy one single database from 9.4 cluster to a new 9.6 cluster
(migration with the upgrade), to the different host
From: Adrian Klaver
Sent: Friday, December 6, 2019 1:32 PM
To: Julie Nishimura ; pgsql-general@lists.postgresql.org
; pgsql-ge
Hello there, what would be my best way to migrate 2 tb single database from
cluster 9.4 to another machine on 9.6?
Thank you!
These are great points. Thanks! I will push for some testing environment
From: Justin
Sent: Friday, December 6, 2019 10:06 AM
To: Julie Nishimura
Cc: Tom Lane ; Stephen Frost ; Laurenz
Albe ; Michael Paquier ;
pgsql-general@lists.postgresql.org ;
pgsql
step requires downtime. Second does not. Correct?
-Julie
From: Tom Lane
Sent: Wednesday, December 4, 2019 5:28 AM
To: Stephen Frost
Cc: Laurenz Albe ; Michael Paquier
; Julie Nishimura ;
pgsql-general@lists.postgresql.org ;
pgsql-general
Subject: Re: upgrade
Hello, what is the best way to migrate from PostgreSQL 8.3.11 on
x86_64-redhat-linux-gnu to PostgreSQL 9.6.16 on x86_64-pc-linux-gnu server,
with minimal downtime?
The caveat is the source has about 80 databases overall almost 30 TB. I could
migrate the smallest ones (up to 1 tb) using pg_dump a
Hello,
What is the best way to dump/restore the entire database except couple of
largest tables, what is the best way to do it on PostgreSQL 9.4.1 on
x86_64-unknown-linux-gnu?
Thank you
Hello, is there any way to find if there are any dblink exist on the 9.6
postgresql server?
Thanks
Thank you, Thomas. Do you know if it is safe to replicate 9.6.2 (smaller) db to
9.6.15 (larger capacity) using pg_basebackup? Would it be considered as an
upgrade?
From: Tomas Vondra
Sent: Saturday, October 19, 2019 5:44 AM
To: Julie Nishimura
Cc: pgsql
I think you don't swallow an entire elephant at once, you can choke on it, it
is more safe to be eaten piece by piece:)
From: Julie Nishimura
Sent: Thursday, October 17, 2019 2:19 PM
To: Ron ; pgsql-general@lists.postgresql.org
Subject: Re: drop database
y, October 17, 2019 1:59 PM
To: pgsql-general@lists.postgresql.org
Subject: Re: drop database
On 10/17/19 3:44 PM, Julie Nishimura wrote:
Guys, can anybody reply if they drop any postgresql database larger than 1 tb
and how long did it take?
A lot has to do with how quickly the underlying file s
Guys, can anybody reply if they drop any postgresql database larger than 1 tb
and how long did it take?
Thanks
Hello everybody,
We are running PostgreSQL 9.6.2 cluster master -> standby (streaming
replication). 22 tb of space (constantly struggling with the space, pruning the
old data, but not fast enough). The biggest db takes 16 tb. So, we've copied it
to another server, and now we would like to delete
How do i find the FULL query running on a postgres instance? When I run:
SELECT datname, pid, state, query, age(clock_timestamp(), query_start) AS age
FROM pg_stat_activity
WHERE state <> 'idle'
AND query NOT LIKE '% FROM pg_stat_activity %'
ORDER BY age;
query seems to be truncated
Thanks!
Or you meant we need to run vacuum on 'my_db_name' without parameters, that it
runs for every table? I am just not sure how long it will take to run for 39
tb...:(
Thanks
From: Adrian Klaver
Sent: Thursday, September 19, 2019 2:06 PM
To: Julie
Hello, we've recently inherited large Greenplum system (master with standby and
8 segment nodes), which is running old version of GP:
20190919:15:22:01:122002 gpstate:hitw-mck-gp1-mdw-1:gpadmin-[INFO]:-
Greenplum initsystem version = 4.3.4.0 build 1
20190919:15:22:01:122002 gpstate:hitw-mck-
| ROLLBACK
(7 rows)
From: Tom Lane
Sent: Tuesday, September 3, 2019 4:11 PM
To: Julie Nishimura
Cc: pgsql-general@lists.postgresql.org
Subject: Re: killing vacuum analyze process
Julie Nishimura writes:
> PostgreSQL 9.6.2 on x86_64-pc-linux-gnu
> It seems like we hav
Hello there,
PostgreSQL 9.6.2 on x86_64-pc-linux-gnu
It seems like we have one process running since 8/19. Is it any repercussion if
we kill it?
postgres=# select * from pg_stat_activity where pid = '18986';
-[ RECORD 1
]+--
Thanks a lot! Very helpful
Sent from my iPhone
> On Aug 5, 2019, at 1:50 PM, Alban Hertroys wrote:
>
>
>> On 5 Aug 2019, at 17:27, Julie Nishimura wrote:
>>
>> Thanks for your reply Alban. Currently we only have A->B replication. Is
>> adding B->C r
_
From: Alban Hertroys
Sent: Monday, August 5, 2019 5:01 AM
To: Julie Nishimura
Cc: Adrian Klaver ;
pgsql-general@lists.postgresql.org ;
pgsql-general
Subject: Re: adding more space to the existing server
On 5 Aug 2019, at 0:39, Julie Nishimura
mailto:juliez...@hotmail.com>> wrote:
te to C
End state:
A replicates to C
B replicates to D
we remove some of the dbs from A and B, then reassign the traffic based on db
selections
I hope it all makes sense...
Thank you
From: Alban Hertroys
Sent: Saturday, August 3, 2019 3:15 AM
To: Julie N
ostgres
Thank you!
From: Adrian Klaver
Sent: Thursday, August 1, 2019 7:28 AM
To: Julie Nishimura ; pgsql-general@lists.postgresql.org
; pgsql-general
Subject: Re: adding more space to the existing server
On 7/31/19 3:21 PM, Julie Nishimura wrote:
>
Hello postgres folks,
We're tossing around the idea of upgrading a replicated postgres cluster (37
dbs) by breaking the replication, adding different size (larger) data disks to
the hot-spare, then turning replication back on, letting it fully populate,
then breaking replication, making the sta
Any advice is appreciated, thank you, guys!!!
Sent from my iPhone
On Jul 9, 2019, at 3:56 PM, Julie Nishimura
mailto:juliez...@hotmail.com>> wrote:
Hello guys,
How do I determine the number of concurrent writes that are allowed for some
databases? Is it max of connections parameter?
Is
Hello guys,
How do I determine the number of concurrent writes that are allowed for some
databases? Is it max of connections parameter?
Is there a way to determine
how many we are currently using on average?
Thank you,
julie
---
7
Today after the change:
SELECT count(*) from pg_freespacemap_relations;
count
---
272
(1 row)
Just FYI
From: Adrian Klaver
Sent: Tuesday, May 28, 2019 5:16 PM
To: Julie Nishimura
Cc: pgsql-general
Subject: Re: POSTGRES_FSM_RELATIONS
From: Adrian Klaver
Sent: Tuesday, May 28, 2019 12:43 PM
To: Julie Nishimura; pgsql-general@lists.postgresql.org; pgsql-general
Subject: Re: POSTGRES_FSM_RELATIONS CRITICAL: DB control fsm relations used:
79569 of 8 (99%)
On 5/28/19 11:20 AM, Julie Nishimura wrote
What is the impact of fsm_relatiosn being maxed out?
From: Julie Nishimura
Sent: Tuesday, May 28, 2019 11:11 AM
To: Adrian Klaver; pgsql-general@lists.postgresql.org; pgsql-general
Subject: Re: POSTGRES_FSM_RELATIONS CRITICAL: DB control fsm relations used
d IN ('r','i')
?
Thanks for your help
From: Adrian Klaver
Sent: Friday, May 24, 2019 10:22 AM
To: Julie Nishimura; pgsql-general@lists.postgresql.org; pgsql-general
Subject: Re: POSTGRES_FSM_RELATIONS CRITICAL: DB control fsm relations used:
795
Andres, yes, thank you!
From: Andres Freund
Sent: Monday, May 27, 2019 6:49 AM
To: Julie Nishimura
Cc: pgsql-general@lists.postgresql.org; pgsql-general
Subject: Re: POSTGRES_FSM_RELATIONS CRITICAL: DB control fsm relations used:
79569 of 8 (99%)
Hi,
On
;i')
?
Thanks!
From: Adrian Klaver
Sent: Friday, May 24, 2019 7:19 AM
To: Julie Nishimura; pgsql-general@lists.postgresql.org; pgsql-general
Subject: Re: POSTGRES_FSM_RELATIONS CRITICAL: DB control fsm relations used:
79569 of 8 (99%)
On 5/23/19 11:57
Correction about version:
PostgreSQL 8.3.11
Thanks again!!!
From: Julie Nishimura
Sent: Thursday, May 23, 2019 11:57 PM
To: pgsql-general@lists.postgresql.org; pgsql-general
Subject: POSTGRES_FSM_RELATIONS CRITICAL: DB control fsm relations used: 79569
of
Hello,
We have an issue with fsm_relations utilization reaching 99%, I was able to
vacuum a handful of tables, but it wasn't enough to make a noticeable
difference. I think at this point we will need to increase the number of
fsm_relations from 80,000 to 100,000 which will require a restart. Bec
nes and control) default_tablespace to
the emptiest volume...
Thanks everybody...
From: Adrian Klaver
Sent: Wednesday, May 15, 2019 3:35 PM
To: Julie Nishimura; David G. Johnston
Cc: pgsql-general@lists.postgresql.org
Subject: Re: default_tablespace in 8.3 postgresql
to public;
From: Adrian Klaver
Sent: Wednesday, May 15, 2019 3:22 PM
To: Julie Nishimura; David G. Johnston
Cc: pgsql-general@lists.postgresql.org
Subject: Re: default_tablespace in 8.3 postgresql
On 5/15/19 3:01 PM, Julie Nishimura wrote:
> No, I did not have them at all in my scri
postgresql
On 5/15/19 2:57 PM, Julie Nishimura wrote:
This puzzles me too! I found that bizarre myself. What is even more
interesting, we have about 80 databases, and all of them now have
default_tablespace=vol4, except only one - "control" database. The only
explanation I would have t
that makes sense, thanks!
From: Adrian Klaver
Sent: Wednesday, May 15, 2019 3:15 PM
To: Julie Nishimura; David G. Johnston
Cc: pgsql-general@lists.postgresql.org
Subject: Re: default_tablespace in 8.3 postgresql
On 5/15/19 3:01 PM, Julie Nishimura wrote:
> No
From: Adrian Klaver
Sent: Wednesday, May 15, 2019 2:48 PM
To: Julie Nishimura; David G. Johnston
Cc: pgsql-general@lists.postgresql.org
Subject: Re: default_tablespace in 8.3 postgresql
On 5/15/19 2:45 PM, Julie Nishimura wrote:
> Adrian, only first 3 (which are template0, postgres, control). Re
as created with the explicit
tablespace in it?... I dont have any other good explanations...
From: Adrian Klaver
Sent: Wednesday, May 15, 2019 2:18 PM
To: Julie Nishimura; David G. Johnston
Cc: pgsql-general@lists.postgresql.org
Subject: Re: default_tablesp
60 dbs...
but not for all 70+
From: Adrian Klaver
Sent: Wednesday, May 15, 2019 2:11 PM
To: Julie Nishimura; David G. Johnston
Cc: pgsql-general@lists.postgresql.org
Subject: Re: default_tablespace in 8.3 postgresql
On 5/15/19 1:57 PM, Julie Nishimura wrote:
> This puzzles me too!
Wednesday, May 15, 2019 1:23 PM
To: Julie Nishimura
Cc: Adrian Klaver; pgsql-general@lists.postgresql.org
Subject: Re: default_tablespace in 8.3 postgresql
On Wed, May 15, 2019 at 1:01 PM Julie Nishimura
mailto:juliez...@hotmail.com>> wrote:
However, since I have modified template1 (a
, May 15, 2019 12:47 PM
To: Julie Nishimura; pgsql-general@lists.postgresql.org; pgsql-general
Subject: Re: default_tablespace in 8.3 postgresql
On 5/15/19 12:39 PM, Julie Nishimura wrote:
> Hello, I have created new tablespace on a new drive yesterday and
> modified some of existing databases
Hello, I have created new tablespace on a new drive yesterday and modified some
of existing databases to use this tablespace as default, like this:
ALTER DATABASE xxx
SET default_tablespace = 'vol4';
So, this command did not physically move any existing tables/indices on the
database xxx, but al
| f | f| f
(1 row)
From: Adrian Klaver
Sent: Monday, May 13, 2019 5:52 PM
To: Julie Nishimura; pgsql-general@lists.postgresql.org; pgsql-general
Subject: Re: does postgresql backup require additional space on disk
On 5/13/19 5:39 PM, Julie Nishi
_______
From: Adrian Klaver
Sent: Monday, May 13, 2019 5:09 PM
To: Julie Nishimura; pgsql-general@lists.postgresql.org; pgsql-general
Subject: Re: does postgresql backup require additional space on disk
On 5/13/19 4:53 PM, Julie Nishimura wrote:
> Adrian,
> I t
.
Then "default" part got lost in emails...:)
From: Adrian Klaver
Sent: Monday, May 13, 2019 4:33 PM
To: Julie Nishimura; pgsql-general@lists.postgresql.org; pgsql-general
Subject: Re: does postgresql backup require additional space on disk
On 5/13/19 3:27 PM, Jul
rian Klaver
Sent: Monday, May 13, 2019 2:47 PM
To: Julie Nishimura; pgsql-general@lists.postgresql.org; pgsql-general
Subject: Re: does postgresql backup require additional space on disk
On 5/13/19 1:26 PM, Julie Nishimura wrote:
> Adrian, thanks for your reply. Couple of clarifications/question
07:33:58PM +, Julie Nishimura wrote:
> We have added new disk volume and about to introduce new
> tablespace using this additional disk space. After that, I am
> going to alter all user dbs (and template db as well) by
> runnig the following command:
>
> CREATE TABLESPACE vol
to point to the
newly volume and reload postgresql.conf
default_tablespace
temp_tablespaces
Am I wrong here?
Thanks,
Julie
From: Adrian Klaver
Sent: Monday, May 13, 2019 1:10 PM
To: Julie Nishimura; pgsql-general@lists.postgresql.org; pgsql-general
Su
13, 2019 11:19 AM
To: Julie Nishimura; pgsql-general@lists.postgresql.org; pgsql-general
Subject: Re: does postgresql backup require additional space on disk
On 5/13/19 10:59 AM, Julie Nishimura wrote:
> Hello,
> we are almost out of disk space on one of our servers (99% full). If we
> r
Hello,
we are almost out of disk space on one of our servers (99% full). If we run
pg_dump to a diff location, does it require any additional disk space on our
current server? I am asking, because on some other software, a backup might
open transaction which keeps growing and eventually consume
extend vol3 instead of
creating new tablespace on vol4 (if possible).
If not, then what is my best bet?
Thanks,
Julie
From: Alan Hodgson
Sent: Thursday, May 9, 2019 9:15 AM
To: Julie Nishimura; pgsql-general
Subject: Re: running out of disk space
On Thu, 2019-05
Thanks for your help, Adrian!
From: Adrian Klaver
Sent: Thursday, May 9, 2019 9:41 AM
To: Julie Nishimura
Cc: pgsql-general@lists.postgresql.org; pgsql-general
Subject: Re: postgresql 9.4 restart
On 5/9/19 8:10 AM, Julie Nishimura wrote:
> Etc/UTC
Well th
hello,
We are running out of disk space, and we introduced new volume to it. I am
about to create new tablespace X and alter user databases to set to this new
tablespace X. So, all new tables will be created in X, but what about existing
tables on previous volume? Its data will be split between
Etc/UTC
From: Adrian Klaver
Sent: Thursday, May 9, 2019 7:51 AM
To: Julie Nishimura
Cc: pgsql-general@lists.postgresql.org; pgsql-general
Subject: Re: postgresql 9.4 restart
On 5/8/19 4:35 PM, Julie Nishimura wrote:
> Thanks again for your help.
&g
e there is some cron job ran shortly after midnight (either
from root or through puppet and restarted the server, because maybe it was
close to max connections - just a guess). What do you think?
-Julie N
________
From: Adrian Klaver
Sent: Wednesday, May 8, 2019 2
,"terminating connection due to administrator
command",""
2019-05-07 00:08:28.060
UTC,"hitwise","hitwise_uk_stg",8558,"10.200.193.58:49246",5cd0cc20.216e,7,"idle",2019-05-07
00:06:56 UTC,,0,LOG,0,"disconnection: session time
Hello,
Our staging 9.4 postgresql has been running couple of weeks with no problem,
but yesterday we saw this error from one of our services that connects to the
staging DBs:
FATAL: terminating connection due to
administrator command; nested exception is
org.postgresql.util.PSQLException: FATAL:
Thanks!
From: Tom Lane
Sent: Friday, May 3, 2019 11:25 AM
To: Julie Nishimura
Cc: Adrian Klaver; pgsql-gene...@postgresql.org
Subject: Re: Pgadmin III
Julie Nishimura writes:
> Hello, I am trying to connect to PostgreSQL 9.6.2 using PGAdmin III, and I
Guys,
Do you know what does this message mean?
POSTGRES_FSM_RELATIONS=CRITICAL: DB control (host:xxx) fsm relations used:
76628 of 8 (96%)
Is this caused by someone deleting a bunch of old data and not vacuuming?
Thanks!
From: Julie Nishimura
Sent
Hello, I am trying to connect to PostgreSQL 9.6.2 using PGAdmin III, and I am
getting this error:
An error has occurred:
Column not found in pgSet: rolcatupdate
Do you know which version of Pgadmin should I use to avoid this? I am on
windows 7. Thanks
Thank you! All works now
From: Adrian Klaver
Sent: Wednesday, April 17, 2019 5:23 PM
To: Julie Nishimura; pgsql-general@lists.postgresql.org
Subject: Re: ERROR: operator class "gin__int_ops" does not exist for access
method "gin"
On 4/
We migrated some tables from 8.3 postgresql to 9.4, and when I compared tables
DDL between environments, I've noticed some indices are missing (majority of
them are using GIN
When I am taking 8.3 ddl for it:
CREATE INDEX serp_test2
ON serp_test
USING gin
(domainids gin__int_ops);
it giv
Thank you. Is there a way to find out if I have tables with tsvectors or
indexes? I have hundreds of tables...
From: Tom Lane
Sent: Tuesday, April 16, 2019 9:45 PM
To: Julie Nishimura
Cc: Adrian Klaver; pgsql-general@lists.postgresql.org
Subject: Re: text search
From: Adrian Klaver
Sent: Tuesday, April 16, 2019 5:14 PM
To: Julie Nishimura; pgsql-general@lists.postgresql.org
Subject: Re: text search configuration missing while migration from 8.3 to 9.4
On 4/16/19 4:22 PM, Julie Nishimura wrote:
> Adrian, Hitwise is the name of our company. Unfortunately, it
aging. Perhaps, some
functions need to be migrated as well, just do not know where to look...
From: Adrian Klaver
Sent: Tuesday, April 16, 2019 3:08 PM
To: Julie Nishimura; pgsql-general@lists.postgresql.org
Subject: Re: text search configuration missing
ult configuration for text search
default_text_search_config = 'pg_catalog.english'
Unfortunately, I am not sure about tsearch2, it is new system that I inherited
not too long ago. So, the production is still on 8.3, but dev/staging that was
built recently, is on 9.4. The engineer who i
Correction: tables are not missing, but some records from the tables missing.
How can we migrate them properly from 8.3 to 9.4?
Sent from my iPhone
On Apr 16, 2019, at 10:32 AM, Julie Nishimura
mailto:juliez...@hotmail.com>> wrote:
Hello, we recenlty created fresh install of 9.4, creat
Hello, we recenlty created fresh install of 9.4, created new dbs, and pg_dumped
and restored correspondent dbs from 8.3 (pg_dump|psql, being on target). Now
we've noticed that some of `pg_catalog.pg_ts_config` and pg_ts_dict tables are
missing, making text search on 9.4 very slow. We tried to in
Monday, March 4, 2019 5:08 PM
To: Julie Nishimura
Cc: pgsql-general@lists.postgresql.org
Subject: Re: master-> 2 hot standbys
On Mar 4, 2019, at 1:59 PM, Julie Nishimura
mailto:juliez...@hotmail.com>> wrote:
Hello,
Our current master 9.2 has two active standbys. Can you please help me out
Oh, this is great news! Yay, thanks!
From: Adrian Klaver
Sent: Sunday, March 10, 2019 6:28 PM
To: Julie Nishimura; pgsql-general@lists.postgresql.org
Subject: Re: migration of 100+ tables
On 3/10/19 5:53 PM, Julie Nishimura wrote:
> Hello friends, I will need
Hello friends, I will need to migrate 500+ tables from one server (8.3) to
another (9.3). I cannot dump and load the entire database due to storage
limitations (because the source is > 20 TB, and the target is about 1.5 TB).
I was thinking about using pg_dump with customized -t flag, then use r
Hello psql friends,
Is there a way to reconstruct DDL for creation of existing databases? For
example, I need to create dev environment for some (not all) of our existing
databases, and I would like to keep the same encoding, connection limit (if
anything was specified), etc. Is there a way to c
th "--jobs".
On 3/7/19 8:11 PM, Julie Nishimura wrote:
Ron, thanksagain. In case if I need to migrate the entire tables, I should be
able to use pg_dump and pg_restore for certain tables, even between different
versions, right? In case if I need to mi
ile to it's relevant target
table.
You should also think about a program named pg_bulkload.
https://www.postgresql.org/docs/9.6/sql-copy.html
https://www.postgresql.org/docs/8.3/sql-copy.html
On 3/7/19 7:53 PM, Julie Nishimura wrote:
Thank you Ron! What if dev environment is on 9.6, but prod
Thank you Ron! What if dev environment is on 9.6, but prod is on version 8.3?
Will posgtres_fdw still be the right option?
Sent from my iPhone
On Mar 6, 2019, at 11:57 PM, Ron
mailto:ronljohnso...@gmail.com>> wrote:
On 3/7/19 1:54 AM, Julie Nishimura wrote:
Hello psql friends,
We n
Hello psql friends,
We need to migrate only 6 months worth of data from one instance to another.
What would be the easiest way to do it? In Oracle, I would set up dblink. What
about postgresql?
Thank you!
Thank you. Are you going to have any presentations on Postgresql conference in
NYC soon?
From: Andreas Kretschmer
Sent: Tuesday, March 5, 2019 9:16 PM
To: pgsql-general@lists.postgresql.org
Subject: Re: write on standby
Am 06.03.19 um 00:34 schrieb Julie
Hello there,
Is it possible for a test app to connect to the standby dB of an active-Standby
dB pair? While both continue to be connected and replicating? What if it’s
needed to write tmp tables that are later dropped? Can it be done in hot
standby scenario on standby? Version is 9.6.2
Thanks
Thank you. I made a mistake, our version is PostgreSQL 9.6.2
From: Ben Chobot
Sent: Monday, March 4, 2019 5:08 PM
To: Julie Nishimura
Cc: pgsql-general@lists.postgresql.org
Subject: Re: master-> 2 hot standbys
On Mar 4, 2019, at 1:59 PM, Julie Nishim
Hello,
Our current master 9.2 has two active standbys. Can you please help me out with
the right sequence of events if we would like to promote one of current
standbys to master and convert master to standby?
Your help is appreciated.
Thanks,
Julie
From: Julie
Hello,
We set up our hot standby by putting master into archive mode and issuing
pg_basebackup command, and we are about to start our hot standby instance. What
are the things you suggest for validation (assuming it will come up cleanly)
and replication caught up?
What do I need to check in add
Hello everybody, I am new to postgresql environment, but trying to get up to
speed.
Can you please share your experience on how you can automate refreshment of dev
environment on regular basis (desirably weekly), taking for consideration some
of prod dbs can be very large (like 20+ TB
Any sugge
Hello everybody,
I've inherited big complicated postgresql kingdon with multiple servers in it,
some of them are replicated, some of them are not, and there is Bunch of them.
What would you be your suggestion, how should I start my investigation what is
master, what is replicas, is there any slo
les or intensively used tables.
I hope I'm clear enough!
Feel free to ask for clarification or add new elements to go further on!
Hope this helps,
Have a nice day,
Thomas
Le mer. 20 févr. 2019 à 21:37, Ron
mailto:ronljohnso...@gmail.com>> a écrit :
On 2/19/19 5:02 PM, Julie Nishimura wrote:
Does anyone use this solution? any recommenations?
Thanks!
Hello, we are almost out of space on our main data directory, and about to
introduce new directory to our cluster. We cannot use multiple physical disks
as a single volume, so we are thinking about creation new tablespace.
Our current data_directory shows as follows:
/data/postgresql/9.6/main
po
Hello, we are almost out of space on our main data directory, and about to
introduce new directory to our cluster. We cannot use multiple physical disks
as a single volume, so we are thinking about creation new tablespace.
Our current data_directory shows as follows:
/data/postgresql/9.6/main
pos
91 matches
Mail list logo