Re: Time zone offset in to_char()

2024-01-11 Thread Adrian Klaver
mezone; TimeZone -- UTC (1 row) test=*# commit ; COMMIT test=# show timezone; TimeZone -- UTC (1 row) Frankly, I do hope that you’re right here, that would make my work easier. Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you&#x

Re: Time zone offset in to_char()

2024-01-11 Thread Adrian Klaver
check tomorrow. Frankly, I do hope that you’re right here, that would make my work easier. Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll find there is no forest. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Time zone offset in to_char()

2024-01-11 Thread Adrian Klaver
On 1/11/24 08:48, Adrian Klaver wrote: On 1/11/24 08:04, Alban Hertroijs wrote: The drawback, as mentioned, being that we need to maintain those functions in each deployment, which is a bit of a hassle (albeit a minor one) because we need to customise both the TDV side and the PostgreSQL

Re: Time zone offset in to_char()

2024-01-11 Thread Adrian Klaver
approach may have to suffice. The reason I decided to ask on the ML is that I'm finding it hard to believe that this transformation would be this difficult, so I expect that I must be missing something. Regards, Alban Hertroys -- Adrian Klaver adrian.kla...@aklaver.com

Re: Time zone offset in to_char()

2024-01-11 Thread Adrian Klaver
in the caching database before we can use them, while we have several environments where they would apply (DEV, pre-PROD, PROD). -- Adrian Klaver adrian.kla...@aklaver.com

Re: pgAdmin 8.1 install

2024-01-10 Thread Adrian Klaver
. Look in: D:\Users\dbarron-aas\AppData\Local\Programs\pgAdmin 4\runtime for pgAdmin4 Then double click on that. I'm guessing it will be 8.1. Per Craig's comment I'm betting that the icon/shortcut you are clicking on currently is pointing back at the 7.x version. -- Adrian Kl

Re: pgAdmin 8.1 install

2024-01-10 Thread Adrian Klaver
On 1/10/24 11:37 AM, David Barron wrote: I am running Windows 10. I downloaded the Dec 14 release from pgadmin.org I installed by double-clicking on the executable I downloaded and running through the installation wizard without making any changes. Well that looks good to m

Re: pgAdmin 8.1 install

2024-01-10 Thread Adrian Klaver
On 1/10/24 10:58 AM, David Barron wrote: On 1/10/24 10:47 AM, David Barron wrote: Is there a problem with the installation of 8.1?  I’ve installed it 3 times but when I bring it up it still says I’m at 7.8.  The Help > About menu shows 7.8 as well. What OS are you using? Where di

Re: pgAdmin 8.1 install

2024-01-10 Thread Adrian Klaver
On 1/10/24 10:47 AM, David Barron wrote: Is there a problem with the installation of 8.1?  I’ve installed it 3 times but when I bring it up it still says I’m at 7.8.  The Help > About menu shows 7.8 as well. What OS are you using? Where did you get pgAdmin from? How did you install it?

Re: Unable to install postgresql and pgadmin

2024-01-09 Thread Adrian Klaver
There is likely to be more folks there that could point you in the right direction. That’s why I wanted to find out if the software was compatible with my system. Cheers Innocent On Mon, 8 Jan 2024 at 16:42, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 1/8/24 0

Re: Unable to install postgresql and pgadmin

2024-01-08 Thread Adrian Klaver
compatible with my MacBook Air 2012,  iOS version 10.15. Where are you getting the software from? Show the commands you are using to install. What are the error messages you are getting? Looking forward to your reply Cheers Innocent -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to \ef a function ?

2024-01-08 Thread Adrian Klaver
he argument list (in case there's >1 with same name, diff arg list), but '()' doesn't work.  Does this have to do with the returned trigger type ? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Sample data generator for performance testing

2024-01-03 Thread Adrian Klaver
On 1/3/24 9:50 AM, arun chirappurath wrote: On Wed, 3 Jan, 2024, 23:03 Adrian Klaver, wrote: On 1/3/24 09:24, arun chirappurath wrote: > Hi Adrian, > > Thanks for your mail. > > Is this for all tables in the database or a subset? Yes Yes all tab

Re: Sample data generator for performance testing

2024-01-03 Thread Adrian Klaver
data do you want to produce?1Gb and 1Gb test data. If the source data is 1GB and the test data is 1GB then there is no sampling, you are using the data population in its entirety. On Wed, 3 Jan, 2024, 22:40 Adrian Klaver, <mailto:adrian.kla...@aklaver.com>> wrote: On 1/2/24 23

Re: Sample data generator for performance testing

2024-01-03 Thread Adrian Klaver
foreign key relationships? What are the sizes of the existing data and what size sample data do you want to produce? Regards, Arun -- Adrian Klaver adrian.kla...@aklaver.com

Re: encoding option when database backup

2024-01-03 Thread Adrian Klaver
cs/pgadmin4/latest/backup_dialog.html> where it mentions:- Use the Encoding drop-down listbox to select the character encoding method that should be used for the archive. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Import csv to temp table

2024-01-02 Thread Adrian Klaver
without connecting to the database. Then use that statement directly in the database. b) If SQLAlchemy can reach the database then csvkit should be able to. https://csvkit.readthedocs.io/en/latest/ <https://csvkit.readthedocs.io/en/latest/> Regards Arun -- Adrian Klaver adrian.kla...@aklaver.com

Re: New SET privilege for pg_has_role() in v16+

2024-01-02 Thread Adrian Klaver
On 1/2/24 08:15, Dominique Devienne wrote: On Tue, Jan 2, 2024 at 5:09 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 1/2/24 07:24, Dominique Devienne wrote: > pg_has_role() from > https://www.postgresql.org/docs/current/functions-info.

Re: New SET privilege for pg_has_role() in v16+

2024-01-02 Thread Adrian Klaver
https://rhaas.blogspot.com/2023/01/surviving-without-superuser-coming-to.html Thanks, --DD -- Adrian Klaver adrian.kla...@aklaver.com

Re: New SET privilege for pg_has_role() in v16+

2024-01-02 Thread Adrian Klaver
sively in our PostgreSQL-based apps, and I've read a lot about them, but at times I feel I'm missing something. Thanks, --DD -- Adrian Klaver adrian.kla...@aklaver.com

Re: Import csv to temp table

2024-01-02 Thread Adrian Klaver
. Best regards, -- Adrian Klaver adrian.kla...@aklaver.com

Re: Changing a schema's name with function1 calling function2

2023-12-30 Thread Adrian Klaver
ll therefore consider using a database change management system instead (e.g. sqitch, suggested by Adrian) and defining there what should happen when the schema name is changed, including the names of all functions whose search_path is to be changed. Many thanks again Wilma -- Adrian Klaver adrian.kla...@aklaver.com

Re: Need help

2023-12-30 Thread Adrian Klaver
have a mismatch between the file format of the dump file and the version of pg_restore you are using to attempt to restore that file. Until that gets sorted out you will not get any further. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Need help

2023-12-29 Thread Adrian Klaver
server I have taken backup*.** 5) Do you have more then one version of Postgres installed? *14.10 & 16.1 in server which I have taken backup* ** *From:*Adrian Klaver *Sent:* 30 December 2023 00:45 *To:* ankit.si...@nest-is2.com; pgsql-general@lists.postgresql.org *Subject:* Re: Need help

Re: Need help

2023-12-29 Thread Adrian Klaver
On 12/29/23 6:02 AM, ankit.si...@nest-is2.com wrote: In Ubuntu 22.04LTS when we try to restore the database it's giving the error – pg restore unsupported 1.15 Needs  a lot more information: 1) Postgres version being restored to. 2) The complete pg_restore command. 3) The complete error

Re: Increased storage size of jsonb in pg15

2023-12-29 Thread Adrian Klaver
he advisability of changing defaults without testing what that does to the end user or notifying the end user. On Fri, Dec 29, 2023 at 7:23 AM Tom Lane <mailto:t...@sss.pgh.pa.us>> wrote: Junwang Zhao mailto:zhjw...@gmail.com>> writes: > On Fri, Dec 29, 2023 at 4:4

Re: Increased storage size of jsonb in pg15

2023-12-28 Thread Adrian Klaver
go back to pglz. On Thu, Dec 28, 2023 at 11:23 AM Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 12/28/23 09:13, Sean Flaherty wrote: > Follow-up: > Working with AWS, we found that starting in RDS Postgres 15, the > default_toast_compressi

Re: Increased storage size of jsonb in pg15

2023-12-28 Thread Adrian Klaver
 on disk. I can confirm I see the same results using Postgres 16 installed from the PGDG repo on Ubuntu 22.04. That the lz4 data size is greater then the pglz data size. Kind regards, Sean -- Adrian Klaver adrian.kla...@aklaver.com

Re: Changing a schema's name with function1 calling function2

2023-12-27 Thread Adrian Klaver
On 12/26/23 22:41, Kirk Wolak wrote: On Mon, Dec 25, 2023 at 1:47 PM Christophe Pettus <mailto:x...@thebuild.com>> wrote: > On Dec 25, 2023, at 10:44, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: > Functions with same name in different sch

Re: looking for mariadb-devel to install mysql_fdw_16 in AlmaLinux 9

2023-12-26 Thread Adrian Klaver
How do I work around this? Mike Nolan htf...@gmail.com -- Adrian Klaver adrian.kla...@aklaver.com

Re: ERROR: missing chunk number 0 for toast value 1563962066 in pg_toast_2619

2023-12-26 Thread Adrian Klaver
https://www.postgresql.org/message-id/2184af82-8dbd-4c78-9cc1-29f7a577e2f1%40aklaver.com Thank you Johnathan Tiamoh -- Adrian Klaver adrian.kla...@aklaver.com

Re: Query crash with 15.5 on debian bookworm/armv8

2023-12-25 Thread Adrian Klaver
i.com/software/operating-systems/ -- Adrian Klaver adrian.kla...@aklaver.com

Re: Query crash with 15.5 on debian bookworm/armv8

2023-12-25 Thread Adrian Klaver
& plsql -f. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Query crash with 15.5 on debian bookworm/armv8

2023-12-25 Thread Adrian Klaver
On 12/25/23 13:01, Clemens Eisserer wrote: Hi, I've just updated my raspberry pi 3 from postgresql-13.3 on bullseye/armv6 to postgresq-15.5 on debian-bookworm/armv8. How did you upgrade? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Changing a schema's name with function1 calling function2

2023-12-25 Thread Adrian Klaver
; Issues: fnc_name would need to kept updated. Overloaded function names would need to be accounted for. Functions with same name in different schemas would need to be dealt with. At this point I still the solution as being external to the database. In other words making the change before the objects are loaded into a database. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Changing a schema's name with function1 calling function2

2023-12-24 Thread Adrian Klaver
On 12/24/23 13:43, Peter J. Holzer wrote: On 2023-12-23 08:31:39 -0800, Adrian Klaver wrote: I think you misunderstood Wilma. What she is asking for is a "keyword" or "magic variable" (or whatever you want to call it) which you can specify in CREATE|ALTER FUNCTION

Re: Unable to start postgresql-14

2023-12-24 Thread Adrian Klaver
from the backup Do you mean you did a pg_dumpall from the Postgres instance running on the restored data directory? Yes. And it failed -- Adrian Klaver adrian.kla...@aklaver.com

Re: Unable to start postgresql-14

2023-12-23 Thread Adrian Klaver
o you mean you did a pg_dumpall from the Postgres instance running on the restored data directory? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Unable to start postgresql-14

2023-12-23 Thread Adrian Klaver
satisfied --- flushed only to 4392/F58 More information needed: 1) Exact Postgres version e.g 14.x 2) Is it community version or fork? 3) What was the command you used to start the cluster? 4) Do you have replication/WAL archiving set up? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Changing a schema's name with function1 calling function2

2023-12-23 Thread Adrian Klaver
r the reference to sqitch, I'll have a look at that now. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Changing a schema's name with function1 calling function2

2023-12-22 Thread Adrian Klaver
See SET and Chapter 20 for more information about allowed parameter names and values. " The alternative is to create a migration process using scripts with variable substitution outside the database. I do something similar using Sqitch(https://sqitch.org/) and its template system: https://sqitch.org/docs/manual/sqitch-add/ -- Adrian Klaver adrian.kla...@aklaver.com

Re: Changing a schema's name with function1 calling function2

2023-12-21 Thread Adrian Klaver
main_schema'; ALTER FUNCTION function SET search_path FROM CURRENT; Your E-Mail. Your Cloud. Your Office. eclipso Mail & Cloud. https://www.eclipso.de -- Adrian Klaver adrian.kla...@aklaver.com

Re: Help understanding server-side logging (and more...)

2023-12-21 Thread Adrian Klaver
greatly appreciated. 1) It would be helpful to add the Postgres version to any future posts. 2) Also more information on what this "They run PostgreSQL in a Linux container" means? Thanks, --DD -- Adrian Klaver adrian.kla...@aklaver.com

Re: Postgresql 15 client arm64 and Qt 5.15

2023-12-17 Thread Adrian Klaver
hared libraries. If I where to hazard a guess: /home/pier/Android/Sdk/ndk/ ... regards, tom lane -- Adrian Klaver adrian.kla...@aklaver.com

Re: Increased storage size of jsonb in pg15

2023-12-15 Thread Adrian Klaver
were seeing locally) RDS Postgres-15.4 2112 Thank you for your prompt responses and assistance. If you are curious, I can share the script we used with you. Kind regards, Sean -- Adrian Klaver adrian.kla...@aklaver.com

Re: Increased storage size of jsonb in pg15

2023-12-14 Thread Adrian Klaver
as increased in size. None of the upload process changed during the underlying database upgrade. On Wed, Dec 13, 2023 at 4:56 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 12/13/23 15:49, Sean Flaherty wrote: > More information needed: > &

Re: Increased storage size of jsonb in pg15

2023-12-13 Thread Adrian Klaver
23 8 21768 8 datafile.dat2023-10-19 22:00:00 23 8 20538 8 datafile.dat2023-10-19 23:00:00 23 8 20438 8 -- Adrian Klaver adrian.kla...@aklaver.com

Re: Increased storage size of jsonb in pg15

2023-12-13 Thread Adrian Klaver
was done? I can't find any information online, is anyone aware of what would cause this change in storage size for essentially the same data? Kind regards, Sean -- Adrian Klaver adrian.kla...@aklaver.com

Re: how can I fix my accent issues?

2023-12-13 Thread Adrian Klaver
the dev database into a staging table. Then have a form that the reviewer can use to correct the data, after which it can be moved into the final table. This cuts out an OS transfer. � REPLACEMENT CHARACTER. best regards -- Adrian Klaver adrian.kla...@aklaver.com

Re: how can I fix my accent issues?

2023-12-12 Thread Adrian Klaver
never fails Define what you mean by whole operation done in Windows. Thank you all -- Adrian Klaver adrian.kla...@aklaver.com

Re: how can I fix my accent issues?

2023-12-12 Thread Adrian Klaver
the route the data is taking to get to the database. Thank you El mar., 12 de diciembre de 2023 6:04 p. m., Adrian Klaver mailto:adrian.kla...@aklaver.com>> escribió: On 12/12/23 12:44, Igniris Valdivia Baez wrote: > this is the result I got, now I have to figure it out

Re: how can I fix my accent issues?

2023-12-12 Thread Adrian Klaver
t a typo), you should set the client encoding to WIN1252, so that PostgreSQL knows how to convert the data correctly. You can do that in several ways; the simplest might be to set the environment variable PGCLIENTENCODING to WIN1252. Yours, Laurenz Albe -- Adrian Klaver adrian.kla...@aklaver.com

Re: how can I fix my accent issues?

2023-12-12 Thread Adrian Klaver
On 12/12/23 12:44, Igniris Valdivia Baez wrote: this is the result I got, now I have to figure it out how to solve it, thank you so much In what client are you viewing the data? -- Adrian Klaver adrian.kla...@aklaver.com

Re: how can I fix my accent issues?

2023-12-11 Thread Adrian Klaver
On 12/11/23 10:54 AM, Igniris Valdivia Baez wrote: hello to all, thanks for your answers i've changed the encoding using this: ALTER DATABASE testdb SET client_encoding = WIN1252; now when we try to select data from a table we get this error: ERROR: character with byte sequence 0xe2 0x80 0x8b

Re: [EXT]Re: running \copy through perl dbi ?

2023-12-10 Thread Adrian Klaver
used in psql. -- Bruce Johnson University of Arizona College of Pharmacy Information Technology Group Institutions do not have opinions, merely customs -- Adrian Klaver adrian.kla...@aklaver.com

Re: how can I fix my accent issues?

2023-12-09 Thread Adrian Klaver
ncoding options in the Pentaho connection dialog. El sáb, 9 dic 2023 a las 10:50, Adrian Klaver () escribió: On 12/9/23 07:41, Igniris Valdivia Baez wrote: hello, thank you for answering, it's not a typo, in the attachments you can see that this is actually my collation, algo a pic of

Re: how can I fix my accent issues?

2023-12-09 Thread Adrian Klaver
that PostgreSQL knows how to convert the data correctly. You can do that in several ways; the simplest might be to set the environment variable PGCLIENTENCODING to WIN1252. Yours, Laurenz Albe -- Adrian Klaver adrian.kla...@aklaver.com

Re: running \copy through perl dbi ?

2023-12-08 Thread Adrian Klaver
ith a command line approach, attaching to the DB  then run using... -c "\copy ...".  But I was wondering if there is a more elegant way to do this, maybe some sort of legal SQL command that Perl/DBI would swallow ??? Per David Johnston post: https://metacpan.org/pod/DBD::Pg#COPY-sup

Re: Trainning and Certification

2023-12-06 Thread Adrian Klaver
ql.org/message-id/CAJKUy5jy5fzrWZ9MuYkNWC73APX0F6rV-OrCXPuBQE7mOczxWQ%40mail.gmail.com This covers what is out there and why it is highly unlikely there will be a Postgres community(core) certification. Regards -- Adrian Klaver adrian.kla...@aklaver.com

Re: Delete Account

2023-12-06 Thread Adrian Klaver
/policies/archives/ The short version is the emails will not be removed. -- Adrian Klaver adrian.kla...@aklaver.com

Re: PostgreSQL 12 error unrecognized configuration parameter zbx_tmp.wal_json_res

2023-12-06 Thread Adrian Klaver
to confer those privileges to unprivileged user for the duration of the function execution per: https://www.postgresql.org/docs/12/sql-createfunction.html Please advise. Best regards, Arne H. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Delete Account

2023-12-06 Thread Adrian Klaver
account/ or to your subscription to this mailing list? What data are you referring to? Thanks -- Adrian Klaver adrian.kla...@aklaver.com

Re: Query related to pg_dump write to a pipe on a windows client and with compressed format

2023-12-01 Thread Adrian Klaver
rds, Meera -- Adrian Klaver adrian.kla...@aklaver.com

Re: Two started cluster on the same data directory and port

2023-12-01 Thread Adrian Klaver
erver Thank you very much Adrian... I'm going to get a cup of coffee because the topic requires it :D El vie, 1 dic 2023 a las 6:19, Adrian Klaver (<mailto:adrian.kla...@aklaver.com>>) escribió: On 11/30/23 20:43, Matthias Apitz wrote: > El día jueves, noviembre 30, 2

Re: Two started cluster on the same data directory and port

2023-11-30 Thread Adrian Klaver
On 11/30/23 20:43, Matthias Apitz wrote: El día jueves, noviembre 30, 2023 a las 02:10:25p. m. -0800, Adrian Klaver escribió: On 11/30/23 12:35, Adrian Klaver wrote: On 11/30/23 10:35, Adrian Klaver wrote: On 11/30/23 09:27, Loles wrote: cd /etc/postgresql/14/ sudo rm -r main_old

Re: Two started cluster on the same data directory and port

2023-11-30 Thread Adrian Klaver
On 11/30/23 12:35, Adrian Klaver wrote: On 11/30/23 10:35, Adrian Klaver wrote: On 11/30/23 09:27, Loles wrote: cd /etc/postgresql/14/ sudo rm -r main_old/   or sudo cp -r main_old Arrgh. sudo mv -r main_old Memo to self don't eat lunch and copy/paste at same time. -- A

Re: Two started cluster on the same data directory and port

2023-11-30 Thread Adrian Klaver
On 11/30/23 10:35, Adrian Klaver wrote: On 11/30/23 09:27, Loles wrote: root@hostname:~# pg_lsclusters Ver Cluster  Port Status Owner    Data directory              Log file *14  main     5432 online* postgres /var/lib/postgresql/14/main /var/log/postgresql/postgresql-14-main.log *14

Re: Two started cluster on the same data directory and port

2023-11-30 Thread Adrian Klaver
/main_old/ directory somewhere else and then restart Postgres? Adrian Klaver adrian.kla...@aklaver.com

Re: Two started cluster on the same data directory and port

2023-11-30 Thread Adrian Klaver
. Stop the server(s) and then: sudo pg_ctlcluster starp 14 main El jue, 30 nov 2023 a las 17:43, Adrian Klaver (mailto:adrian.kla...@aklaver.com>>) escribió: On 11/30/23 08:37, Loles wrote: > Every time I stop the main_old cluster with sudo pg_ctlcluster

Re: Two started cluster on the same data directory and port

2023-11-30 Thread Adrian Klaver
port. I can't change the port because it is the same postgresql.conf I don't know how to disassociate the main_old cluster from the data directory or how to resolve this situation. El jue, 30 nov 2023 a las 16:32, Adrian Klaver (mailto:adrian.kla...@aklaver.com>

Re: Two started cluster on the same data directory and port

2023-11-30 Thread Adrian Klaver
now how to disassociate the main_old cluster from the data directory or how to resolve this situation. El jue, 30 nov 2023 a las 16:32, Adrian Klaver (mailto:adrian.kla...@aklaver.com>>) escribió: On 11/30/23 07:23, Adrian Klaver wrote: > On 11/30/23 05:37, Loles wrote: >&

Re: libpq crashing on macOS during connection startup

2023-11-30 Thread Adrian Klaver
On 11/30/23 07:49, John DeSoi wrote: On Nov 30, 2023, at 9:36 AM, Adrian Klaver wrote: What starts happening? Random web process crashes when connecting to PostgreSQL. Does the Postgres log show anything? No. To be clear, at the times the Web processes crash there is are no traces

Re: libpq crashing on macOS during connection startup

2023-11-30 Thread Adrian Klaver
suggestions appreciated. John DeSoi, Ph.D. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Two started cluster on the same data directory and port

2023-11-30 Thread Adrian Klaver
On 11/30/23 07:23, Adrian Klaver wrote: On 11/30/23 05:37, Loles wrote: Hi! I have this situation on a server that is giving me problems. postgres@hostname:~$ pg_lsclusters Ver Cluster  Port Status Owner    Data directory              Log file 14  main     5432 online postgres /var/lib

Re: Two started cluster on the same data directory and port

2023-11-30 Thread Adrian Klaver
hanks! -- Adrian Klaver adrian.kla...@aklaver.com

Re: Understanding partial index selection

2023-11-28 Thread Adrian Klaver
;ll take what I can get. Hopefully, some of this will carry over. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Off-label use for pg_repack

2023-11-28 Thread Adrian Klaver
ut if insert/update/delete seems to be working? My insert/update/deletes on the tables while pg_repack is running seem to work fine. I also tried this on tables that have toast tables attached and upon first glance, everything seems to be in order. What have I missed? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Installing extension temporal_tables for PG13

2023-11-27 Thread Adrian Klaver
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/27/23 17:17, H wrote: I don't use PGXN so I am flying blind here. You may need to do: sudo pgxn in

Re: Installing extension temporal_tables for PG13

2023-11-27 Thread Adrian Klaver
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 that the file pgxs.mk does not exist? In fact, I can see that /usr/pgsql-13/lib/pgxs directory does not exist

Re: Installing extension temporal_tables for PG13

2023-11-27 Thread Adrian Klaver
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 non-functioning website: pgxnclient.projects.pgfoundry.org. Does anyone if the pgxn client can be found somewhere else?

Re: IPV6 issue

2023-11-27 Thread Adrian Klaver
dirty way to see what you are using: whereis psql To find all the versions: sudo find / -name psql Regards. On Tue, Nov 28, 2023 at 6:26 AM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 11/27/23 16:42, Atul Kumar wrote: > Hi, > >

Re: IPV6 issue

2023-11-27 Thread Adrian Klaver
answer to the second question. Regards. On Tue, Nov 28, 2023 at 2:11 AM Tom Lane <mailto:t...@sss.pgh.pa.us>> wrote: Adrian Klaver mailto:adrian.kla...@aklaver.com>> writes: > On 11/27/23 12:11, Atul Kumar wrote: >> I found that localhost was set to

Re: Installing extension temporal_tables for PG13

2023-11-27 Thread Adrian Klaver
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 somewhere else? Or: https://pgxn.github.io/pgxnclient/ -- Adrian Klaver adria

Re: Installing extension temporal_tables for PG13

2023-11-27 Thread Adrian Klaver
On 11/27/23 16:18, H wrote: On November 27, 2023 6:58:40 PM GMT-05:00, Adrian Klaver 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 somewhere else?

Re: Installing extension temporal_tables for PG13

2023-11-27 Thread Adrian Klaver
github.com/arkhipov/temporal_tables Am I correct in that I need to either find the client pgxn alternatively install the development environment and compile the source code for this extension? Yes. Thank you. -- Adrian Klaver adrian.kla...@aklaver.com

Re: suppress notices from inside a stored a plpgqsl function

2023-11-27 Thread Adrian Klaver
lient_min_messages to something above NOTICE in the function. Or as part of the function creation: https://www.postgresql.org/docs/current/sql-createfunction.html SET configuration_parameter { TO value | = value | FROM CURRENT } -- Adrian Klaver adrian.kla...@aklaver.com

Re: IPV6 issue

2023-11-27 Thread Adrian Klaver
es port = 5432 and what is listen_addresses set to? How did you install Postgres? Do you have more then one version of psql installed? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Could not read from file "pg_subtrans/00F5" at offset 122880: Success.

2023-11-27 Thread Adrian Klaver
esql-dsources/provisioning-a-postgresql-vdb there seems to be a lot of moving parts to using Delphix VDB with a Postgres database. You are going to need to provide more information about your setup. Thanks, Sri Attili -- Adrian Klaver adrian.kla...@aklaver.com

Re: Emitting JSON to file using COPY TO

2023-11-27 Thread Adrian Klaver
#x27;s even a JSON mode. Where are you seeing the JSON mode for COPY? AFAIK there is only text and CSV formats. By miracle, would the JSON output mode recognize JSON[B] values, and avoid the escaping? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Emitting JSON to file using COPY TO

2023-11-25 Thread Adrian Klaver
to COPY TO would work well for this JSON use case. Not using COPY. See David Johnson's post for one way using the client psql. Otherwise you will need to use any of the many ETL programs out there that are designed for this sort of thing. Any assistance would be appreciated. Thanks, Davin -- Adrian Klaver adrian.kla...@aklaver.com

Re: replication primary writting infinite number of WAL files

2023-11-24 Thread Adrian Klaver
ad into a something more coherent. In particular a time line of the whole cloning/replication process.    Laszlo -- Adrian Klaver adrian.kla...@aklaver.com

Re: replication primary writting infinite number of WAL files

2023-11-24 Thread Adrian Klaver
On 11/24/23 1:05 PM, Les wrote: >> Sequence is incremented by 100,  so for example, between 2023-11-24 >> 10:20:00 and 2023-11-24 10:21:00 it went up 62188671 steps. I think it >> is not possible to insert 62188671 rows into a table. A psql function >> might be able

Re: pg_getnameinfo_all() failed: Temporary failure in name resolution

2023-11-24 Thread Adrian Klaver
be filled with something even on failure return. */ -- Adrian Klaver adrian.kla...@aklaver.com

Re: replication primary writting infinite number of WAL files

2023-11-24 Thread Adrian Klaver
On 11/24/23 09:51, Adrian Klaver wrote: On 11/24/23 09:32, Les wrote: Please Reply All to include list Ccing list to get information back there. Adrian Klaver <mailto:adrian.kla...@aklaver.com>> (2023. nov. 24., P, 17:50):     On 11/24/23 03:39, Les wrote: > The only ex

Re: replication primary writting infinite number of WAL files

2023-11-24 Thread Adrian Klaver
On 11/24/23 09:32, Les wrote: Please Reply All to include list Ccing list to get information back there. Adrian Klaver <mailto:adrian.kla...@aklaver.com>> (2023. nov. 24., P, 17:50): On 11/24/23 03:39, Les wrote: > The only exception is a sequence > value

Re: Inquiry Regarding Initial Seed for pgsql Protocol Fuzz Testing

2023-11-24 Thread Adrian Klaver
protocol. I've successfully replicated SGFuzz's fuzz testing on the OpenSSL protocol. -- Adrian Klaver adrian.kla...@aklaver.com

Re: replication primary writting infinite number of WAL files

2023-11-24 Thread Adrian Klaver
wal_keep_size. Thus, failure of a replication consumer could lead to indefinitely-large catalog bloat. You are using repmgr which as I understand it uses streaming not logical replication. Thank you,    Laszlo -- Adrian Klaver adrian.kla...@aklaver.com

Re: Inquiry Regarding Initial Seed for pgsql Protocol Fuzz Testing

2023-11-23 Thread Adrian Klaver
currently using them would help those that also do this to guide you. Adrian Klaver <mailto:adrian.kla...@aklaver.com>> 于2023年11月23日周四 23:54写道: On 11/22/23 22:56, Cherry Pang wrote: > hello! > I am a novice enthusiast in the field of fuzz testing and have an

Re: IPV6 issue

2023-11-23 Thread Adrian Klaver
why is my first machine is throwing this error ? Change this 127.0.0.1/32 to localhost and then be covered for both situations. Please help. Regards. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Odd Shortcut behaviour in PG14

2023-11-23 Thread Adrian Klaver
hy this would be the case? *Zahir Lalani** *Director of Enterprise Systems -- Adrian Klaver adrian.kla...@aklaver.com

<    1   2   3   4   5   6   7   8   9   10   >