䄀瀀漀氀漀最椀攀猀 昀漀爀 琀栀攀 最椀戀戀攀爀椀猀栀 攀瘀攀爀礀漀渀攀⸀ 伀甀琀氀漀漀欀 搀攀昀愀甀氀琀猀 琀漀 䠀吀䴀䰀Ⰰ 䤀 栀愀瘀攀渀✀琀
瀀漀猀琀攀搀 椀渀 瀀爀漀戀愀戀氀礀 洀漀爀攀 琀栀愀渀 愀 礀攀愀爀 愀渀搀 昀漀爀最漀琀 琀漀 猀攀琀 椀琀 琀漀 瀀氀愀椀渀 琀攀砀琀⸀ 吀栀攀
猀椀最渀愀琀甀爀攀 䤀 挀愀渀✀琀 搀漀 愀渀礀琀栀椀渀最 愀戀漀甀琀Ⰰ 琀栀愀琀✀猀 愀甀琀漀洀愀琀椀挀愀氀氀礀 愀搀搀攀搀 愀昀琀攀爀 䤀 栀椀琀
猀攀渀搀⸀ഀഀഀഀഀ匀挀漀琀 䬀爀攀椀攀渀欀愀洀瀀 簀 䄀瀀瀀氀椀挀愀琀椀漀渀猀 䤀渀昀爀愀猀琀爀甀挀琀甀爀攀 䄀爀挀栀椀琀攀
䠀椀 吀漀洀Ⰰഀഀ䤀昀 琀栀攀 瀀氀愀渀 搀椀搀渀✀琀 挀栀愀渀最攀 琀栀攀渀 琀栀攀 猀琀愀琀猀 甀瀀搀愀琀攀猀 眀攀爀攀渀✀琀 瘀攀爀礀
爀攀氀攀瘀愀渀琀⸀ഀ䤀 愀洀 最甀攀猀猀椀渀最 琀栀愀琀 琀栀攀 愀挀琀甀愀氀 瀀爀漀戀氀攀洀 眀愀猀 琀栀愀琀 琀栀漀猀攀 琀愀戀氀攀猀
眀攀爀攀ഀ昀甀氀氀 漀昀 搀椀爀琀礀 爀漀眀猀Ⰰ 愀渀搀 琀栀攀 嘀䄀䌀唀唀䴀 ⠀渀漀琀 琀栀攀 䄀一䄀䰀夀娀䔀 瀀愀爀琀⤀ 最漀琀 爀椀搀ഀ漀昀
搀攀愀搀 爀漀眀猀Ⰰ 猀攀琀 栀椀渀琀 戀椀琀猀 漀渀 爀攀挀攀渀琀氀礀ⴀ甀瀀搀愀琀攀搀 爀漀眀猀Ⰰ 愀渀搀 最攀渀攀爀愀氀氀礀ഀ搀椀搀 愀 氀漀琀
use
all of disk 2, then use all of disk 3. The reason for that is with the default
you can add new disks one at a time. With striping you must add new disks
equal to the number of stripes. Either way I would still advise use of LVM.
Scot Kreienkamp | Applications Infrastructure Architect | La
a setup where you are multiplexing reads/writes across
all 3 SCSI controllers and disks instead of bottlenecking them all through 1
SCSI controller and disk at a time.
Scot Kreienkamp | Applications Infrastructure Architect | La-Z-Boy Corporate
One La-Z-Boy Drive | Monroe, Michigan 48162 | • (734) 3
Scot Kreienkamp | Senior Systems Engineer | La-Z-Boy Corporate
One La-Z-Boy Drive | Monroe, Michigan 48162 | Office: 734-384-6403 | Fax: |
Mobile: 7349151444 | E-mail: scot.kreienk...@la-z-boy.com
?
?
-Original Message-
From: Tom Lane
Sent: Monday, March 16, 2020 11:40 AM
To: Scot
icial repo
packages.
3) What was the connection string that you supplied to psql?
No connection string, so connected via socket. Psql -d rms.
Scot Kreienkamp | Senior Systems Engineer | La-Z-Boy Corporate
One La-Z-Boy Drive | Monroe, Michigan 48162 | Office: 734-384-6403 | Fax: |
Mobile: 7349
with pacemaker to relieve the PG
cluster of the additional load.
Scot Kreienkamp | Senior Systems Engineer | La-Z-Boy Corporate
One La-Z-Boy Drive | Monroe, Michigan 48162 | • 734-384-6403 | | • 7349151444
| • scot.kreienk...@la-z-boy.com
www.la-z-boy.com<http://www.la-z-boy.com> |
facebo
replication,postgres172.17.0.0/16
md5
hostnossl replication replication,postgres10.29.0.0/16
md5
Please suggest what I have missed.
Regards,
Daulat
Scot Kreienkamp |Senior Systems Engineer | La-Z-Boy Corporate
One La-Z-Boy Drive| Monroe, Michigan 48162
Basically anything that is not written as a sql query should be connected
directly to PG. PGBouncer is really only meant for SQL query type connections.
From: Raghavendra Rao J S V [mailto:raghavendra...@gmail.com]
Sent: Monday, April 8, 2019 10:19 AM
To: Scot Kreienkamp
Cc: pgsql-general
Replication and several other admin type operations must connect directly to
PG. They are not supported through PGBouncer.
From: Raghavendra Rao J S V [mailto:raghavendra...@gmail.com]
Sent: Monday, April 8, 2019 9:21 AM
To: pgsql-general@lists.postgresql.org
Subject: Getting error while running
ff and not fit for every use, that's why
we also use the traditional backup/restore in some cases.
Scot Kreienkamp |Senior Systems Engineer | La-Z-Boy Corporate
One La-Z-Boy Drive| Monroe, Michigan 48162 | Office: 734-384-6403 | | Mobile:
7349151444 | Email: scot.kreienk...@la-z-boy.
How about pausing replication while you’re running the backup? I have a mirror
dedicated to backups, it pauses replication by cron job every night before the
backup, then resumes midday after I’ve had enough time to find out if the
backup was successful.
Scot Kreienkamp |Senior Systems
The best way I came up with for older versions is:If timeout -s 9 10 psql
-d DBNAME -c "select 1" >/dev/null ; then
And on newer versions, use the pg_isready command.
Scot Kreienkamp |Senior Systems Engineer | La-Z-Boy Corporate
One La-Z-Boy Drive| Monroe, Michigan 48
o a single record for the query results which would let the
sum and group by work.
Scot Kreienkamp |Senior Systems Engineer | La-Z-Boy Corporate
One La-Z-Boy Drive| Monroe, Michigan 48162 | Office: 734-384-6403 | | Mobile:
7349151444 | Email: scot.kreienk...@la-z-boy.com
From: Chuck Mar
union select name,unnest(auditenvironment)
as environment from servers order by name) t
group by environment order by environment;
Cheers!
Scot Kreienkamp |Senior Systems Engineer | La-Z-Boy Corporate
One La-Z-Boy Drive| Monroe, Michigan 48162 | Office: 734-384-6403 | |
Mobile: 7349151444 | Email: sco
class taking into account the secondary class
column and I'm completely baffled on how to do so with the array. I know the
any trick and use it to match against the array when querying for specific
primary and secondary classes but I can't figure out how to generate the
listing the same as t
. Any limitations on using it with cascading replication? For instance,
can I setup a replication slot on a standby, then replicate using that slot
from another standby?
3. Or can I only replicate from the master when using replication slots?
Thanks!
Scot Kreienkamp | Senior Systems Eng
which node to activate the VIP on. In the script have it check which
node is the master, and it will activate that VIP on the master. When you
transition the master to another server the VIP will travel with the master.
Scot Kreienkamp |Senior Systems Engineer | La-Z-Boy Corporate
One La-Z-Boy
Point it at a VIP that travels with the master.
Scot Kreienkamp |Senior Systems Engineer | La-Z-Boy Corporate
One La-Z-Boy Drive| Monroe, Michigan 48162 | Office: 734-384-6403 | | Mobile:
7349151444 | Email: scot.kreienk...@la-z-boy.com
From: Madan Kumar [mailto:madankumar1...@gmail.com]
Sent
have to mount the
archive via NFS like I had before, not a big deal.
As an alternative to NFS I was thinking about making the archives available via
HTTPD and using wget or curl in my script instead of a copy from NFS. That
seems like it would work better from the remote sites.
Scot Kreienkamp
Dang, I thought that sounded too good to be true. Oh well.
Thanks for setting me straight.
Scot Kreienkamp |Senior Systems Engineer | La-Z-Boy Corporate
One La-Z-Boy Drive| Monroe, Michigan 48162 | Office: 734-384-6403 | | Mobile:
7349151444 | Email: scot.kreienk...@la-z-boy.com
From: Don
g or did I misunderstand something?
Scot Kreienkamp | Senior Systems Engineer | La-Z-Boy Corporate
One La-Z-Boy Drive | Monroe, Michigan 48162 | * 734-384-6403 | | * 7349151444
| * scot.kreienk...@la-z-boy.com<mailto:%7BE-mail%7D>
www<http://www.la-z-boy.com/>.la-z-boy.com&l
like expected behavior.
Scot Kreienkamp |Senior Systems Engineer | La-Z-Boy Corporate
One La-Z-Boy Drive| Monroe, Michigan 48162 | Office: 734-384-6403 | | Mobile:
7349151444 | Email: scot.kreienk...@la-z-boy.com
From: Nicola Contu [mailto:nicola.co...@gmail.com]
Sent: Tuesday, October 16, 2018
you’re
describing would seem to be expected behavior.
Try this to see if the queries are actually waiting:
select * from pg_stat_activity where wait_event_type is not null or wait_event
is not null;
Scot Kreienkamp |Senior Systems Engineer | La-Z-Boy Corporate
One La-Z-Boy Drive| Monroe
Thanks Ron, glad to hear it worked and someone was successful at it. I’m on
the right path then.
Scot Kreienkamp |Senior Systems Engineer | La-Z-Boy Corporate
One La-Z-Boy Drive| Monroe, Michigan 48162 | Office: 734-384-6403 | | Mobile:
7349151444 | Email: scot.kreienk...@la-z-boy.com
From
tabases as empty again after that's
applied. That brings over everything except data.
Scot Kreienkamp |Senior Systems Engineer | La-Z-Boy Corporate
One La-Z-Boy Drive| Monroe, Michigan 48162 | Office: 734-384-6403 | |
Mobile: 7349151444 | Email: scot.kreienk...@la-z-boy.com
This message
Scot Kreienkamp |Senior Systems Engineer | La-Z-Boy Corporate
One La-Z-Boy Drive| Monroe, Michigan 48162 | Office: 734-384-6403 | |
Mobile: 7349151444 | Email: scot.kreienk...@la-z-boy.com
> -Original Message-
> From: Tom Lane [mailto:t...@sss.pgh.pa.us]
> Sent: Wednesday,
doing a single threaded dump my only option
to get a good backup? I have to be able to revert to the old server as this is
production, so doing in place upgrades are not possible... the original server
has to remain pristine.
Thanks!
Scot Kreienkamp | Senior Systems Engineer | La-Z-Boy Corpora
28 matches
Mail list logo
