I am compiling an application that uses postgreSQL 13 and Qt 5.12. I have built
the latter from scratch and successfully linked with libraries for postgreSQL
9.6 (the current version on CentOS 7) but have run into problems with
postgreSQL 13. The server, client and libs are available in the post
On 01/05/2021 08:58 PM, H wrote:
> I am compiling an application that uses postgreSQL 13 and Qt 5.12. I have
> built the latter from scratch and successfully linked with libraries for
> postgreSQL 9.6 (the current version on CentOS 7) but have run into problems
> with postgreSQL 13
I am running postgreSQL 13 server/client successfully on my workstation but am
having problems setting it up in a docker container, both running CentOS 7. I
have previously run postgreSQL 9.6 successfully in docker but right now I am
unable to initialize the database under pg 13. For some reason
I am running postgres 13 under CentOS 7. I have a need to be able to page
through a table one row at a time, possibly using pspg (or other tool) allowing
me to move in either direction in the table one single row at a time. Ideally
only the columns in the selected row should be visible, even bet
On 07/20/2022 03:09 PM, H wrote:
> I am running postgres 13 under CentOS 7. I have a need to be able to page
> through a table one row at a time, possibly using pspg (or other tool)
> allowing me to move in either direction in the table one single row at a
> time. Ideally only th
On 07/22/2022 03:14 PM, Bruce Momjian wrote:
> On Fri, Jul 22, 2022 at 07:05:31AM -0600, Rob Sargent wrote:
>>
>>> On Jul 22, 2022, at 6:31 AM, H wrote:
>>>
>>> On 07/20/2022 03:09 PM, H wrote:
>>>> I am running postgres 13 under CentOS 7. I have
I am running PostgreSQL 13.11 and tried to drop all tables in a database
without dropping the database or schema. After logging in as the correct user,
the following SQL statement does not work:
SELECT 'DROP TABLE IF EXISTS "' || tablename || '" CASCADE;' FROM pg_tables
WHERE schemaname = 'pub
On 08/06/2023 09:24 PM, Christophe Pettus wrote:
>
>> On Aug 6, 2023, at 18:17, H wrote:
>>
>> Is there some setting I have to change in the database to have the first SQL
>> statement to work or have I run into a possible bug?
> The first statement just genera
Running Centos7 and PG13. I'd like to install the temporal_tables extension but
it does not seem to exist in postgresql13-contrib.
I did find the source code at https://github.com/arkhipov3/temporal_tables
which suggests to use the pgxn client to install it. The link to this client
found on thi
On November 27, 2023 6:58:40 PM GMT-05:00, Adrian Klaver
wrote:
>On 11/27/23 15:37, H wrote:
>> Running Centos7 and PG13. I'd like to install the temporal_tables
>extension but it does not seem to exist in postgresql13-contrib.
>
>If it is not here:
>
>https
On 11/27/2023 07:26 PM, Adrian Klaver wrote:
> On 11/27/23 16:18, H wrote:
>
>> The link to the pgxn client on the arkhipov's page leads to a
>> non-functioning website: pgxnclient.projects.pgfoundry.org.
>>
>> Does anyone if the pgxn client can be found s
On 11/27/2023 08:38 PM, Adrian Klaver wrote:
> On 11/27/23 17:17, H wrote:
>> On 11/27/2023 07:26 PM, Adrian Klaver wrote:
>>> On 11/27/23 16:18, H wrote:
>>>
>>>> The link to the pgxn client on the arkhipov's page leads to a
>>>> no
On November 27, 2023 8:48:35 PM GMT-05:00, Adrian Klaver
wrote:
>On 11/27/23 17:41, H wrote:
>> On 11/27/2023 08:38 PM, Adrian Klaver wrote:
>>> On 11/27/23 17:17, H wrote:
>
>>>> I have both make and gmake installed on the system but the issue
>seems to be
On 11/28/2023 12:38 AM, Adrian Klaver wrote:
> On 11/27/23 18:18, H wrote:
>> On November 27, 2023 8:48:35 PM GMT-05:00, Adrian Klaver
>> wrote:
>>> On 11/27/23 17:41, H wrote:
>>>> On 11/27/2023 08:38 PM, Adrian Klaver wrote:
>>>>> On 11/2
I used to successfully run psql server 13 in a CentOS 7 docker container with
CentOS 7 as the host operating system. I have now upgraded that system to Rocky
Linux 9 as the host operating system and modifying my container to also use
Rocky Linux 9 and psql server 16.
I can successfully get the
On July 11, 2024 11:06:02 AM GMT-04:00, Adrian Klaver
wrote:
>On 7/11/24 07:57, H wrote:
>> I used to successfully run psql server 13 in a CentOS 7 docker
>container with CentOS 7 as the host operating system. I have now
>upgraded that system to Rocky Linux 9 as the host opera
On July 11, 2024 2:20:43 PM EDT, Tom Lane wrote:
>H writes:
>> Good question! ”No success” meant that I have not been able to figure
>out how to have new databases default to en_US.UTF-8, instead they
>default to C.UTF-8.
>
>The default for an installation is determined a
On July 11, 2024 3:48:42 PM EDT, Tom Lane wrote:
>H writes:
>> Understood but how should formulate the initdb statement to
>accomplish what I want on pgsql 16 since the syntax I used for pgsql 13
>does not work in my container?
>
>You still haven't shown us the actual e
On July 11, 2024 3:31:37 PM EDT, Adrian Klaver
wrote:
>On 7/11/24 11:14, H wrote:
>> On July 11, 2024 11:06:02 AM GMT-04:00, Adrian Klaver
> wrote:
>>> On 7/11/24 07:57, H wrote:
>>>> I used to successfully run psql server 13 in a CentOS 7 docker
>>> con
Searching for the above. RHEL/CentOS 7 went EOL two weeks ago and it seems the
two files above have disappeared. Does anyone know where I can find them?
Needed for a project to work with PostgreSQL
13.
Thanks.
On Wed, 2024-07-17 at 20:36 -0400, H wrote:
> Searching for the above. RHEL/CentOS 7 went EOL two weeks ago and it seems
> the two files above have disappeared. Does anyone know where I can find them?
> Needed for a project to work with PostgreSQL
> 13.
>
> Thanks.
I should
On Wed, 2024-07-17 at 17:58 -0700, Adrian Klaver wrote:
> On 7/17/24 17:36, H wrote:
> > Searching for the above. RHEL/CentOS 7 went EOL two weeks ago and it seems
> > the two files above have disappeared. Does anyone know where I can find
> > them? Needed for a
I am looking for pg_config for postgresql 13.16 that I run under Rocky Linux 9.
It seems RL appstream latest version is pg_config in
libpq-devel-13.11-1.el9.x86_64 but dnf complains:
installed package postgresql13-"devel-13.16-2PGDG.rhel9.x86_64 obsoletes
libpq-devel <= 42.0 provided by libpq-de
On Tue, 2024-08-20 at 12:11 -0400, Ron Johnson wrote:
> On Tue, Aug 20, 2024 at 11:56 AM H wrote:
> > I am looking for pg_config for postgresql 13.16 that I run under Rocky
> > Linux 9. It seems RL appstream latest version is pg_config in
> > libpq-devel-13.11-1.el9.x86
On March 10, 2025 3:27:02 PM GMT-04:00, Francisco Olarte
wrote:
>On Mon, 10 Mar 2025 at 20:18, H wrote:
>> There are tables referencing each other using randomly generated IDs,
>ie. those IDs are not known until after the parent table row is
>inserted.
>
>Random?
On March 10, 2025 3:15:10 PM EDT, H wrote:
>On March 10, 2025 2:26:48 PM GMT-04:00, Adrian Klaver
> wrote:
>>
>>
>>On 3/10/25 11:09 AM, H wrote:
>>> I am developing a complex multi-tenant application in postgresql 16
>>in Linux. During the development I wou
On March 10, 2025 3:22:41 PM GMT-04:00, Francisco Olarte
wrote:
>On Mon, 10 Mar 2025 at 19:17, H wrote:
>...
>> After entering my test data into the markdown file for the given test
>scenario, I would then run an awk script or similar to create a SQL
>file with the various CTE
On March 10, 2025 3:21:57 PM GMT-04:00, "David G. Johnston"
wrote:
>On Mon, Mar 10, 2025 at 12:17 PM H wrote:
>
>> There are tables referencing each other using randomly generated IDs,
>ie.
>> those IDs are not known until after the parent table row is inserted.
&
On March 10, 2025 2:26:48 PM GMT-04:00, Adrian Klaver
wrote:
>
>
>On 3/10/25 11:09 AM, H wrote:
>> I am developing a complex multi-tenant application in postgresql 16
>in Linux. During the development I would like to be able to enter test
>data into various related tables
On March 11, 2025 2:59:35 AM EDT, Thiemo Kellner
wrote:
>DbVisualizer
>https://www.dbvis.com/docs/ug/exporting-a-grid/?_gl=1*1aoko6w*_up*MQ..*_ga*MTA0NjM4MTcxNi4xNzQxNjc2MDc0*_ga_9P463C7BC6*MTc0MTY3NjA3My4xLjEuMTc0MTY3NjEyNC4wLjAuODQ3OTY1NDMx*_ga_PTZV59MQGC*MTc0MTY3NjA3My4xLjEuMTc0MTY3NjEyNC4wLjA
On March 10, 2025 5:09:46 PM GMT-04:00, H wrote:
>On March 10, 2025 3:22:41 PM GMT-04:00, Francisco Olarte
> wrote:
>>On Mon, 10 Mar 2025 at 19:17, H wrote:
>>...
>>> After entering my test data into the markdown file for the given
>test
>>scenario, I would
I am developing a complex multi-tenant application in postgresql 16 in Linux.
During the development I would like to be able to enter test data into various
related tables at any given time for testing purposes.
While this can certainly be accomplished by predefined CTE INSERT statements in
an
Hi,
Am 28.07.2019 um 12:32 schrieb wambac...@posteo.de:
Hi,
is there a way to log output from "raise ..." to a local file? \o file
does not work (for me).
regards
walter
the red part writes your "raise notice" to your log
psql (+your connection string) -f /path/to/file.sql *>
/path/to/
Hello Bikram,
Am 22.08.2019 um 23:50 schrieb Bikram MAJUMDAR:
Hi,
Need help from anyone in the team who has worked on pgwatch2.
Yesterday we installed pgwatch2 docker image and started the container.
We are running the pgwatch2 container from the database server itself -
Now we want to add our
Hi Bikram,
Am 23.08.2019 um 22:10 schrieb Bikram Majumdar:
Hi George,
So nice for your response.
Thanks. But, my question is how does it get the IP address 172.17.0.2 ?
And, how does one run psql command to connect/login to the test
database ( pgwatch configuration database) to add any data
Hello Rob,
Am 12.02.2023 um 10:02 schrieb Rob Sargent:
Seems I've lost the table definition meta-command
riftehr=> \d actual_and_inf_rel_clean_final
ERROR: column c.relhasoids does not exist
LINE 1: ..., c.relhasindex, c.relhasrules, c.relhastriggers,
c.relhasoi...
while lis
Hi,
Am 15.08.2023 um 17:04 schrieb Russell Rose | Passfield Data Systems:
Hi there
I am trying to convert a SQL Anywhere database to postgres. Within SQL
anywhere a field can have a default value of ‘last user’. This means
that when you perform an update on a table, if the field is not
expl
Hello Markus,
keep it simple. Use a restored backup of the source db or this db itself
and then
Am 25.04.2024 um 09:55 schrieb Zwettler Markus (OIZ):
we have to migrate from hosted PG12 to containerized PG16 on private
cloud.
some of the installed PG12 extensions are not offered on the
contai
Hi,
Am 18.06.2021 um 09:15 schrieb goldgraeber-werbetech...@t-online.de:
Hi,
I just cannot see what is wrong with my query:
create table files (id int, name text, prev_name text, );
create table fnchanged (id int, name text);
update files f set prev_name = f.name, name = c.name from fncha
Hello Matthias,
Am 28.07.2021 um 15:40 schrieb Matthias Apitz:
El día martes, julio 27, 2021 a las 08:32:45p. m. +0200, Matthias Apitz
escribió:
Thank you, Pavel. This is ofc to much for a coffee mug. For using it as
a Reference Card in paper form, it's a pity that it is not written in Englis
there any resources which talks about Postgresql active-active node
implementation? If yes, please provide me the resource information or url.
Thanks
Vidyashree H S
ludes some trails on this. For that, I'm checking for the
resources.
Thanks
Vidyashree H S
From: Bruce Momjian
Sent: Friday, May 10, 2024 4:53 AM
To: Greg Sabino Mullane
Cc: Kashif Zeeshan ; Vidyashree H S
; pgsql-general@lists.postgresql.org
Subject: Re: Po
Hi,
*
Is that multi master replication is not recommended to do ?
*
If we can do, can I get any resource for implementing that on PostgreSQL which
is open-source?
Thanks,
Vidyshree H S
From: Vidyashree H S
Sent: Friday, May 10, 2024 10:48 AM
To: Bruce
Hello,
I am trying to use libpq for interfacing with PostgreSQL from a C/C++ based
application.
I have tried to use binary format of data for both sending and receiving data
to and from server (resultFormat = 1).
As I understand most binary types, int, float etc… are encoded in bing-endian
by
.
> On 06-Jul-2021, at 5:18 PM, Dmitry Igrishin wrote:
>
>
>
> On Tue, Jul 6, 2021, 14:04 Sudheer H R <mailto:sudheer...@tekenlight.com>> wrote:
> Hello,
>
> I am trying to use libpq for interfacing with PostgreSQL from a C/C++ based
> application.
>
Hi,
I am using Jboss EAP 6.1 version. For Database i am using the postgres
9.3 version. Can i upgrade to postgres 9.6 without any issue. I am also
considering to implement BDR 2.0, please let me know how i can get the
licensing details.
--
with regards
A H S Phanindra
46 matches
Mail list logo
