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
?
Do:
select * from people_person_nbr_seq;
and report back the results.
Rich
--
Adrian Klaver
adrian.kla...@aklaver.com
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
ecked 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
a 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
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
ne 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
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 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
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
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
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,
the Postgres Frontend/Backend protocol:
https://www.postgresql.org/docs/current/protocol.html
--
Adrian Klaver
adrian.kla...@aklaver.com
undo 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
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
--
Adrian Klaver
erator, so long as least one input is a character-string type.
"
Regards,
--
gzh
--
Adrian Klaver
adrian.kla...@aklaver.com
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
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
a given database by a particular user by using settings in pg_hba.conf.
--
Adrian Klaver
adrian.kla...@aklaver.com
eraj
--
Adrian Klaver
adrian.kla...@aklaver.com
of the
other system catalogs.
--
Adrian Klaver
adrian.kla...@aklaver.com
& Regards
Neeraj
--
Adrian Klaver
adrian.kla...@aklaver.com
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
--
Adrian
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
:
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
.
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
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
--
Adri
et*"'
* --exclude-table'*."AspNet*"'
--------
--
Adrian Klaver
adrian.kla...@aklaver.com
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
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
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
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
ecause 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
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
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
ning you introduced a
hidden character into the string.
Thanks,
Rich
--
Adrian Klaver
adrian.kla...@aklaver.com
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.t
to run this?
Where is the query string coming from?
TIA,
Rich
--
Adrian Klaver
adrian.kla...@aklaver.com
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
Thank you for your help.
Best regards,
Pradeep
--
Adrian Klaver
adrian.kla...@aklaver.com
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
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
in 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
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
1713 AFA6 5BC0 3BEA AC80 7D4F C89B
--
Adrian Klaver
adrian.kla...@aklaver.com
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
is it managed?
Regards,
Ram Pratap.
--
Adrian Klaver
adrian.kla...@aklaver.com
-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
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
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
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
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
adrian.kla
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
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
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
ating the .backup file ..."
What are the actual commands you are using to do the above?
Richard
--
Adrian Klaver
adrian.kla...@aklaver.com
) 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
to 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 determi
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
to 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
subdirectory "base/1" is missing.
Previous connection kept
postgres=#
With Regards,
Ajay Kajla
--
Adrian Klaver
adrian.kla...@aklaver.com
for
an internal auditing purpose.
Thanks.
*/Warm regards,/**/
M Sonai Muthu Raja
--
Adrian Klaver
adrian.kla...@aklaver.com
ypes |
Type
+-+---+---+--
public | upc_check_digit | character varying | upc character varying |
func
(1 row)
regards, tom lane
--
Adrian Klaver
adrian.kla...@aklaver.com
ng volatility, parallel safety, owner, security
classification, access privileges, language, source code and description.
--
Adrian Klaver
adrian.kla...@aklaver.com
ied 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
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
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
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_threshold_mono('a'::text
ublic and all is well. Do I
need to add that to the installer script?
--
Adrian Klaver
adrian.kla...@aklaver.com
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-structures.ht
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
0 LOOP
respectively.
Why is the three period form allowed through and why does it produce no
result?
--
Adrian Klaver
adrian.kla...@aklaver.com
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
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
://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
mechanisms failed.
This makes me logical replication more appealing.
Laurent
--
Adrian Klaver
adrian.kla...@aklaver.com
disabled(if that is possible) and see if it completes.
Richard
--
Adrian Klaver
adrian.kla...@aklaver.com
enied: A process has requested
access to an object but has not been granted those access rights",
happening after a previous dump file had been successfully saved in the
same location.
Richard
--
Adrian Klaver
adrian.kla...@aklaver.com
up PowerShell script (which calls pg_dump).
Is either one of those directories where the dump file is being output to?
If not is the directory that file is being created in have AV checks
disabled?
--
Adrian Klaver
adrian.kla...@aklaver.com
Regards,
David
--
Adrian Klaver
adrian.kla...@aklaver.com
description there is no chance for an answer more detailed then; as long
as it takes.
Regards,
David
--
Adrian Klaver
adrian.kla...@aklaver.com
On 3/31/22 23:48, Daniele Varrazzo wrote:
On 3/31/22 18:22, Daniele Varrazzo wrote:
Are arm packages available at all? If so, what is the right procedure
to install them?
On Fri, 1 Apr 2022 at 06:07, Adrian Klaver wrote:
From here:
https://apt.postgresql.org/pub/repos/apt/dists/
I see
_focus=true#step:6:247
--
Adrian Klaver
adrian.kla...@aklaver.com
red by touching data in B.
An UPDATE in Postgres is essentially a DELETE of the old row version and
an INSERT of the new row version. I'm going to guess the INSERT of the
new row version fires the FK triggers on B.
--
Adrian Klaver
adrian.kla...@aklaver.com
with new IDs' actually does?
And then the new occuring step, in the same transaction, which then also
has shown the performance issues described if i would not remove the FK
temporarily:
ALTER TABLE "B" DROP CONSTRAINT "B_to_A_fkey";
UPDATE "B" SET type = 2 WHERE type ISNULL;
ALTER TABLE "B" ADD CONSTRAINT "B_to_A_fkey" FOREIGN KEY (ref_a)
REFERENCES A(id);
**
--
Adrian Klaver
adrian.kla...@aklaver.com
n't need the VERBOSE.
----
*From:* Adrian Klaver
*Sent:* Monday, March 28, 2022 17:59
*To:* Per Kaminsky ;
pgsql-gene...@postgresql.org ; Tom Lane
*Subject:* Re: Performance issues on FK Triggers after replacing a
primary column
On 3/28/22 08:47
rect table with the new values,
and then removed, it has no connection (FK or something else) to any
other table.
So that is the '// fill id_temp with new IDs' part?
--
Adrian Klaver
adrian.kla...@aklaver.com
about indexes on the tables(s). Also, which one
of the tables you showed is the temporary one or was that not shown?
to make a rollback on any problem without causing an abnormal data state
regarding the program.
--
Adrian Klaver
adrian.kla...@aklaver.com
Sincerely, Per Kaminsky
--
Adrian Klaver
adrian.kla...@aklaver.com
On 3/21/22 15:43, McDermott, Becky wrote:
Version 12.7
And the JDBC version?
-Original Message-
From: Adrian Klaver
Sent: Monday, March 21, 2022 4:25 PM
To: McDermott, Becky ; pgsql-general@lists.postgresql.org
Subject: [EXTERNAL] Re: Can you install/run postgresql on a FIPS
googling. If anyone has any guidance or has gotten this to work, that
would be most helpful.
Thank you,
*Becky McDermott*
--
Adrian Klaver
adrian.kla...@aklaver.com
this by now):
1) Postgres version
2) Definition of red flags?
3) How do you observe the tables locked?
4) The results of the process you use in 3)
Regards,
David
--
Adrian Klaver
adrian.kla...@aklaver.com
abnormally and possibly corrupted shared memory.
Deepak Menon| Avaya Managed Services-Delivery|+91 9899012875| men...@avaya.com
Leave Alert :
--
Adrian Klaver
adrian.kla...@aklaver.com
res 12 version of pg_restore to restore it to the
Postgres 12 server.
Thanks & Regards
Pranjal Shukla
On 3/14/22, 8:25 PM, "Adrian Klaver" wrote:
On 3/14/22 06:39, Shukla, Pranjal wrote:
> Hello,
>
> We tried importing into an
DING 'UTF8' LC_COLLATE 'C' LC_CTYPE 'C'
TEMPLATE template0;/
*Thanks & Regards*
*Pranjal Shukla*
--
Adrian Klaver
adrian.kla...@aklaver.com
d an issue by anyone?
I'm not following what you are asking or trying to achieve. For instance
how pg_my_temp_schema() fits into this? You will need to provide a more
complete description of what it is you are doing.
--
Adrian Klaver
adrian.kla...@aklaver.com
ONSISTENCY
regards, tom lane
--
Adrian Klaver
adrian.kla...@aklaver.com
this problem? Should I use the dnf to install the
'postgresql-server' or just add some path to the environment variable?
My system is Fedora 35 and the PostgreSQL version is 14.
Thanks in advance!
--
Adrian Klaver
adrian.kla...@aklaver.com
was set up by another department.
Any suggestions on why that is happening and how to prevent it would be
appreciated.
Thanks,
Torsten
--
Adrian Klaver
adrian.kla...@aklaver.com
tablished by experiment that you can repeat "alter
--
Adrian Klaver
adrian.kla...@aklaver.com
1101 - 1200 of 4188 matches
Mail list logo