Re: Beginner Question:Why it always make sure that the postgres better than common csv file storage in disaster recovery?

2022-07-03 Thread Adrian Klaver
r recovery? https://www.postgresql.org/docs/current/wal.html Thanks in advance! -- Adrian Klaver adrian.kla...@aklaver.com

Re: Function inside query status

2022-06-30 Thread Adrian Klaver
looked at?: https://www.postgresql.org/docs/current/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS and https://www.postgresql.org/docs/current/plpgsql-control-structures.html#PLPGSQL-EXCEPTION-DIAGNOSTICS End; $$ language plpgsql; -- Adrian Klaver adrian.kla...@aklaver.com

Re: ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8)

2022-06-23 Thread Adrian Klaver
On 6/23/22 10:11, Adrian Klaver wrote: On 6/23/22 00:37, Tomas Pospisek wrote: On 22.06.22 22:18, Tomas Pospisek wrote: On 22.06.22 21:25, Adrian Klaver wrote: On 6/22/22 12:17, Tomas Pospisek wrote: So I used both pg_dump and pg_restore from the newer machine. Result is still the same

Re: ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8)

2022-06-23 Thread Adrian Klaver
On 6/23/22 00:37, Tomas Pospisek wrote: On 22.06.22 22:18, Tomas Pospisek wrote: On 22.06.22 21:25, Adrian Klaver wrote: On 6/22/22 12:17, Tomas Pospisek wrote: So I used both pg_dump and pg_restore from the newer machine. Result is still the same.  So I'll use Tom Lane's sugg

Re: ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8)

2022-06-22 Thread Adrian Klaver
LC_CTYPE = 'en_US.UTF-8'; Any hints or help? Are dumping/restoring from one version of Postgres to another? If from older to newer then use the new version of pg_dump(13) to dump the older(12) database. Then the 13 version of restore to load the version 13 database. *t -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to use 32 bit ODBC driver

2022-06-21 Thread Adrian Klaver
lease reply to this message and follow with its deletion, so that we can ensure such a mistake does not occur in the future./ -- Adrian Klaver adrian.kla...@aklaver.com

Re: A error happend when I am clone the git repository

2022-06-19 Thread Adrian Klaver
ora 36 in combination with latest Git 2.36.1. I have ask this problem in the slack group,and now I report this to the mail list,please check it,thanks very much! -- Adrian Klaver adrian.kla...@aklaver.com

Re:

2022-06-16 Thread Adrian Klaver
On 6/16/22 07:08, Rama Krishnan wrote: Hi , What type of temp database should i use to maintain logs or export logs? There is no temp database. You will need to be more specific about what you want to achieve. Thanks Rama-krishnan -- Adrian Klaver adrian.kla...@aklaver.com

Re: PostgreSQL 12.2 on Linux ubuntu 20.4 / s390

2022-06-15 Thread Adrian Klaver
. As Tom Lane said you have the options of building from source or SRPM. postgresql-12/focal 12.2-4 s390x Regards Ian -- Adrian Klaver adrian.kla...@aklaver.com

Re: Tools to convert timestamp data to another time zone in PostgreSQL

2022-06-13 Thread Adrian Klaver
to easily identify the affected columns, exclude columns if necessary, and apply the necessary conversion. If not, we would have to write a utility that does this for us, which could be a lengthy process. Thanks, Joel -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to get response message

2022-06-10 Thread Adrian Klaver
nt/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS End; $$ language plpgsql; -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to drop a subscription inside a stored procedure?

2022-06-10 Thread Adrian Klaver
y the ALTER SUBSCRIPTION first, though note the caveats here: https://www.postgresql.org/docs/current/sql-altersubscription.html Regards Thomas -- Adrian Klaver adrian.kla...@aklaver.com

Re: Cluster OID Limit

2022-06-09 Thread Adrian Klaver
if there is any discussion on: * "compress" the OID space * "warp around" the OID space * segment a OID range for temporary tables with "wrap around" -- Lucas -- Adrian Klaver adrian.kla...@aklaver.com

Re: Database trigger (one server to another)

2022-05-31 Thread Adrian Klaver
anything. You might try postgres_fdw: https://www.postgresql.org/docs/current/postgres-fdw.html Set up a table in the second server that links to the other server. Then you have access to the data on the second server. Best Bilal -- Adrian Klaver adrian.kla...@aklaver.com

Re: psql 15beta1 does not print notices on the console until transaction completes

2022-05-29 Thread Adrian Klaver
On 5/29/22 15:03, Tom Lane wrote: Adrian Klaver writes: On 5/29/22 13:59, Alastair McKinley wrote: I think Tom was able to reproduce this by the sounds of his response? I have not received that post yet. I do see it in the archives. I re-addressed it to pgsql-bugs, maybe you are not

Re: psql 15beta1 does not print notices on the console until transaction completes

2022-05-29 Thread Adrian Klaver
On 5/29/22 13:59, Alastair McKinley wrote: > > From: Adrian Klaver > Sent: 29 May 2022 21:47To: Alastair McKinley Hi Adrian, I am running the function "select test_notice();" from the psql console with psql/server versions 15beta1. In psql 15beta1, the notice app

Re: psql 15beta1 does not print notices on the console until transaction completes

2022-05-29 Thread Adrian Klaver
On 5/29/22 13:47, Adrian Klaver wrote: On 5/29/22 13:11, Alastair McKinley wrote: Hi all, In psql 15beta1, the "hello" message only appears on the console when the transaction completes. I am not seeing that. I take that back, I was using psql 14.3 to connect to the 15 instanc

Re: psql 15beta1 does not print notices on the console until transaction completes

2022-05-29 Thread Adrian Klaver
ore information about how you are running test_notice()? in psql 14.3, it appears immediately as I would have expected. Is there a way to change psql behaviour to display notices immediately as in versions < 15? Best regards, Alastair -- Adrian Klaver adrian.kla...@aklaver.com

Re: Function definition regression in 15beta1 when specific parameter name (string) is used

2022-05-29 Thread Adrian Klaver
On 5/29/22 10:29, Adrian Klaver wrote: On 5/29/22 09:46, Alastair McKinley wrote: Hi all, Postgres 15: https://www.postgresql.org/docs/15/sql-keywords-appendix.html STRING reserved (can be function or type) non-reserved Postgres 14: https://www.postgresql.org/docs/14/sql

Re: Function definition regression in 15beta1 when specific parameter name (string) is used

2022-05-29 Thread Adrian Klaver
be function or type) non-reserved Postgres 14: https://www.postgresql.org/docs/14/sql-keywords-appendix.html STRING non-reserved I don't have a 15 instance available, but I would double quoting "string" would work. Alastair -- Adrian Klaver adrian.kla...@aklaver.com

Re: JSONB index not in use, but is TOAST the real cause of slow query?

2022-05-28 Thread Adrian Klaver
.because anything at all that you do with that big JSONB column is going to be expensive. (Another thing that's been on the to-do list for awhile is enabling partial retrieval of large JSONB values, but AFAIK that hasn't happened yet either.) Thanks, Shaheed -- Adrian Klaver adrian.kla...@aklaver.com

Re: Determine if range list contains specified integer

2022-05-27 Thread Adrian Klaver
st only. How to change join so that type ranges in list like 6-9 are also returned? Eq. f list contains 6-9, Type 6,7,8 and 9 shoud included in report. Start over with a more rational data model. Andrus. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Automatic PK values not added to new rows

2022-05-25 Thread Adrian Klaver
for issues. Either let the system do it's thing and be an out of site out of mind number generator or take full control of the id generation yourself. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Automatic PK values not added to new rows

2022-05-25 Thread Adrian Klaver
On 5/25/22 11:18 AM, Rich Shepard wrote: On Wed, 25 May 2022, Adrian Klaver wrote: What is max(person_nbr)? bustrac=# select max(person_nbr) from people;  max -  965 (1 row) From: https://www.postgresql.org/docs/current/functions-sequence.html SELECT setval('people_person_nb

Re: Automatic PK values not added to new rows

2022-05-25 Thread Adrian Klaver
On 5/25/22 11:15 AM, Rich Shepard wrote: On Wed, 25 May 2022, Adrian Klaver wrote: Do: select * from people_person_nbr_seq; and report back the results. Adrian, Huh! bustrac=# select * from people_person_nbr_seq;  last_value | log_cnt | is_called

Re: Automatic PK values not added to new rows

2022-05-25 Thread Adrian Klaver
issed? Do: select * from people_person_nbr_seq; and report back the results. Rich -- Adrian Klaver adrian.kla...@aklaver.com

Re: Connect to specific cluster on command line

2022-05-25 Thread Adrian Klaver
, it makes things a lot easier. Otherwise follow the instructions others have provided for using -h and -p. You will also need to do -h/-p if you are trying to reach remote instances of Postgres. Regards, Carsten -- Adrian Klaver adrian.kla...@aklaver.com

Re: Can I start Update row in After Insert trigger function?

2022-05-24 Thread Adrian Klaver
ed and the INSERT, UPDATE, or DELETE has completed); or instead of the operation (in the case of inserts, updates or deletes on a view)." So the INSERT has completed in an AFTER trigger. Thank you! BR, dd -- Adrian Klaver adrian.kla...@aklaver.com

Re: list tablespaces named in custom format dump

2022-05-23 Thread Adrian Klaver
Postgres 10 instance to restore to from version 10 dump file then dump from using version 14 pg_dump to restore Postgres 14 instance. 3) Spin up a VM either on cloud service or locally and install Postgres 10 and do the version 10 restore/version 14 pg_dump there. -- Adrian Klaver

Re: list tablespaces named in custom format dump

2022-05-23 Thread Adrian Klaver
rsion 14.2 -- Dumped by pg_dump version 14.2 anyway. As to older version, how are you installing Postgres? Much appreciated, rjs -- Adrian Klaver adrian.kla...@aklaver.com

Re: list tablespaces named in custom format dump

2022-05-23 Thread Adrian Klaver
re done with v13 pg-restore.  This surprises me, but I do not manage the server.  Maybe my dump file doesn't have anything pg14 restore can't handle.. we'll see I have abused this on occasion and succeeded, though sometimes it involves some tweaks. Thanks again, all. -- Adrian Klaver adrian.kla...@aklaver.com

Re: list tablespaces named in custom format dump

2022-05-23 Thread Adrian Klaver
On 5/23/22 10:19 AM, Rob Sargent wrote: On 5/23/22 11:07, Adrian Klaver wrote: On 5/23/22 10:01 AM, Rob Sargent wrote: On 5/23/22 11:00, Adrian Klaver wrote: On 5/23/22 9:54 AM, Rob Sargent wrote: On 5/23/22 10:50, Adrian Klaver wrote: This is great news.  I do have pg14.  I thought

Re: Can I start Update row in After Insert trigger function?

2022-05-23 Thread Adrian Klaver
re working with. Call trigger with UPDATE and INSERT. Version: PGSQL 9.6-11 Thank you for your help! Best regards,    dd -- Adrian Klaver adrian.kla...@aklaver.com

Re: list tablespaces named in custom format dump

2022-05-23 Thread Adrian Klaver
On 5/23/22 10:01 AM, Rob Sargent wrote: On 5/23/22 11:00, Adrian Klaver wrote: On 5/23/22 9:54 AM, Rob Sargent wrote: On 5/23/22 10:50, Adrian Klaver wrote: Roger that, but does the dump of a database name the tablespaces from which the objects were retrieved? And if so, is that accessible

Re: list tablespaces named in custom format dump

2022-05-23 Thread Adrian Klaver
On 5/23/22 9:54 AM, Rob Sargent wrote: On 5/23/22 10:50, Adrian Klaver wrote: Roger that, but does the dump of a database name the tablespaces from which the objects were retrieved? And if so, is that accessible? https://www.postgresql.org/docs/14/app-pgrestore.html "--no-tables

Re: list tablespaces named in custom format dump

2022-05-23 Thread Adrian Klaver
back up global objects that are common to all databases in a cluster (such as roles and tablespaces), use pg_dumpall." https://www.postgresql.org/docs/14/app-pg-dumpall.html "-g --globals-only Dump only global objects (roles and tablespaces), no databases. " Thanks,

Re: Who am I? Where am I connected?

2022-05-18 Thread Adrian Klaver
Postgres Frontend/Backend protocol: https://www.postgresql.org/docs/current/protocol.html -- Adrian Klaver adrian.kla...@aklaver.com

Re: Restricting user to see schema structure

2022-05-17 Thread Adrian Klaver
o the "insecurity by default" paradigm. I s'pose that compatibility on upgrade means that nothing can change here. There is movement on this front coming in Postgres 15: https://www.postgresql.org/docs/devel/release-15.html#id-1.11.6.5.3 -- Adrian Klaver adrian.kla...@aklaver.com

Re: TO_DATE function between PostgreSQL 8.2 and 9.4

2022-05-17 Thread Adrian Klaver
. What the OP is running into is the tip of the iceberg of the changes not only in 8.3 but the other 6 major versions involved. The time spent trying to create a compatibility layer for this jump and subsequent jumps would be better spent actually making the code current. John -- Adr

Re: TO_DATE function between PostgreSQL 8.2 and 9.4

2022-05-17 Thread Adrian Klaver
nation (||) operator, so long as least one input is a character-string type. " Regards, -- gzh -- Adrian Klaver adrian.kla...@aklaver.com

Re: Restricting user to see schema structure

2022-05-17 Thread Adrian Klaver
If not specified, NOREPLICATION is the default. You must be a superuser to create a new role having the REPLICATION attribute. " So the default of NOREPLICATION is mentioned. replication(pg_hba.conf 'dummy' value) and REPLICATION/NOREPLICATION roles are referring to different aspects of the same process. Honestly I'm not seeing how this is any different from database postgres and role postgres. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Restricting user to see schema structure

2022-05-16 Thread Adrian Klaver
postgres from joe", my "\c postgres joe" succeeded. Because as mentioned previously you did not "revoke connect on database postgres from public". -- Adrian Klaver adrian.kla...@aklaver.com

Re: Restricting user to see schema structure

2022-05-13 Thread Adrian Klaver
tions to a given database by a particular user by using settings in pg_hba.conf. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Restricting user to see schema structure

2022-05-13 Thread Adrian Klaver
talogs. Thanks & Regards Neeraj -- Adrian Klaver adrian.kla...@aklaver.com

Re: Restricting user to see schema structure

2022-05-12 Thread Adrian Klaver
any of the other system catalogs. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Restricting user to see schema structure

2022-05-12 Thread Adrian Klaver
& Regards Neeraj -- Adrian Klaver adrian.kla...@aklaver.com

Re: Fedora 36

2022-05-12 Thread Adrian Klaver
On 5/12/22 03:39, Kieran McCusker wrote: Please reply to list also Ccing list. Hi Fedora 36 is there now but it is missing pg_cron - Is that intentional? I don't know that is something you would need to ask the packagers: https://yum.postgresql.org/contact/ Cheers Kieran -- A

Re: Fedora 36

2022-05-10 Thread Adrian Klaver
On 5/10/22 09:38, Kieran McCusker wrote: Hi Is there any timeline for a Fedora 36 repository as it should be released today? Looks like it is there: https://yum.postgresql.org/packages/#pg14 Many thanks Kieran -- Adrian Klaver adrian.kla...@aklaver.com

Re: Need to install Postgres Version 14 in Linux server with Client and migration steps.

2022-05-09 Thread Adrian Klaver
: https://www.postgresql.org/download/ As to migrating that would need more information: 1) Migrating from what version of Postgres? 2) Migrate as?: a) Dump and then restore. OR b) pg_upgrade Regards Thirumurugan Rajamoorthy – Biometrics Support -- Adrian Klaver adrian.kla

Re: WIN1252 vs UTF8 database encoding

2022-05-04 Thread Adrian Klaver
. Does it make sense? Yes: https://www.postgresql.org/docs/current/multibyte.html "On Windows, however, UTF-8 encoding can be used with any locale." Regards, Jorge Maldonado -- Adrian Klaver adrian.kla...@aklaver.com

Re: Backing up a DB excluding certain tables

2022-05-03 Thread Adrian Klaver
c chcp 1252 Active code page: 1252 C:\Users\JorgeMal>chcp Active code page: 1252 The result always included tables with *AspNet* in the name. I am at a loss for an answer. I just don't use Windows enough to know where to go from here. Regards, Jorge Maldonado --

Re: Backing up a DB excluding certain tables

2022-05-03 Thread Adrian Klaver
-table '*."AspNet*"' * --exclude-table'*."AspNet*"' -------- -- Adrian Klaver adrian.kla...@aklaver.com

Re: Backing up a DB excluding certain tables

2022-05-02 Thread Adrian Klaver
text only. The information is then lost. Copy and paste from the console. Back to the issue at hand: 1) Did you try the suggestion in the "Notes for Windows users" for the riopoderoso database? 2) What was the pg_dump command that you used that worked? With respect, Jorge Mald

Re: External psql editor

2022-04-29 Thread Adrian Klaver
the file later by doing. \e afiedt.buf Regards -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com -- Adrian Klaver adrian.kla...@aklaver.com

Re: Privilege error with c functions during postgresql upgrade from 11 -> 13

2022-04-28 Thread Adrian Klaver
THORIZATION; SELECT pg_catalog.binary_upgrade_set_record_init_privs(false); REVOKE ALL ON FUNCTION "public"."bt_index_check"("index" "regclass") FROM "16416"; In other words why the role 16416 was GRANTed ALL then REVOKEd ALL on the function? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Backing up a DB excluding certain tables

2022-04-28 Thread Adrian Klaver
On 4/28/22 09:57, JORGE MALDONADO wrote: Good day, Here is the output to commands suggested by *Adrian Klaver*. Encoding is the same in both client and server. Also, there are 7 tables I want to exclude. image.png The version of source DB is 11, and target version is 14. Regarding the

Re: Backing up a DB excluding certain tables

2022-04-27 Thread Adrian Klaver
t to exclude these tables because they are created and managed by other means. Such tables are part of the authentication feature included in ASP.NET <http://ASP.NET> Core. With respect, Jorge Maldonado -- Adrian Klaver adrian.kla...@aklaver.com

Re: Privilege error with c functions during postgresql upgrade from 11 -> 13

2022-04-27 Thread Adrian Klaver
this same error for pg_buffercache_pages() as well. They are both c functions stored in libdir. Can anyone point me towards where pg_dump is getting these outdated permissions from please? Thanks! -- Adrian Klaver adrian.kla...@aklaver.com

Re: Fresh eyeballs needed: input into error [FIXED]

2022-04-26 Thread Adrian Klaver
On 4/26/22 20:11, Bruce Momjian wrote: On Tue, Apr 26, 2022 at 06:09:42PM -0700, Rich Shepard wrote: On Tue, 26 Apr 2022, Rich Shepard wrote: I am curious what OS psql was using that was fixed by a re-login? Rich uses Slackware. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Fresh eyeballs needed: input into error

2022-04-26 Thread Adrian Klaver
ax, somewhere since this morning you introduced a hidden character into the string. Thanks, Rich -- Adrian Klaver adrian.kla...@aklaver.com

Re: Fresh eyeballs needed: input into error

2022-04-26 Thread Adrian Klaver
On 4/26/22 2:53 PM, Rich Shepard wrote: On Tue, 26 Apr 2022, Adrian Klaver wrote: I'm guessing some sort of hidden character. Adrian, Oh, ... forgot to mention in my response that the MWE values were added to the template in emacs while I get the same error using psql -d -f in a v.

Re: Fresh eyeballs needed: input into error

2022-04-26 Thread Adrian Klaver
character. What client are you using to run this? Where is the query string coming from? TIA, Rich -- Adrian Klaver adrian.kla...@aklaver.com

Re: Backing up a DB excluding certain tables

2022-04-26 Thread Adrian Klaver
s below." And Examples is: https://www.postgresql.org/docs/current/app-pgdump.html#PG-DUMP-EXAMPLES Respectfully, Jorge Maldonado -- Adrian Klaver adrian.kla...@aklaver.com

Re: Handling glibc v2.28 breaking changes

2022-04-24 Thread Adrian Klaver
ta_changes Thank you for your help. Best regards, Pradeep -- Adrian Klaver adrian.kla...@aklaver.com

Re: SELECT creates millions of temp files in a single directory

2022-04-23 Thread Adrian Klaver
beloved ZFS, and as a lover I react. ;) Be that as it may, the requested information is still needed. -- Adrian Klaver adrian.kla...@aklaver.com

Re: SELECT creates millions of temp files in a single directory

2022-04-23 Thread Adrian Klaver
On 4/23/22 14:58, Peter wrote: On Sat, Apr 23, 2022 at 02:11:00PM -0700, Adrian Klaver wrote: ! On 4/23/22 12:50, Peter wrote: ! ! ! > People seem to have been brainwashed by Web-Services and OLTP, ! > and now think the working set must always fit in memory. But this ! > is

Re: SELECT creates millions of temp files in a single directory

2022-04-23 Thread Adrian Klaver
recent years have been that Postgres was/is to conservative in its default settings and is not taking advantage of newer more powerful hardware. -- Adrian Klaver adrian.kla...@aklaver.com

Re: PG14: "is of" vs pg_typeof

2022-04-23 Thread Adrian Klaver
:regtype); ?column? -- t select pg_typeof(1::int) in ('text'::regtype, 'varchar'::regtype); ?column? -- f Thanks, Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B -- Adrian Klaver adrian.kla...@aklaver.com

Re: PG14: "is of" vs pg_typeof

2022-04-23 Thread Adrian Klaver
5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B -- Adrian Klaver adrian.kla...@aklaver.com

Re: PG14: "is of" vs pg_typeof

2022-04-23 Thread Adrian Klaver
ersion 13. I also am not seeing, yet, where it was removed in 14. Is there anything obvious I am missing for easily resurrecting the above "is of" use ? Thanks, Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B -- Adrian Klaver adrian.kla...@aklaver.com

Re: Huge archive log generate in Postgresql-13

2022-04-21 Thread Adrian Klaver
d how is it managed? Regards, Ram Pratap. -- Adrian Klaver adrian.kla...@aklaver.com

Re: PostgreSQL 10.20 crashes / Antivirus

2022-04-21 Thread Adrian Klaver
-v", "-F", "c", "-d", $dbName, "-h", "localhost", "-p", "6488", "-U", " backup_su", "-f", $backupFile) cmd /c $pgdumpCmd $pgdumpArgs 2`>`&1 | Out-File $pgdumpLogFile Richard -- Adrian Klaver adrian.kla...@aklaver.com

Re: Are stored procedures/triggers common in your industry

2022-04-20 Thread Adrian Klaver
that actually is. For my purposes keeping this logic in the database makes changing or running multiple front ends easier. There is one place to change the logic vs keeping the same logic in different front ends in potentially different languages in sync. So for me it is common. -- Adrian

Re: PostgreSQL 10.20 crashes / Antivirus

2022-04-20 Thread Adrian Klaver
On 4/20/22 10:23 AM, Thomas, Richard wrote: 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

Re: PostgreSQL 10.20 crashes / Antivirus

2022-04-20 Thread Adrian Klaver
On 4/20/22 10:23 AM, Thomas, Richard wrote: 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) Why not? I would think the whole C:\Program Files\PostgreSQL\10\bin

Re: Can anyone confirm the flaw of postgres and how to deal with it?

2022-04-20 Thread Adrian Klaver
ble Best guess is that since you are not filtering on table_schema you are seeing columns for tables with table_name=a_table across all schemas. keeps listing columns that I can not see in the current table. Why does this happen? What is the solution? Regards, David -- Adrian Klaver

Re: PostgreSQL 10.20 crashes / Antivirus

2022-04-20 Thread Adrian Klaver
On 4/20/22 01:06, Thomas, Richard wrote: Adrian Klaver wrote: What are the actual commands you are using to do the above? 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.ex

Re: Joining with calendar table

2022-04-19 Thread Adrian Klaver
DATE, '2022-04-18'::DATE, '1 DAY' ) as j(a) left join dat on j.a = dat.jour where dat.jour is null; INSERT 0 14 Verify the dates where added then: COMMIT; -- Adrian Klaver adrian.kla...@aklaver.com

Re: Huge archive log generate in Postgresql-13

2022-04-19 Thread Adrian Klaver
ggest what changes need to required in PG13 conf file. Regards, Ram Pratap. -Original Message----- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>] Sent: 18 April 2022 21:30 To: Ram Pratap Maurya <mailto:ram.mau...@lavainternation

Re: PostgreSQL 10.20 crashes / Antivirus

2022-04-19 Thread Adrian Klaver
s creating the .backup file ..." What are the actual commands you are using to do the above? Richard -- Adrian Klaver adrian.kla...@aklaver.com

Re: No psql md5 auth, psql 14.1 to PG 11

2022-04-18 Thread Adrian Klaver
password types. So: 1) How where the Postgres instances installed on both machines? 2) What is the exact psql command you are using? 3) What is the complete error message? Thanks, Pete O'Such -- Adrian Klaver adrian.kla...@aklaver.com

Re: Facing issues with pgsql upgrade.

2022-04-18 Thread Adrian Klaver
have a backup. Regards, Ajay On Mon, Apr 18, 2022 at 9:48 AM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 4/17/22 19:11, Ajay Kajla wrote: > Thanks Adrian, > > 1. What if we re-create template0 and template1? First I would determine

Re: Huge archive log generate in Postgresql-13

2022-04-18 Thread Adrian Klaver
documentation. Can you please suggest why huge archive log generated after upgrade  there any configure setting or this is Postgresql-13 behaviour. Postgresql-13 Postgresql conf file attached for your references. Regards, Ram Pratap. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Facing issues with pgsql upgrade.

2022-04-17 Thread Adrian Klaver
restore them if we have a folder backup of the data directory? When was the backup done and how? Are you sure it is a complete backup? Do you have tablespaces,other then the default, in use? Regards, Ajay -- Adrian Klaver adrian.kla...@aklaver.com

Re: Facing issues with pgsql upgrade.

2022-04-17 Thread Adrian Klaver
e database subdirectory "base/1" is missing. Previous connection kept postgres=# With Regards, Ajay Kajla -- Adrian Klaver adrian.kla...@aklaver.com

Re: Require details that can we see the password history to a User account in PostgreSQL Database.

2022-04-16 Thread Adrian Klaver
r an internal auditing purpose. Thanks. */Warm regards,/**/ M Sonai Muthu Raja -- Adrian Klaver adrian.kla...@aklaver.com

Re: function defined (or not), more worries on version 10->14 upgrade

2022-04-15 Thread Adrian Klaver
| Argument data types | Type +-+---+---+-- public | upc_check_digit | character varying | upc character varying | func (1 row) regards, tom lane -- Adrian Klaver adrian.kla...@aklaver.com

Re: function defined (or not), more worries on version 10->14 upgrade

2022-04-15 Thread Adrian Klaver
n, including volatility, parallel safety, owner, security classification, access privileges, language, source code and description. -- Adrian Klaver adrian.kla...@aklaver.com

Re: function defined (or not), more worries on version 10->14 upgrade

2022-04-15 Thread Adrian Klaver
he supplied arguments to the function in question are obviously bogus, but the reaction is correct, including call to nested functions. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Require details that can we see the password history to a User account in PostgreSQL Database.

2022-04-15 Thread Adrian Klaver
a Postgres role or an application user? Please do the needful since the information require for auditing purpose. */Warm regards,/**/ M Sonai Muthu Raja Managed Delivery Services - DBA Support -- Adrian Klaver adrian.kla...@aklaver.com

Re: OpenSSL@1.1 not getting linked with Homebrew - trying to install postgresql

2022-04-12 Thread Adrian Klaver
n occurred within a child process:       RuntimeError: /usr/local/opt/openssl@1.1 not present or broken     Please reinstall openssl@1.1. Sorry :( Is openssl@1.1 actually at /usr/local/opt/ ? -- Adrian Klaver adrian.kla...@aklaver.com

Re: How easy is it to lose permissions in 'public' schema?

2022-04-11 Thread Adrian Klaver
On 4/11/22 17:34, Tom Lane wrote: Adrian Klaver writes: On 4/11/22 16:10, Rob Sargent wrote: I've just bumped into this. barnard=> select public.genome_threshold_mono('a'::text,'b'::text); ERROR:  permission denied for schema public LINE 1: select public.genome

Re: How easy is it to lose permissions in 'public' schema?

2022-04-11 Thread Adrian Klaver
what permissions the functions in public have? I've run those grants specifically naming public and all is well. Do I need to add that to the installer script? -- Adrian Klaver adrian.kla...@aklaver.com

Re: FOR integer loop bug?

2022-04-08 Thread Adrian Klaver
On 4/8/22 11:23, Ron wrote: On 4/8/22 13:07, Adrian Klaver wrote: Hmm, I'm going to have to think on this. The only thinking is: "That's a bug waiting to happen!" That was my first inclination. From here: https://www.postgresql.org/docs/current/plpgsql-control-str

Re: FOR integer loop bug?

2022-04-08 Thread Adrian Klaver
On 4/8/22 10:58 AM, Pavel Stehule wrote: pá 8. 4. 2022 v 19:56 odesílatel Adrian Klaver Why is the three period form allowed through and why does it produce no result? Maybe (2022-04-08 19:57:57) postgres=# select .10; ┌──┐ │ ?column? │ ╞══╡ │     0.10

FOR integer loop bug?

2022-04-08 Thread Adrian Klaver
6: FOR i IN 1.10 LOOP respectively. Why is the three period form allowed through and why does it produce no result? -- Adrian Klaver adrian.kla...@aklaver.com

Re: psql removes dashed comments

2022-04-07 Thread Adrian Klaver
On 4/7/22 11:25, Boris Zentner wrote: Hi, I was wondering why psql loose dashed comments and what can be done about this misbehaviour. See this recent thread: https://www.postgresql.org/message-id/265623A4-F304-4E68-90D0-343F614DB2B7%40americanefficient.com -- Boris -- Adrian

Re: Per-Table vacuum_freeze_min_age

2022-04-06 Thread Adrian Klaver
On 4/6/22 3:28 PM, Chris Bisnett wrote: On Wed, Apr 6, 2022 at 6:24 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: It can: https://www.postgresql.org/docs/current/sql-createtable.html#SQL-CREATETABLE-STORAGE-PARAMETERS <https://www.postgresql.org/docs

Re: Per-Table vacuum_freeze_min_age

2022-04-06 Thread Adrian Klaver
://www.postgresql.org/docs/current/sql-createtable.html#SQL-CREATETABLE-STORAGE-PARAMETERS Per-table value for vacuum_freeze_min_age parameter. - chris -- Adrian Klaver adrian.kla...@aklaver.com

Re: Problem with PG 11 database on OrangePi3 (ARMBIAN, ARM64) after disk disrupion (problem with USB disk connection)

2022-04-06 Thread Adrian Klaver
e ext4 recovery mechanisms failed. This makes me logical replication more appealing. Laurent -- Adrian Klaver adrian.kla...@aklaver.com

<    8   9   10   11   12   13   14   15   16   17   >