Re: re-novice coming back to pgsql: porting an SQLite update statement to postgres

2024-07-24 Thread Adrian Klaver
-datetime.html For JSON types : https://www.postgresql.org/docs/current/datatype-json.html Thanks, I will work through those. On Tue, 2024-07-23 at 23:52 +0200, Dominique Devienne wrote: On Tue, Jul 23, 2024 at 10:35 PM Adrian Klaver wrote: Just know that SQLite does not enforce types [...] That's

Re: re-novice coming back to pgsql: porting an SQLite update statement to postgres

2024-07-23 Thread Adrian Klaver
e, all you have to do is read those, and try to port; if it fails, read them again. Also search the archives of the pgsql-general list, many answers in there -- Adrian Klaver adrian.kla...@aklaver.com

Re: Windows installation problem at post-install step

2024-07-22 Thread Adrian Klaver
On 7/22/24 13:34, Ertan Küçükoglu wrote: Adrian Klaver <mailto:adrian.kla...@aklaver.com>>, 22 Tem 2024 Pzt, 23:18 tarihinde şunu yazdı: It would seem to me the process would be: 1) Create Windows VM 2) Run the localizer tool in the VM to get the old locale name in plac

Re: Windows installation problem at post-install step

2024-07-22 Thread Adrian Klaver
On 7/22/24 13:15, Ertan Küçükoglu wrote: Adrian Klaver <mailto:adrian.kla...@aklaver.com>>, 22 Tem 2024 Pzt, 22:56 tarihinde şunu yazdı: Why not use that? There was already an installed PostgreSQL just failing to start. I used that localization tool and it star

Re: Windows installation problem at post-install step

2024-07-22 Thread Adrian Klaver
On 7/22/24 11:48, Ertan Küçükoglu wrote: Adrian Klaver <mailto:adrian.kla...@aklaver.com>>, 22 Tem 2024 Pzt, 21:10 tarihinde şunu yazdı: I am getting out of my depth here, but I am pretty sure that: ENCODING = 'UTF8' LOCALE_PROVIDER = libc LOCALE = 'Turkish_Tu

Re: Windows installation problem at post-install step

2024-07-22 Thread Adrian Klaver
On 7/22/24 10:51 AM, Ertan Küçükoglu wrote: Adrian Klaver <mailto:adrian.kla...@aklaver.com>>, 22 Tem 2024 Pzt, 20:37 tarihinde şunu yazdı: What is the command you use to restore the pg_dumpall file? within psql I run \i template1 should not be dropped in the pg_dum

Re: Unsuscribe

2024-07-22 Thread Adrian Klaver
On 7/22/24 10:45 AM, Dunia Ramazani wrote: Unsuscribe Follow instructions here: https://lists.postgresql.org/unsubscribe/ -- Adrian Klaver adrian.kla...@aklaver.com

Re: Windows installation problem at post-install step

2024-07-22 Thread Adrian Klaver
On 7/22/24 10:09 AM, Ertan Küçükoglu wrote: Adrian Klaver <mailto:adrian.kla...@aklaver.com>>, 22 Tem 2024 Pzt, 20:04 tarihinde şunu yazdı: When you connect using psql do you see template0, template1 and postgres when you do \l? Yes post

Re: Windows installation problem at post-install step

2024-07-22 Thread Adrian Klaver
On 7/22/24 09:51, Ertan Küçükoglu wrote: Adrian Klaver <mailto:adrian.kla...@aklaver.com>>, 22 Tem 2024 Pzt, 17:49 tarihinde şunu yazdı: Provide the following info: 1) Linux distro and version. 2) How did you install Postgres? 3) Versions of Postgres that was du

Re: Fwd: lost master password

2024-07-22 Thread Adrian Klaver
> > how you can help me with lost super password? > > > > Are you talking about a PostgreSQL superuser password or > > about the "master password" that the pgAdmin client uses > > to encrypt connection information? Only if you answer my qustion. Yours, Laurenz Albe -- Adrian Klaver adrian.kla...@aklaver.com

Re: Windows installation problem at post-install step

2024-07-22 Thread Adrian Klaver
On 7/22/24 03:10, Ertan Küçükoglu wrote: Adrian Klaver <mailto:adrian.kla...@aklaver.com>>, 21 Tem 2024 Paz, 22:29 tarihinde şunu yazdı: If the backup was done using pg_dump it should work. If you are talking about a file level backup then it would not work. Backup fil

Re: Windows installation problem at post-install step

2024-07-21 Thread Adrian Klaver
On 7/21/24 12:00, Ertan Küçükoglu wrote: Adrian Klaver <mailto:adrian.kla...@aklaver.com>>, 21 Tem 2024 Paz, 21:48 tarihinde şunu yazdı: I don't know enough about Windows locales and the EDB installer to be of further help in that direction. Is it feasible to instal

Re: Windows installation problem at post-install step

2024-07-21 Thread Adrian Klaver
On 7/21/24 10:52, Ertan Küçükoglu wrote: Adrian Klaver <mailto:adrian.kla...@aklaver.com>>, 21 Tem 2024 Paz, 20:34 tarihinde şunu yazdı: What happens if you set the VM to Türkiye and install? Problem still exists even if I set everything to Türkiye and Turkish. 1- I tried to

Re: Windows installation problem at post-install step

2024-07-21 Thread Adrian Klaver
On 7/21/24 10:21, Ertan Küçükoglu wrote: Adrian Klaver <mailto:adrian.kla...@aklaver.com>>, 21 Tem 2024 Paz, 20:04 tarihinde şunu yazdı: On 7/21/24 09:16, Ertan Küçükoglu wrote: > Hello, > > I am trying to install posgreql-16.3-2-windows-x64.exe on Windows

Re: Windows installation problem at post-install step

2024-07-21 Thread Adrian Klaver
know how I can manually fix this. I tried to reach techsupp...@enterprisedb.com <mailto:techsupp...@enterprisedb.com> but got no response for almost two weeks now. Any help would be appreciated. Thanks & Regards, Ertan -- Adrian Klaver adrian.kla...@aklaver.com

Re: Searching for libpq5-13 and libpq5-devel-13 for CentOS/RHEL 7

2024-07-17 Thread Adrian Klaver
-x86_64/repoview/postgresql13-libs.html And here?: https://yum.postgresql.org/13/redhat/rhel-7-x86_64/repoview/postgresql13-devel.html Thanks. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Support of Postgresql 14 for Sles15Sp6

2024-07-17 Thread Adrian Klaver
e help me with this. Regards, Akram. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Planet Postgres and the curse of AI

2024-07-17 Thread Adrian Klaver
to embellish and make things up(ask the NYC lawyer suing the airlines about that), though that is a human trait as well. Cheers, Greg -- Adrian Klaver adrian.kla...@aklaver.com

Re: Support of Postgresql 15 for Sles15Sp6

2024-07-17 Thread Adrian Klaver
. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Code does Not Read in FY 2025 Data

2024-07-16 Thread Adrian Klaver
nt data that has dates > 2024-07-16. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Code does Not Read in FY 2025 Data

2024-07-16 Thread Adrian Klaver
xDate AS ( SELECT MAX("Date") AS "MaxDate" FROM FullWeeks WHERE "Date" < CURRENT_DATE ) I don't see how you expect to fetch data from the future when you limit the data to the past. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Code does Not Read in FY 2025 Data

2024-07-16 Thread Adrian Klaver
ot; = 7 ), -- Step 4: Get the maximum date from full weeks that is before today MaxDate AS (     SELECT         MAX("Date") AS "MaxDate"     FROM         FullWeeks     WHERE         "Date" < CURRENT_DATE ) -- Step 5: Select the maximum date SELECT     "Ma

Re: Code does Not Read in FY 2025 Data

2024-07-16 Thread Adrian Klaver
WEEK_NUMBER is the alias for the sub-select that filtered on: "FY" IS NOT NULL AND "FY" >= 'FY24' So even if the sub-select found values in the future you filter them out with < CURRENT_DATE -- Adrian Klaver adrian.kla...@aklaver.com

Re: Code does Not Read in FY 2025 Data

2024-07-16 Thread Adrian Klaver
4 at 16:45, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 7/16/24 05:53, Anthony Apollis wrote: >  1. The problem is the code below reads only data up until 2024, >     although the table has been updated with latest data that contains > 

Re: Code does Not Read in FY 2025 Data

2024-07-16 Thread Adrian Klaver
"             FROM (                 SELECT DISTINCT                     "Date",                     EXTRACT(WEEK FROM WEEK_NUMBER."Date") AS "Week number"                 FROM                     "dbo"."IMETA_Calendar_Days_Data_Table_Copy10" AS WEEK_NUMBER             ) AS W_MAX         ) AS WEEK_NUMBER         WHERE             WEEK_NUMBER."Date" < CURRENT_DATE     ) AS WEEK_NUMBER ON     WM_GH."Calendar day" = WEEK_NUMBER."Date" ORDER BY     WM_GH."Calendar day" DESC; -- Adrian Klaver adrian.kla...@aklaver.com

Re: How does this FK constraint error happen?

2024-07-15 Thread Adrian Klaver
really changes anything? -- Adrian Klaver adrian.kla...@aklaver.com

Re: How does this FK constraint error happen?

2024-07-15 Thread Adrian Klaver
On 7/15/24 09:21, Ron Johnson wrote: On Mon, Jul 15, 2024 at 11:37 AM Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: I don't think it is entirely coincidental that 1210 is the only shown user_id with a modified_on value that is in proximity to the delete erro

Re: How does this FK constraint error happen?

2024-07-15 Thread Adrian Klaver
On 7/15/24 08:18, Ron Johnson wrote: On Mon, Jul 15, 2024 at 11:06 AM Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 7/15/24 07:53, Ron Johnson wrote: > On Mon, Jul 15, 2024 at 10:35 AM Peter J. Holzer > TAPd=# select * from rel_group_user >

Re: How does this FK constraint error happen?

2024-07-15 Thread Adrian Klaver
    1210 | JORIEUSER3 | 2023-10-20 11:54:24.562 | 2024-07-15 02:42:09.355 (1 row) -- Adrian Klaver adrian.kla...@aklaver.com

Re: Running psql in a docker container

2024-07-11 Thread Adrian Klaver
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 container with CentOS 7 as the host operating system. I have now upgraded that system to Rocky Linux 9

Re: Running psql in a docker container

2024-07-11 Thread Adrian Klaver
.. no success' means there is no real way to answer this. Any suggestions on what I have missed? Thank you. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Dropping column from big table

2024-07-10 Thread Adrian Klaver
sults in reconstructing each row with the dropped column replaced by a null value. " -- Adrian Klaver adrian.kla...@aklaver.com

Re: Finding error in long input file

2024-07-10 Thread Adrian Klaver
On 7/10/24 05:30, Rich Shepard wrote: On Tue, 9 Jul 2024, Adrian Klaver wrote: The error: LINE 488: ...2832,1,default,'85250 Red House Rd','Paisley','OR','97636') is giving you the line number and the data: a) Navigate to that line number using whatever method Joe has for that. b) Search

Re: Finding error in long input file

2024-07-09 Thread Adrian Klaver
ine, but '85250 Red House Rd' doesn't seem like the issue.  I don't know anything about the joe editor, but I'd hope that any decent editor with syntax highlighting would make it apparent where things went awry. Craig -- Adrian Klaver adrian.kla...@aklaver.com

Re: Finding error in long input file

2024-07-09 Thread Adrian Klaver
On 7/9/24 15:40, Rich Shepard wrote: On Tue, 9 Jul 2024, Adrian Klaver wrote: bustrac=#\e scripts/insert-addrs.sql 488 If that raises this error: environment variable PSQL_EDITOR_LINENUMBER_ARG must be set to specify a line number Adrian, It doesn't; it prints the contents of the file

Re: Finding error in long input file

2024-07-09 Thread Adrian Klaver
ine number then: bustrac=#\e scripts/insert-addrs.sql If the editor is vi then: :488 TIA, Rich -- Adrian Klaver adrian.kla...@aklaver.com

Re: Load a csv or a avro?

2024-07-07 Thread Adrian Klaver
On 7/6/24 13:09, sud wrote: On Fri, Jul 5, 2024 at 8:24 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 7/5/24 02:08, sud wrote: > Hello all, > > Its postgres database. We have option of getting files in csv and/or in > avro

Re: Declaring a field that is also an out parameter in a function

2024-07-07 Thread Adrian Klaver
On 7/7/24 07:53, Pavel Stehule wrote: ne 7. 7. 2024 v 16:48 odesílatel Adrian Klaver mailto:adrian.kla...@aklaver.com>> napsal: On 7/7/24 07:42, Pavel Stehule wrote: >     I'm not sure why there's a warning about using an alias. 43.3.1 says >     to use them

Re: Declaring a field that is also an out parameter in a function

2024-07-07 Thread Adrian Klaver
they where declared and never used? I  don't know any good reason why one variable can use more than one name. Section 43.3.2. ALIAS provides the pros/cons. There can be an exception when argument names are very long, but generally they are not used. Mike Nolan -- Adrian Klaver

Re: Load a csv or a avro?

2024-07-05 Thread Adrian Klaver
contents of each file or are you pulling a portion of the data out? My question was, which format should we chose in regards to faster data loading performance ? and if any other aspects to it also should be considered apart from just loading performance? -- Adrian Klaver adrian.kla

Re: psql help

2024-07-04 Thread Adrian Klaver
) will not work as it expects only one pid at a time. So, the question is how to rewrite this psql so it loops through all pids one pid at a time? Thanks in advance for your help. From here: https://www.postgresql.org/docs/current/app-psql.html See: \gexec -- Adrian Klaver adrian.kla...@aklaver.com

Re: Configure autovacuum

2024-07-04 Thread Adrian Klaver
record with a predefined payload (i.e. random bytearray of x MB) for x minutes. We update up to 60MB per second Do you do this all in one transaction? 4) Postgres Version: 14.12-2 5) We are using default autovacuum-settings Best regards, Manuel -Original Message- From: Adrian Klaver

Re: Configure autovacuum

2024-07-04 Thread Adrian Klaver
Message- From: Adrian Klaver Sent: 14 June 2024 16:32 To: Shenavai, Manuel ; pgsql-general Subject: Re: Configure autovacuum On 6/13/24 23:20, Shenavai, Manuel wrote: Hi everyone, I would like to configure the autovacuum in a way that it runs very frequently (i.e. after each update-statement). I

Re: Accommodating alternative column values

2024-07-03 Thread Adrian Klaver
[] using array[email]; select * from array_conv ; id |email +- 1 | {adrian.kla...@aklaver.com} 2 | {akla...@example.com} Rich -- Adrian Klaver adrian.kla...@aklaver.com

Re: Alignment check

2024-06-27 Thread Adrian Klaver
On 6/27/24 10:26, Marthin Laubscher wrote: On 2024/06/27, 19:04, "Adrian Klaver" mailto:adrian.kla...@aklaver.com>> wrote: And substituted a single platform dependence. Even bare metal can lock you in without some abstraction layer between your code and the har

Re: dblink Future support vs FDW

2024-06-27 Thread Adrian Klaver
upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Alignment check

2024-06-27 Thread Adrian Klaver
for your time – Marthin Laubscher -- Adrian Klaver adrian.kla...@aklaver.com

Re: [External] Dropping connections

2024-06-26 Thread Adrian Klaver
us password for some monitoring program or potentially someone trying to hack the database. 3) In your original post you said the issue pops up when you are remotely accessing the Postgres server via ArcgisPro 3.3.0. a) Where is that remote machine located. b) OS and version of the machine. -- Adri

Re: Dropping connections

2024-06-26 Thread Adrian Klaver
nd*" and Windows my first thought is Windows Anti-Virus program hitting the Postgres server. Is there an AV program running on the Windows Server 2022 server? It would also be helpful to get the Postgres log entries immediately prior to lines you show above. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Autovacuum, dead tuples and bloat

2024-06-26 Thread Adrian Klaver
f you want to go more in depth there is: https://www.postgresql.org/docs/current/pgstatstatements.html It is an extension that you will need to install per instructions at the link. Is there something like this already available in postgres? Best regards, Manuel -- Adrian Klaver

Re: PostgreSQL Community Enquire !

2024-06-25 Thread Adrian Klaver
fic platform. Just ask the question. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Postgresql python in upgraded version 16.2

2024-06-25 Thread Adrian Klaver
ql.org/contact/ and use the Issue Tracker link. You will need to set up a Postgres community account to access the tracker. Clicking on the link will guide you through the process. Michal -- Adrian Klaver adrian.kla...@aklaver.com

Re: schema privileges and drop role

2024-06-24 Thread Adrian Klaver
and DROP OWNED commands can be useful for this purpose; see Section 22.4 for more discussion." Does anyone have any hints or advice on where to look? Thanks for the help! -m -- Adrian Klaver adrian.kla...@aklaver.com

Re: PostgreSQL Community Enquire !

2024-06-24 Thread Adrian Klaver
have a more specific need within Postgres you could ask on the mailing lists here: https://www.postgresql.org/list/ that deal with that need. Best regards, Shiv -- Adrian Klaver adrian.kla...@aklaver.com

Re: Execute permission to function

2024-06-24 Thread Adrian Klaver
s https://www.postgresql.org/docs/14/sql-grant.html <https://www.postgresql.org/docs/14/sql-grant.html> and not able to script out objects from pg_admin What error message(s)? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Execute permission to function

2024-06-24 Thread Adrian Klaver
/Appendix.PostgreSQL.CommonDBATasks.Roles.html#Appendix.PostgreSQL.CommonDBATasks.Access Thanks, Arun -- Adrian Klaver adrian.kla...@aklaver.com

Re: Issue with pgstattuple on Sequences in PostgreSQL

2024-06-24 Thread Adrian Klaver
rib/pgstattuple/pgstattuple.c#L326-L329 <https://github.com/postgres/postgres/blob/master/contrib/pgstattuple/pgstattuple.c#L326-L329> How can one use pgstattuple on sequences? Regards, Ayush Vatsa -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to use createdb command with newly created user?

2024-06-23 Thread Adrian Klaver
-lexical.html#SQL-SYNTAX-IDENTIFIERS It will answer a lot of questions. -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_dump restores as expected on some machines and reports duplicate keys on others

2024-06-22 Thread Adrian Klaver
e. Why should the use of one type of VM image versus another cause pg_restore to hallucinate the duplicate records? 1) Show the complete pg_restore script. 2) The first issue is related to trying to create a database that already exists. Does that database have data in it? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Autovacuum, dead tuples and bloat

2024-06-22 Thread Adrian Klaver
gresql.org/docs/current/storage-toast.html Also: https://www.postgresql.org/docs/current/functions-admin.html 9.27.7. Database Object Management Functions There are functions there that show table sizes among other things. Best regards, Manuel -Original Message----- From: Adrian Klaver Sen

Re: AI for query-planning?

2024-06-22 Thread Adrian Klaver
. 2) Produce high rate of incorrect answers. Thanks. -- *Andreas Joseph Krogh* CTO / Partner - Visena AS Mobile: +47 909 56 963 andr...@visena.com <mailto:andr...@visena.com> www.visena.com <https://www.visena.com> <https://www.visena.com> -- Adrian Klaver adrian.kla...@aklaver.com

Re: Autovacuum, dead tuples and bloat

2024-06-21 Thread Adrian Klaver
g-locks.html to see if there is a process holding that data open. Any thoughts on this? Best regards, Manuel -- Adrian Klaver adrian.kla...@aklaver.com

Re: Autovacuum, dead tuples and bloat

2024-06-20 Thread Adrian Klaver
elp me with my verification? Use: https://www.postgresql.org/docs/current/monitoring-stats.html#MONITORING-PG-STAT-ALL-TABLES-VIEW Select the rows that cover the table or tables involved. Look at the vacuum/autovacuum/analyze fields. Thanks in advance & Best regards, Manuel -- Adrian

Re: Postgresql python in upgraded version 16.2

2024-06-20 Thread Adrian Klaver
epo or the PGDG repo? Thanks Michal TLP:AMBER -- Adrian Klaver adrian.kla...@aklaver.com

Re: Transaction issue

2024-06-20 Thread Adrian Klaver
): At this point I think you need to create a simple test case where: 1) You have script with BEGIN; COMMIT; --optional 2) In psql do \i 3) Do what you did before to 'recover' from the error. Shows us the content of the steps in your reply. Regards, Rich -- Adrian Klaver adrian.kla

Re: Transaction issue

2024-06-19 Thread Adrian Klaver
On 6/19/24 17:27, David G. Johnston wrote: On Wed, Jun 19, 2024 at 5:16 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: You are missing the fact that bustrac is the name of the database so when you specify the -d option you are being redundant and being told that by psq

Re: Transaction issue

2024-06-19 Thread Adrian Klaver
On 6/19/24 15:14, Rob Sargent wrote: On 6/19/24 15:55, David G. Johnston wrote: On Wednesday, June 19, 2024, Adrian Klaver wrote: On 6/19/24 14:33, Rich Shepard wrote: On Wed, 19 Jun 2024, Adrian Klaver wrote: I should have added to previous post: What

Re: Transaction issue

2024-06-19 Thread Adrian Klaver
On 6/19/24 14:55, David G. Johnston wrote: On Wednesday, June 19, 2024, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 6/19/24 14:33, Rich Shepard wrote: On Wed, 19 Jun 2024, Adrian Klaver wrote: I should have added to previous post:

Re: Transaction issue

2024-06-19 Thread Adrian Klaver
On 6/19/24 14:33, Rich Shepard wrote: On Wed, 19 Jun 2024, Adrian Klaver wrote: I should have added to previous post: What is the exact command string you are using to launch psql? $ psql bustrac I find it difficult to believe that actually runs. psql -d test -U postgres -bustrac psql

Re: Transaction issue

2024-06-19 Thread Adrian Klaver
On 6/19/24 13:54, Rich Shepard wrote: On Wed, 19 Jun 2024, Adrian Klaver wrote: Looks to me you have a left over unresolved transaction in your psql session. The easiest solution if that is the case is to exit the session and start a new session to run the script. Adrian, et al.: That's

Re: Transaction issue

2024-06-19 Thread Adrian Klaver
On 6/19/24 13:54, Rich Shepard wrote: On Wed, 19 Jun 2024, Adrian Klaver wrote: Looks to me you have a left over unresolved transaction in your psql session. The easiest solution if that is the case is to exit the session and start a new session to run the script. Adrian, et al.: That's

Re: Transaction issue

2024-06-19 Thread Adrian Klaver
the script. Line 1 is the BEGIN; statement; line 69 is the last row of data to be inserted. Thanks, Rich -- Adrian Klaver adrian.kla...@aklaver.com

Re: Transaction issue

2024-06-19 Thread Adrian Klaver
On 6/19/24 12:40, Rich Shepard wrote: On Wed, 19 Jun 2024, Adrian Klaver wrote: Are there transaction statements e.g. BEGIN;, COMMIT; in the script? Adrian, Yes, each script has BEGIN; on line 1. Does it have a COMMIT; at the end? At this point I think you need to create a simple test

Re: Transaction issue

2024-06-19 Thread Adrian Klaver
On 6/19/24 11:36 AM, Rich Shepard wrote: On Wed, 19 Jun 2024, Adrian Klaver wrote: Is this being done in a script fed to psql? Adrian, Yes. At the psql prompt I use the \i command to run the script. Are there transaction statements e.g. BEGIN;, COMMIT; in the script? Rich

Re: Transaction issue

2024-06-19 Thread Adrian Klaver
continue processing. What is the appropriate way to respond to that error after fixing the syntax error? TIA, Rich -- Adrian Klaver adrian.kla...@aklaver.com

Re: Proper format for pg_dump file date

2024-06-19 Thread Adrian Klaver
On 6/19/24 08:55, Rich Shepard wrote: Is the correct date format for pg_dump -$(date +%Y-%m-%d).sql or --MM-DD.sql or something else? That is your choice, whatever makes sense to you. TIA, Rich -- Adrian Klaver adrian.kla...@aklaver.com

Re: fail to install postgresql15 on Alma9

2024-06-18 Thread Adrian Klaver
not work then the only other suggestion I have is to visit: https://yum.postgresql.org/contact/ -- Adrian Klaver adrian.kla...@aklaver.com

Re: fail to install postgresql15 on Alma9

2024-06-18 Thread Adrian Klaver
eSQL module: sudo dnf -qy module disable postgresql Did you do the above? Then: # Install PostgreSQL: sudo dnf install -y postgresql15-server Thank you, Dmitry -- Adrian Klaver adrian.kla...@aklaver.com

Re: set search_path "$owner". And name versus literal for schemas.

2024-06-18 Thread Adrian Klaver
to say on this subject. Thanks, --DD [1]: https://www.postgresql.org/docs/current/ddl-schemas.html#DDL-SCHEMAS-PATH -- Adrian Klaver adrian.kla...@aklaver.com

Re: HISTIGNORE in psql

2024-06-18 Thread Adrian Klaver
either readline or libedit so it would need to work with those. Have a great day! Wiwwo -- Adrian Klaver adrian.kla...@aklaver.com

Re: DROP COLLATION vs pg_collation question

2024-06-18 Thread Adrian Klaver
fic data, while template0 is known not to." Substitute for template1 and you can get the error you received. Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B -- Adrian Klaver adrian.kla...@aklaver.com

Re: WAL settings for larger imports

2024-06-17 Thread Adrian Klaver
pointless. 2) An answer is going to need more information: a) Postgres version? b) What are your current settings? c) What constitutes a 'larger import'? d) How often are you doing these imports? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Is a VACUUM or ANALYZE necessary after logical replication?

2024-06-15 Thread Adrian Klaver
what query plan to use. On a fresh table VACUUM will not be of much value, ANALYZE though will help by creating up to date table statistics. Regards, Koen De Groote -- Adrian Klaver adrian.kla...@aklaver.com

Re: Configure autovacuum

2024-06-14 Thread Adrian Klaver
that the autovacuum would start basically after each update (due to autovacuum_vacuum_threshold=1). But the autovacuum is not running. Is it possible to configure postgres to autovacuum very aggressively (i.e. after each update-statement)? Thanks in advance & Best regards, Manuel -- Ad

Re: Reset sequence to current maximum value of rows

2024-06-13 Thread Adrian Klaver
On 6/13/24 15:13, Rich Shepard wrote: On Thu, 13 Jun 2024, Adrian Klaver wrote: Not with: Table "public.companies" [...] Indexes:    "organizations_pkey" PRIMARY KEY, btree (company_nbr) That would throw duplicate key errors. Are you sure that you did not do this o

Re: Reset sequence to current maximum value of rows

2024-06-13 Thread Adrian Klaver
rrors. Are you sure that you did not do this on the contacts table as the company FK back to companies? single-line INSERT command company numbers from 2341-2392 all had 'A new company name' as the company_name. HTH, Rich -- Adrian Klaver adrian.kla...@aklaver.com

Re: Reset sequence to current maximum value of rows

2024-06-13 Thread Adrian Klaver
ed by:     TABLE "locations" CONSTRAINT "locations_org_nbr_fkey" FOREIGN KEY (company_nbr) REFERENCES companies(company_nbr) ON UPDATE CASCADE ON DELETE RESTRICT     TABLE "people" CONSTRAINT "people_org_nbr_fkey" FOREIGN KEY (company_nbr) REFERENCES companies(c ompany_n

Re: Oracle Linux 9 Detected RPMs with RSA/SHA1 signature

2024-06-13 Thread Adrian Klaver
On 6/13/24 06:55, Hans Schou wrote: Reply to list also. Ccing list On Wed, Jun 12, 2024 at 4:34 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: Take a look at: https://yum.postgresql.org/news/pgdg-rpm-repo-gpg-key-update/ <https://yum.postgresql.org/n

Re: TOAST Table / Dead Tuples / Free Pages

2024-06-13 Thread Adrian Klaver
__ __ Thanks in advance & Best regards,____ Manuel __ __ -- Adrian Klaver adrian.kla...@aklaver.com

Re: Definging columns for INSERT statements

2024-06-12 Thread Adrian Klaver
On 6/12/24 16:24, Rich Shepard wrote: On Wed, 12 Jun 2024, Adrian Klaver wrote: Assuming 'people_person_nbr_seq' is the sequence attached to person_nbr and the other DEFAULTs are the column defaults then the syntax would be: INSERT INTO people (person_nbr, lname, fname, job_title, company_nbr

Re: Definging columns for INSERT statements

2024-06-12 Thread Adrian Klaver
ich -- Adrian Klaver adrian.kla...@aklaver.com

Re: Oracle Linux 9 Detected RPMs with RSA/SHA1 signature

2024-06-12 Thread Adrian Klaver
the ol-repo. But is this the recommended way to do it? Take a look at: https://yum.postgresql.org/news/pgdg-rpm-repo-gpg-key-update/ Also the contact info for the RH packagers: https://yum.postgresql.org/contact/ -- Adrian Klaver adrian.kla...@aklaver.com

Re: Does trigger only accept functions?

2024-06-11 Thread Adrian Klaver
ns or column types change, your audit table will need to change to match. One possible solution is something I outlined here: https://aklaver.org/wordpress/2021/12/07/postgres-and-json/ Other folks have done similar things, you can search on postgresql audit tables using json for alternatives

Re: Unexpected Backend PID reported by Notification

2024-06-11 Thread Adrian Klaver
a trigger the reason??? ** e.g. [4053957 != 4053955] BOOST_CHECK_EQUAL(perreq_notif.backend_pid(), c.backend_pid()); */ BOOST_CHECK_EQUAL(perreq_notif.payload(), "..."); -- Adrian Klaver adrian.kla...@aklaver.com

Re: Escaping single quotes with backslash seems not to work

2024-06-10 Thread Adrian Klaver
at's beyond my control.) -- Adrian Klaver adrian.kla...@aklaver.com

Re: Does trigger only accept functions?

2024-06-10 Thread Adrian Klaver
log_deletes_source_table (); Regards Veem -- Adrian Klaver adrian.kla...@aklaver.com

Re: libpq v17 PQsocketPoll timeout is not granular enough

2024-06-10 Thread Adrian Klaver
s is also beta1, I,e, the first one. My €0.02 -- Adrian Klaver adrian.kla...@aklaver.com

Re: Escaping single quotes with backslash seems not to work

2024-06-10 Thread Adrian Klaver
n from PG 9.6.24 to 14.12, and I don't know why.  I'm not a Java programmer, though. Was there a change in the JDBC driver also? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Questions on logical replication

2024-06-08 Thread Adrian Klaver
or various situations where the instance receiving the logical replication, suddenly stop being able to receive. Resyncing, and the effects of WAL buildup, are my main concern. Accidentally sent a mail to only your email, sorry for that. Regards, Koen De Groote -- Adrian Klaver adrian.kla

Re: Questions on logical replication

2024-06-07 Thread Adrian Klaver
be easier for folks to offer suggestions on what to do or not to do. Thanks for the help Regards, Koen De Groote -- Adrian Klaver adrian.kla...@aklaver.com

  1   2   3   4   5   6   7   8   9   10   >