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
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,
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
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
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
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
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
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
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
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
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
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
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
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
. 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
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
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
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
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
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
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.
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
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,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
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
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
26 matches
Mail list logo
