ine:
def install
ENV.prepend "LDFLAGS", "-L#{Formula["openssl@1.1"].opt_lib}
-L#{Formula["readline"].opt_lib}"
ENV.prepend "CPPFLAGS", "-I#{Formula["openssl@1.1"].opt_include}
-I#{Formula["readline"].opt_include}&q
-archive.org/PostgreSQL-general-f1843780.html
--
Adrian Klaver
adrian.kla...@aklaver.com
of 103309156
sides=> select employer_response_id, part_date
from strans.employer_response_p2021_01
where amended_response_id = 103309154;
employer_response_id | part_date
--+-----
103309156 | 2021-01-06 00:00:00
(1 row)
--
Adrian Klaver
adrian.kla...@aklaver.com
b.com <http://www.mokadb.com>
--
Adrian Klaver
adrian.kla...@aklaver.com
On 2/15/21 8:23 AM, Ron wrote:
On 2/15/21 10:17 AM, Adrian Klaver wrote:
On 2/15/21 8:12 AM, Ron wrote:
Postgresql 12.5
The error:
DETAIL: Key (amended_response_id, part_date)=(103309154, 2021-01-06
00:00:00) is not present in table "employer_response"
is pointing at 103
On 2/15/21 8:55 AM, Ron wrote:
On 2/15/21 10:27 AM, Adrian Klaver wrote:
On 2/15/21 8:23 AM, Ron wrote:
On 2/15/21 10:17 AM, Adrian Klaver wrote:
On 2/15/21 8:12 AM, Ron wrote:
Postgresql 12.5
The error:
DETAIL: Key (amended_response_id, part_date)=(103309154, 2021-01-06
00:00:00
rrent_date
-
2021-02-15 00:00:00
In other words turned a date into a timestamp.
--
Angular momentum makes the world go 'round.
--
Adrian Klaver
adrian.kla...@aklaver.com
The resend option does work, but you have to wait 30 seconds between
messages, and I like to have the entire thread as it makes it easier to
follow.
Regards,
--
Thomas
--
Adrian Klaver
adrian.kla...@aklaver.com
gres$# end;
postgres$# $$ language plpgsql;
ERREUR: erreur de syntaxe sur ou près de « execute »
LIGNE 2 : execute moninsert(randname());
fine, quite coherent.
then
--
Adrian Klaver
adrian.kla...@aklaver.com
, so presumably if a "goroutine" dies, the
associated PG process would die too, but I'm not sure I grasp why that
would cause a recovery/restart. I also don't understand where the
checkpointer process fits in the picture (and what would cause it to die).
For the record, this is on PG 11.9 running on Debian.
TIA,
Joe
--
Adrian Klaver
adrian.kla...@aklaver.com
On 2/15/21 1:50 PM, Joe Abbate wrote:
On 15/2/21 16:29, Adrian Klaver wrote:
On 2/15/21 1:15 PM, Joe Abbate wrote:
We've been experiencing PG server process crashes about every other
week on a mostly read only website (except for a single insert/update
on page access). Typical log en
stgres version 13
Can you tell me what am I missing?
Without the commands you used to do the dump and restore it will be
difficult to come to any conclusions. It would also be helpful to look
at the Postgres logs from the restore to see if there are any error
messages.
Thank you for your help.
Santosh
--
Adrian Klaver
adrian.kla...@aklaver.com
ust did -Fc.
2) Big explicit in your dump and restore commands for -h(ost), -p(ort)
and -U(ser). I suspect you may not be restoring to where you think you are.
3) Closely follow the progress of both the dump and the restore.
--
Adrian Klaver
adrian.kla...@aklaver.com
k
on it further. Thanks for your suggestions.
pgAdmin uses pg_dump to do backups.
--
Adrian Klaver
adrian.kla...@aklaver.com
23, 2021 at 7:27 AM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 2/23/21 6:36 AM, Santosh Udupi wrote:
> The pg_restore command is actually pg_restore -Ft -d mydb
mydb.tar (my
> mistake).
>
> I didn't provide the -h -p -U
pg_dump (PostgreSQL v13.2 on Ubuntu 20.04) version 13.2
Hmm ... well, that would be a regression, but you're going to have
to show us how to reproduce it. I'm thinking there must be something
odd about the way the table is declared.
regards, tom lane
--
Adrian Klaver
adrian.kla...@aklaver.com
ore database do
they look the same as below? If you drop the table in the problem
database and then recreate it using the script below and then populate
it with data does it work?
On Tue, Feb 23, 2021 at 12:20 PM Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
On 2/23
), rsync it to the
destination server and then do the pg_restore on the server.
--
Adrian Klaver
adrian.kla...@aklaver.com
is also true of bits of the core server, actually.)
Extensions you get from elsewhere might have different copyrights
though.
regards, tom lane
--
Rumpi Gravenstein
--
Adrian Klaver
adrian.kla...@aklaver.com
ask scheduler on every 10 minutes. Error
occurs only sometimes.
There is no other process inserting to this table?
--
Adrian Klaver
adrian.kla...@aklaver.com
remain.
I'm not understanding the above.
Andrus.
--
Adrian Klaver
adrian.kla...@aklaver.com
This table should contain last login time, user and ip address. It
should be updated by every process on login. For this old entry is
removed if it exists and new entry with same primary key is added.
Andrus.
--
Adrian Klaver
adrian.kla...@aklaver.com
'INSERT'),and these statements executed
successfully.
So how to solve 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
BLE-CONSISTENCY
regards, tom lane
--
Adrian Klaver
adrian.kla...@aklaver.com
would it be considered 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
ENCODING 'UTF8' LC_COLLATE 'C' LC_CTYPE 'C'
TEMPLATE template0;/
*Thanks & Regards*
*Pranjal Shukla*
--
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 empty database i
rmally and possibly corrupted shared memory.
Deepak Menon| Avaya Managed Services-Delivery|+91 9899012875| men...@avaya.com
Leave Alert :
--
Adrian Klaver
adrian.kla...@aklaver.com
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
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
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
much.
Sincerely, Per Kaminsky
--
Adrian Klaver
adrian.kla...@aklaver.com
are part of one big transaction to be able
Analyze can be run by itself in the transaction. As Tom said I am not
seeing any information 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
ect 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
ly don'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
id_temp 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
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
_focus=true#step:6:247
--
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
description there is no chance for an answer more detailed then; as long
as it takes.
Regards,
David
--
Adrian Klaver
adrian.kla...@aklaver.com
Regards,
David
--
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
ed: 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
disabled(if that is possible) and see if it completes.
Richard
--
Adrian Klaver
adrian.kla...@aklaver.com
e ext4 recovery mechanisms failed.
This makes me logical replication more appealing.
Laurent
--
Adrian Klaver
adrian.kla...@aklaver.com
://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
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
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
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
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
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
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
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
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
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
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
n, including volatility, parallel safety, owner, security
classification, access privileges, language, source code and description.
--
Adrian Klaver
adrian.kla...@aklaver.com
| 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
r
an internal auditing purpose.
Thanks.
*/Warm regards,/**/
M Sonai Muthu Raja
--
Adrian Klaver
adrian.kla...@aklaver.com
e database subdirectory "base/1" is missing.
Previous connection kept
postgres=#
With Regards,
Ajay Kajla
--
Adrian Klaver
adrian.kla...@aklaver.com
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
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
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
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
s creating the .backup file ..."
What are the actual commands you are using to do the above?
Richard
--
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
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
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
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
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
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
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
-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
d how
is it managed?
Regards,
Ram Pratap.
--
Adrian Klaver
adrian.kla...@aklaver.com
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
5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B
--
Adrian Klaver
adrian.kla...@aklaver.com
: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
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
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
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
ta_changes
Thank you for your help.
Best regards,
Pradeep
--
Adrian Klaver
adrian.kla...@aklaver.com
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
character.
What client are you using to run this?
Where is the query string coming from?
TIA,
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.
ax, somewhere since this morning you introduced a
hidden character into the string.
Thanks,
Rich
--
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
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
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
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
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
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
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
-table '*."AspNet*"'
* --exclude-table'*."AspNet*"'
--------
--
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
--
.
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
:
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
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
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
& Regards
Neeraj
--
Adrian Klaver
adrian.kla...@aklaver.com
any of the
other system catalogs.
--
Adrian Klaver
adrian.kla...@aklaver.com
2001 - 2100 of 4937 matches
Mail list logo
