licas will have the same
checkpoint location as the primary?
Thanks in advance,
Richard
i installed pg13 from the postgres repos but am not really using it
in that form; i'm using docker images instead. i now find i need
to uninstall it to facilitate upgrading my desktop to ubuntu 24
is apt remove an effective way to uninstall or is there a better method?
thanks,
richard
not really in direct response to this conversation, but is there any reason
on the face of the planet why read receipts need to be sent to every single
recipient of the mailing list?
just saying,
richard
On Fri, 28 Jun 2024 03:20:26 -0400 wrote ---
HOO-HA! This is HUGE
ok, sorted it out. one of two things happened, either docker got
fussier about correct environment settings on the upgrade, or i
screwed up an edit of the environment file. i prefer to blame
docker rather than myself for obvious reasons...
richard
On Mon, 19 Feb 2024 17:00:10
'))
this suggests that postgresql is not being configured properly for access from
the container
containing the web app. i have included the configurations from
docker-compose.yml below -
but this is the same docker-compose.yml that is currently working on Ubuntu and
was working
until t
On Sun, Feb 5, 2023 at 3:05 PM Erik Wienhold wrote:
> > On 05/02/2023 23:17 CET Richard Brockie
> wrote:
> >
> > I maintain a Django webapp that uses postgresql and can create
> inefficient
> > queries if I'm not careful. I'm looking for ways to mimic a c
could, for example limit the number of transactions/second to a
certain level by adjusting postgresql.conf?
Many thanks!
--
R.
Richard Brockie
Real-time bicycle race management - www.ontheday.net
didn't notice that. pgadmin4 was working anyway but i changed it to jammy and
updated anyway.
richard
On Thu, 10 Nov 2022 11:31:07 -0500 Adrian Klaver
wrote ---
On 11/10/22 08:19, Richard Welty wrote:
> and that was it. uncommented the line in
>
> /etc/apt/
and that was it. uncommented the line in
/etc/apt/sources.list.d/pgadmin4.list
updated and asked for an upgrade and it worked.
only reason i found it was i went looking to verify which repo
i was using and saw the comment.
richard
On Thu, 10 Nov 2022 11:15:02 -0500 Richard
may have just found the issue:
# deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/focal pgadmin4 main #
disabled on upgrade to jammy
will retry shortly.
richard
On Thu, 10 Nov 2022 10:58:12 -0500 Adrian Klaver
wrote ---
On 11/10/22 07:48, Richard Welty wrote
g when the repo might get updated, or whether i should
be concerned about it at all.
thanks,
richard
Thanks very much - 7-zip (from https://www.7-zip.org/) was just the job to
unpack the archive where Windows "Extract all" failed.
Richard
> -Original Message-
> From: Erik Wienhold
> Sent: 21 September 2022 14:44
> To: Thomas, Richard ; pgsql-
> gene...@lists
ndows zip declares invalid. Other zip files (e.g. the 32-bit version)
download and unzip quite happily. I've dropped Enterprise an email, but in the
meantime wonder if there are any other (reputable!) binaries download sites I
could use?
Richard
At Atkins - member of the SNC-Lavalin Grou
or a cloud-based PaaS.)
Richard
> > Adrian Klaver wrote:
> >> On 4/20/22 01:06, Thomas, Richard wrote:
>
> >>> - pg_dump.exe executable is not excluded from McAfee on-access
> >>> scanning (although as recommended postgres.exe is)
> >>
> >
Adrian Klaver wrote:
> On 4/20/22 01:06, Thomas, Richard wrote:
> > The command used in a PowerShell script (run with Windows task scheduler)
> to dump each database should evaluate to:
> >
> > "C:\Program Files\PostgreSQL\10\bin\pg_dump.exe" -b -v -F c -d $
onnect to server: Connection refused (0x274D/10061)
Is the server running on host "localhost" (127.0.0.1) and accepting
TCP/IP connections on port 6488?
could not connect to server: Connection refused (0x274D/10061)
Is the server running on host &
ter initdb
on version 10
- I hoped to run pg_catcheck but cannot find a binary version of this online
and I think it would take me quite a lot of work to build it myself (I don’t
have Visual Studio, only VSC).
Richard
2022-04-02 02:14:53 BST: [7480]
user=scde_suad,db=a9sde,app=pg_dump,host=
Ah... no - the AV is still allowed to run riot in the folder where the dump
file is written to. Do you think that could be the issue?
Richard
-Original Message-
From: Adrian Klaver
Sent: 06 April 2022 15:42
To: Thomas, Richard ;
pgsql-general@lists.postgresql.org
Subject: Re
on with the database (not an
option with the EDB PostgreSQL Windows Installer) and can't be turned on after
initdb on version 10
* I hoped to run pg_catcheck but cannot find a binary version of this
online and I think it would take me quite a lot of work to build it myself (I
don't h
ide which index is most beneficial to use?
The author of that SO post tried to adjust the default statistics target,
presumably to convince postgres to use the faster primary key index,
instead of the slower gist index on the hstore values, but this didn't work.
thanks,
richard
> On Wed,
On Fri, Sep 10, 2021 at 10:38 AM Laurenz Albe
wrote:
> On Thu, 2021-09-09 at 16:51 +0200, Richard Michael wrote:
> > > > 2/ EXPLAIN EXECUTE of prepared statement doesn't show query text, as
> the
> > > > documentation seems to imply. Should it?
> > &g
On Thu, Sep 9, 2021 at 7:39 PM Tom Lane wrote:
> Richard Michael writes:
> > Would a tiny patch to the PREPARE docs be accepted? I'd like to help
> > clarify investigating `plan_cache_mode` for future readers.
>
> What did you have in mind?
>
> (I'm kin
Hi Tom,
On Thu, Sep 9, 2021 at 6:02 PM Tom Lane wrote:
> Richard Michael writes:
> > After reading Laurenz's reply, I experimented again with `PREPARE
> > basic(int) AS SELECT $1 AS number;" and the query plan logged in the log
> > file (by auto_explain) does
Hi David,
On Sun, Sep 5, 2021 at 8:32 PM David G. Johnston
wrote:
> On Sunday, September 5, 2021, Richard Michael
> wrote:
>
>>
>> Based on the documentation, I expected the first planned query text to
>> be: `SELECT 10 AS data`, since it should be a custom plan
Hi Laurenz,
Thank you for the quick response and clear demonstration. I have a few
comments, inline below.
On Mon, Sep 6, 2021 at 8:26 AM Laurenz Albe
wrote:
> On Sun, 2021-09-05 at 14:20 -0400, Mladen Gogala wrote:
> > On 9/5/21 9:35 AM, Richard Michael wrote:
> > > TL;D
PLAIN EXECUTE one_param(10);
LOG: duration: 0.000 ms plan:
Query Text: PREPARE one_param AS SELECT $1 AS data;
Result (cost=0.00..0.01 rows=1 width=32)
Output: '10'::text
```
Let me know if I should post my postgresql.conf and `auto_explain` settings.
Thanks for any advice,
Richard
prefix="cn=" ldapsuffix=", dc=example, dc=org"
ldapport=389
For anyone who comes across this in the future, I have also compiled as
short YouTube video to demonstrate the behavior of the two formats:
https://youtu.be/kjlwwfHdpWg
--Richard
> Regards,
> Virendra
&g
You're welcome. It is not real data: It was just a sample.
On Fri, Jun 19, 2020 at 12:08 PM Paul Förster
wrote:
> Hi,
>
> > On 19. Jun, 2020, at 17:30, Richard Bernstein
> wrote:
> >
>
> thanks for posting all private data to a public list!
>
> Can some
Hi Stan. I have been dealing with this lately. I have a Chrome Extension
that does work gathering the info to save in the postgresql, such as screen
scraping a specific tab. I am using AWS RDS hosted Postgresql, btw. I am
not sure however, due to security reasons, that you can open a connection
*d
On 5/23/20 1:08 AM, Richard Suematsu wrote:
> Hi, Trying to update postgis24_10 on centos6 but it fails on a
> libgeotiff dependency. On another machine, it looks like libgeotiff
> comes from @pgdg11, but I don't see it there anymore.
I suspect this:
https://yum.postg
dency Resolution
Error: Package: gdal-libs-1.9.2-8.rhel6.x86_64 (pgdg-common)
Requires: libgeotiff.so.2()(64bit)
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
Richard Suematsu
Development Manager
SYNCADD Systems, Inc.
PGSQLCommunities,
We migrated Oracle 11.x Database to PostgreSQL 12.x Database on a RH Linux
7.x server.
On a different RH Linux 7.x Server, I have Oracle Client installed. Since
we have many scripts developed in Oracle SQL, is it possible for the
PostgreSQL 12.x DB to process the Oracle Scr
I am using postgresql on RDS. I need to upload an image to the table. I
understand that I need to set the PGDATA directory and place the image file
in it, before setting the path in the bytea field. But how do I set PGDATA
if I don't have the ability to set an environment variable, and don't have
a
On 16/01/2020 17:48, Tom Lane wrote:
Richard van der Hoff writes:
On 16/01/2020 17:12, Magnus Hagander wrote:
See https://wiki.postgresql.org/wiki/Locale_data_changes for hints on
which linux distros updated when.
It seems like a plausible explanation but it's worth noting that al
On 16/01/2020 17:27, Adrian Klaver wrote:
On 1/16/20 9:24 AM, Richard van der Hoff wrote:
It seems like a plausible explanation but it's worth noting that all
the indexed data here is (despite being in text columns), plain ascii.
I'm surprised that a change in collation rules wo
On 16/01/2020 17:24, Daniel Verite wrote:
Looking at these columns which are of type text but do not
contain words of any particular language, there's probably
no point in using a linguistic-aware collation for them.
If you maintain the database schema, what you could do to avoid
the dependen
On 16/01/2020 17:12, Magnus Hagander wrote:
On Thu, Jan 16, 2020 at 6:08 PM Tom Lane wrote:
Richard van der Hoff writes:
I'm trying to track down the cause of some duplicate rows in a table
which I would expect to be impossible due to a unique constraint. I'm
hoping that som
I'm trying to track down the cause of some duplicate rows in a table
which I would expect to be impossible due to a unique constraint. I'm
hoping that somebody here will be able to suggest something I might have
missed.
The problem relates to a bug filed against our application
(https://githu
Hi,
I have completed the steps at
https://www.postgresql.org/docs/current/ssl-tcp.html#SSL-CLIENT-CERTIFICATES
Specifically:
To create a server certificate whose identity can be validated by clients,
first create a certificate signing request (CSR) and a public/private key
file:
openssl req -
acted. This a fatal error of course. Any hint, tips or "Oh man
you should have" etc will be greatly appreciated.
/Richard
We think we have found our missing step. We needed to do an ordered shutdown of
the original primary before promoting the standby
I.e.
>1. Make some changes to the A (the primary) and check that they are replicated
>to the B (the standby)
Missing step:
Perform ordered shutdown of A (the pr
> Now once your master A can’t become slave of B.
Isn’t that the exact situation that pg_rewind should take care of?
This email and any attachments may contain confidential information. If you are
not the intended recipient, your use or communication of the information is
strictly prohibited.
l directory.but it never
appears in the wal_archive directory - not even if we issue a checkout or even
restart the server.
0003.history does not appear to exist on either of the machines.
Any ideas what we are doing wrong?
Thanks. Richard
This email and any attachments ma
43 matches
Mail list logo
