On Tue, 2024-07-02 at 18:13 +0200, clippe...@gmx.fr wrote:
>
> Hi all
> I don't know if it is the right mailing list, but i was wondering if
> one could introspect via gdb the content of PGresult.
> In my case i got a coredump and when i tried to analyze the core and
> try to print the content of
On Mon, 2022-12-12 at 18:16 +0100, Matthias Apitz wrote:
>
> Hello,
>
> Is there some interpretation of the names of the WAL files available?
>
> Thanks
>
> matthias
Hi,
http://eulerto.blogspot.com/2011/11/understanding-wal-nomenclature.html
seems to break it down.
On Sat, 2022-06-04 at 06:32 +0800, BeginnerC wrote:
> Hello everyone,
> I am a newbie to the postgres,when I use the psql to connect to the
> postgres,a error message printed:
> These command list like this:
>
> psql -U postgres
> Password for user postgres:postgres
> postgreSQL: password authenti
On Fri, 2022-04-29 at 13:21 -0700, Rich Shepard wrote:
> On Fri, 29 Apr 2022, Reid Thompson wrote:
>
> > https://linuxgazette.net/issue14/bashtip.html may of of use.
>
> Reid,
>
> I've had no issues using joe in any v.t. running an application
> (e.g.,
> alp
On Fri, 2022-04-29 at 11:10 -0700, Rich Shepard wrote:
> On Fri, 29 Apr 2022, Jan Wieck wrote:
>
> > Not that I know of. \e starts the external editor and you have to
> > save and
> > exit that editor to get back to psql in order to execute it. IMHO
> > the
> > whole construct has very limited usa
someone mentioned an alternative earlier that they couldn't remember -- i think
it may have been pgsodium that they were thinking of
https://github.com/michelp/pgsodium
Responses inline below
Thanks,
reid
-Original Message-
From: Tom Lane
Sent: Monday, April 19, 2021 9:54 AM
To: Reid Thompson
Cc: pgsql-general@lists.postgresql.org
Subject: Re: could not read from hash-join temporary file: SUCCESS && DB goes
into recovery mode
Reid Thompson
Alvaro,
Thanks for the responses and the explanation. It is appreciated. We will
investigate re-writing the query to minimize the result set.
Thanks again.
reid
-Original Message-
From: Alvaro Herrera
Sent: Monday, April 19, 2021 11:59 AM
To: Reid Thompson
Cc: pgsql-general
issue until then?
-Original Message-
From: Alvaro Herrera
Sent: Monday, April 19, 2021 10:09 AM
To: Reid Thompson
Cc: pgsql-general@lists.postgresql.org
Subject: Re: could not read from hash-join temporary file: SUCCESS && DB goes
into recovery mode
[EXTERNAL SOURCE]
On 202
Hi I'm looking for some guidance related to the subject line issue.
PostgreSQL 11.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623
(Red Hat 4.8.5-39), 64-bit
128GB RAM
pgsql_tmp is on a FS with 2+TB free
Information that I've been able to find on the web indicates
1. That the er
On Tue, 2021-03-02 at 14:16 +0530, Brajendra Pratap Singh wrote:
> unable to connect to 'dbname='postgres' port=5432': could not connect to
> server: No such file or directory
> Is the server running locally and
> accepting
>
On Mon, 2020-09-28 at 12:15 -0400, Tom Lane wrote:
> Reid Thompson writes:
> > We have a planned upgrade that would permanentlty remedy this.
> > regarding the below errors on our PG 9.6.x instance.
>
> > 2020-09-28 09:08:15.741 EDT,,,26212,,5f71e03f.6664,1,,2020-09-
We have a planned upgrade that would permanentlty remedy this.
regarding the below errors on our PG 9.6.x instance.
2020-09-28 09:08:15.741 EDT,,,26212,,5f71e03f.6664,1,,2020-09-28 09:08:15
EDT,250/9136136,0,ERROR,XX001,"found xmin 2675436435 from before relfrozenxid
321165377","automatic v
On Mon, 2020-03-23 at 03:24 -0700, pinker wrote:
> [EXTERNAL SOURCE]
>
>
>
> Hi, do you have maybe idea how to make loading process faster?
>
> I have 500 millions of json files (1 json per file) that I need to load to
> db.
> My test set is "only" 1 million files.
>
> What I came up with now
On Sun, 2019-10-27 at 16:54 -0700, Adrian Klaver wrote:
> https://urldefense.proofpoint.com/v2/url?u=https-3A__sourceforge.net_projects_pgformatter_&d=DwICaQ&c=w8fEmIi-B5lsC0MnOiGTloUx5YmN70-3jVCmqqbXNxM&r=4r1gVE34nFB7YgioINuzq1cdGrlIBszDh26sKYP7ux8&m=9zYVbOR6UMXoTr5abTczqiDnMEYJ1mNU7uePMEtYLJ8&s=7
On Thu, 2019-10-17 at 11:16 +, M Tarkeshwar Rao wrote:
> [EXTERNAL SOURCE]
>
>
>
> Hi all,
>
> How to fetch certain number of tuples from a postgres table.
>
> Same I am doing in oracle using following lines by setting prefetch attribute.
>
> For oracle
> // Prepare query
> if( OC
On Thu, 2019-08-22 at 09:01 -0400, Reid Thompson wrote:
> On Thu, 2019-08-22 at 08:25 -0400, Reid Thompson wrote:
> > On Wed, 2019-08-21 at 17:15 -0400, stan wrote:
> > > [EXTERNAL SOURCE]
> > >
> > >
> > >
> > > I have a situation where we
On Thu, 2019-08-22 at 08:25 -0400, Reid Thompson wrote:
> On Wed, 2019-08-21 at 17:15 -0400, stan wrote:
> > [EXTERNAL SOURCE]
> >
> >
> >
> > I have a situation where we need to import data, as an interim measure,
> > from spreadsheets.
> >
>
On Wed, 2019-08-21 at 17:15 -0400, stan wrote:
> [EXTERNAL SOURCE]
>
>
>
> I have a situation where we need to import data, as an interim measure,
> from spreadsheets.
>
> I have read up on \copy and COPY, but I do not see that either of these can
> use the header from a CSV file to define a ne
Hi,
I have the following configuration.
pg9.6_master --> streaming replica pg9.6_standy
--> pg_logical replication of several schemas to pg9.6_logical
We plan to perform a managed fail over of pg9.6_master to pg9.6_standy.
As part of the fail over, the virtual IP address and hostnam
20 matches
Mail list logo
