>The mix between 13 and 15 here is what I’d consider a misconfiguration.
As I inherited this (and I'm somewhat new to pgsql), I'm trying to understand
this. From the docs I read online, the postmaster.pid file is supposed to
reside in the data directory. Which it does. So that's ok.
Does the
nal Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Friday, April 7, 2023 6:47 PM
To: Telium Technical Support ;
pgsql-general@lists.postgresql.org
Subject: Re: pg_ctlcluster is not stopping cluster
On 4/7/23 15:27, Telium Technical Support wrote:
> I am string to stop my Postg
: Friday, April 7, 2023 6:46 PM
To: Telium Technical Support
Cc: pgsql-general@lists.postgresql.org
Subject: Re: pg_ctlcluster is not stopping cluster
I wonder if the best way to proceed would be to go on to individual nodes in
the cluster and use OS level commands (such as ps) to track
I am string to stop my PostgreSQL (on debian 11) server using the following
command
root@d11:/# sudo -u postgres /usr/bin/pg_ctlcluster 15 main stop -- -m fast
-D /var/lib/postgresql/13/main
Notice: extra pg_ctl/postgres options given, bypassing systemctl for stop
operation
pg_ctl: PID file "
On 5/14/2020 6:33 AM, Tom Lane wrote:
Support writes:
I think David caught it, the question is Why, as long as we have an
exact copy of the master (from pg_dumpall)
Stop right there. pg_dumpall does *not* produce an exact copy.
It produces a logically equivalent copy, which is not close
On 5/13/2020 9:28 PM, David G. Johnston wrote:
On Wednesday, May 13, 2020, Michael Paquier <mailto:mich...@paquier.xyz>> wrote:
On Wed, May 13, 2020 at 02:12:45PM -0700, live-school support wrote:
> I didn't recal that it was not possible to create a hot standby
On 5/13/2020 1:24 PM, Laurenz Albe wrote:
On Wed, 2020-05-13 at 06:18 -0700, Support wrote:
On 5/8/2020 1:51 PM, Support wrote:
I normalized my replislots with the name of my nodes.
I have 2 options in my recovery script that tries first pg_basebackup
to recover and sync the hot standby, but
On 5/13/2020 1:24 PM, Laurenz Albe wrote:
On Wed, 2020-05-13 at 06:18 -0700, Support wrote:
On 5/8/2020 1:51 PM, Support wrote:
I normalized my replislots with the name of my nodes.
I have 2 options in my recovery script that tries first pg_basebackup
to recover and sync the hot standby
Best Regards
LIVE-SCHOOL FOUNDATION
http://www.live-school.net
in...@live-school.net
On 5/13/2020 1:24 PM, Laurenz Albe wrote:
On Wed, 2020-05-13 at 06:18 -0700, Support wrote:
On 5/8/2020 1:51 PM, Support wrote:
I normalized my replislots with the name of my nodes.
I have 2 options in my
On 5/8/2020 1:51 PM, Support wrote:
I normalized my replislots with the name of my nodes.
I have 2 options in my recovery script that tries first pg_basebackup
to recover and sync the hot standby, but unfortunately big DB fails
sometimes due
to very slow or unstable network. So my second
On 5/8/2020 11:51 PM, Paul Förster wrote:
Hi Admin,
On 08. May, 2020, at 21:31, Support wrote:
2) Command run?
ssh postgres@nodeXXX "pg_basebackup -h /run/postgresql -Ft -D- | pigz -c -p2 "
| pigz -cd -p2 | tar -xf- -C /usr/local/pgsql/data
I don't get it, sorry. Do I
I normalized my replislots with the name of my nodes.
I have 2 options in my recovery script that tries first pg_basebackup
to recover and sync the hot standby, but unfortunately big DB fails
sometimes due
to very slow or unstable network. So my second option is to completely
make a new inidb an
On 5/8/2020 1:24 PM, Adrian Klaver wrote:
On 5/8/20 12:31 PM, Support wrote:
On 5/8/2020 12:18 PM, Adrian Klaver wrote:
On 5/8/20 12:14 PM, Support wrote:
Hi,
Despite of the --help saying that it's possible to gzip to STDOUT
and pipe it for another process
pg_basebackup fails s
On 5/8/2020 12:18 PM, Adrian Klaver wrote:
On 5/8/20 12:14 PM, Support wrote:
Hi,
Despite of the --help saying that it's possible to gzip to STDOUT and
pipe it for another process
pg_basebackup fails saying that it's not possible to gzip to STDOUT.
1) Postgres version?
2) C
Hi,
Despite of the --help saying that it's possible to gzip to STDOUT and
pipe it for another process
pg_basebackup fails saying that it's not possible to gzip to STDOUT.
Who to believe then?
Hi Folks,
is there a way to refresh/reset/reinit the internal replication slot
identifier
for a freshly new hot standby initdb and pg_dumpall?
For now the master complain that the identifier (a bigint) of the node
does not match with
the replication slot identifier. So if there is a way to res
On 01/27/2018 06:43 PM, Adrian Klaver wrote:
On 01/27/2018 04:34 PM, support-tiger wrote:
sorry for delay but ran some tests on older version pg gem - still fails
With what error message?
What Ruby gem?
it fails on building the config file with simply missing libpq-fe.h,
cannot find
ver wrote:
On 01/25/2018 12:20 PM, support-tiger wrote:
running postgresql 10.1 on Fedora 27. Cannot install ruby pg gem due
to missing libpq-fe.h file. This is usually found in
postgresql-devel but
What was the error message returned when you tried to install originally?
it is not in fedora 2
10.1 How can we install the necessary libpq-fe.h ? thks
--
Support Dept
Tiger Nassau, Inc.
www.tigernassau.com
406-624-9310
he docs for understanding hba_conf are not good (yes we can read
and are fairly smart) - we made suggestions the last time for several
case examples and were ignored - okay, simplicity of pouchdb/couchdb is
getting our attention
I suspect it's possible we used to ignore malformed lin
the log file
postgres remains so damn difficult and time wasting to quickly get up
and running vs other db's and docs don't help much
--
Support Dept
Tiger Nassau, Inc.
www.tigernassau.com
406-624-9310
postgresql ? Thks.
--
Support Dept
Tiger Nassau, Inc.
www.tigernassau.com
406-624-9310
Oleg,
hey, thanks so much - if you are in USA visiting Yellowstone Natl Park
contact me and the beer is on me (maybe a Wyoming steak too!)
On 11/22/2017 11:27 PM, Oleg Bartunov wrote:
On Thu, Nov 23, 2017 at 4:45 AM, support-tiger wrote:
is there a way to update a single field in jsonb
is there a way to update a single field in jsonb without replacing the
entire json document - couldn't find an example
for example
create table test (id primary key, data jsonb);
insert into test ({"name":"bill", "age":29});
?? update test set data->a
24 matches
Mail list logo
