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
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?
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
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
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 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
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/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
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 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/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
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
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
postgresql ? Thks.
--
Support Dept
Tiger Nassau, Inc.
www.tigernassau.com
406-624-9310
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
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
10.1 How can we install the necessary libpq-fe.h ? thks
--
Support Dept
Tiger Nassau, Inc.
www.tigernassau.com
406-624-9310
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
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
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
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 "
: 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
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
>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
24 matches
Mail list logo
