the expected
output.
--
Adrian Klaver
adrian.kla...@aklaver.com
ld be immensely
helpful.
Thank you very much for your time and assistance.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 11/22/23 10:01 AM, Adrian Klaver wrote:
On 11/22/23 9:55 AM, Andreas Kretschmer wrote:
Am 22.11.23 um 18:44 schrieb Atul Kumar:
I am giving this command
psql -d postgres -U postgres -p 5432 -h localhost
Then only I get that error.
so localhost resolved to an IPv6 - address
e with ipv4 address
Andreas
>
>
> I don;t get that error while using the above two commands.
>
>
> Regards.
>
>
> On Wed, Nov 22, 2023 at 10:45 PM Adrian Klaver
> wrote:
>
> On 11/22/23 09:03, Atul Kumar wrote:
On 11/22/23 9:55 AM, Andreas Kretschmer wrote:
Am 22.11.23 um 18:44 schrieb Atul Kumar:
I am giving this command
psql -d postgres -U postgres -p 5432 -h localhost
Then only I get that error.
so localhost resolved to an IPv6 - address ...
Yeah, you should take a look at:
/etc/hosts
In
ass the hostname or ip of the
server it works fine without any issue.
Regards.
--
Adrian Klaver
adrian.kla...@aklaver.com
this to
the PG-developer group :-)
Thanks,
Efrain J. Berdecia
--
Adrian Klaver
adrian.kla...@aklaver.com
ket connections only
local all all scram-sha-256
# IPv4 local connections:
host all postgres 127.0.0.1/32 <http://127.0.0.1/32> scram-sha-256
What I am missing here, please suggest.
Regards,
Atul
--
Adrian Klaver
adrian.kla...@aklaver.com
st version.
Also I'm thinking that using the latest version of pg_dump/pg_restore
allows you to have more options.
thx
Dick Visser
--
Adrian Klaver
adrian.kla...@aklaver.com
On 11/17/23 10:30 AM, Gabriel Sánchez wrote:
Dear Postgres community,
I'm seeing unintuitive behavior with a query structured as follows:
WITH used_cte (SELECT a, b, c FROM t1 ...)
, unused_cte (SELECT d, e, f FROM t2 ...)
SELECT * FROM used_cte ...
-- returns no results
WITH used_cte (SELECT
elname | cell_per
last_analyze | 2023-11-17 08:11:18.614987-08
commit;
select relname, last_analyze from pg_stat_user_tables where relname =
'cell_per';
-[ RECORD 1 ]+--
relname | cell_per
last_analyze | 2023-11-17 08:13:02.969537-08
Regards
--
Paulo Silva mailto:paulo...@gmail.com>>
--
Adrian Klaver
adrian.kla...@aklaver.com
not happening.
--
Adrian Klaver
adrian.kla...@aklaver.com
t;Source data.Account Description",
bracs."Source data.BRACS Account",
bracs."Source data.BRACS Account Description",
bracs."Source data.IS/BS",
bracs."Source data.Classification",
bracs."Source data.Function",
On 11/13/23 08:45, Adrian Klaver wrote:
On 11/12/23 23:02, Anthony Apollis wrote:
Please advice. I brought in data from SAP and assigned unique primary
key to the table:
I joined it with a dimension table.
Joining code
fact."IMETA_ZTRB_MP$F_ZTBR_TA_BW"ASfact
L
hat there are multiple account numbers in the
table then it is no surprise that the "ZTBR_TransactionCode" is repeated.
Please advice.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 11/11/23 17:20, p...@pfortin.com wrote:
On Sat, 11 Nov 2023 17:10:29 -0800 Adrian Klaver wrote:
Actually, it's more eusbtle... I can make it work as "postgres"; but not
as a RO user (SELECT only):
An error occurred when executing the SQL command:
select * from a,b where
On 11/11/23 17:04, p...@pfortin.com wrote:
On Sat, 11 Nov 2023 16:53:01 -0800 Adrian Klaver wrote:
On 11/11/23 16:25, p...@pfortin.com wrote:
Reply to list also
Ccing list
On Sat, 11 Nov 2023 16:16:20 -0800 Adrian Klaver wrote:
Probably because it is spelled regexp_replace ().
OK
On 11/11/23 16:25, p...@pfortin.com wrote:
Reply to list also
Ccing list
On Sat, 11 Nov 2023 16:16:20 -0800 Adrian Klaver wrote:
Probably because it is spelled regexp_replace ().
OK, found it in pg_catalog; but "create extension regexp_replace;" won't
load it. How do I ge
functions in /usr/share/postgresql/extension
Thanks,
Pierre
--
Adrian Klaver
adrian.kla...@aklaver.com
On 11/9/23 09:18, Thiemo Kellner wrote:
Hi all
I am afraid, I have not understood the rule system yet.
With a few exceptions nobody does. Use triggers instead.
--
Adrian Klaver
adrian.kla...@aklaver.com
nstall the postgres with above mentioned points ?
Can I create the installer for the PostgreSQL-14.0 version ?
Or can I get similar like installer for 14.0 of PostgreSQL ?
Regards,
Shashikanth
--
Adrian Klaver
adrian.kla...@aklaver.com
On 11/3/23 10:54 AM, Bruce Momjian wrote:
On Fri, Nov 3, 2023 at 10:44:12AM -0700, Adrian Klaver wrote:
On 11/3/23 10:40 AM, shashidhar Reddy wrote:
Hello All,
I have a Postgresql function scheduled to run on the database, some tines
it is taking too long than usual time, is
On 11/3/23 10:44 AM, Adrian Klaver wrote:
On 11/3/23 10:40 AM, shashidhar Reddy wrote:
Hello All,
I have a Postgresql function scheduled to run on the database, some
tines it is taking too long than usual time, is it possible to get
the execution plan of this function or any other way to
On 11/3/23 10:40 AM, shashidhar Reddy wrote:
Hello All,
I have a Postgresql function scheduled to run on the database, some
tines it is taking too long than usual time, is it possible to get the
execution plan of this function or any other way to troubleshoot
You might to take a look at th
On 10/30/23 10:45 AM, Atul Kumar wrote:
Hi,
I have postgres version 12 running on centos 7.
I found an entry in my pg_hba.conf entry as given below under IPV4
connections:
host all all /0 md5
I could not understand the meaning of "/0" here.
as I know that each IPV4 there are total 4
thought I saw the WB
author post on this list recently...
hp
--
Adrian Klaver
adrian.kla...@aklaver.com
really a disk issue. What happens if you use psql as the client?
--
Adrian Klaver
adrian.kla...@aklaver.com
r of the
name is treated as a regular expression. (See Section 9.7.3.1 for
details of PostgreSQL's regular expression syntax.)
A separate file containing database names and/or regular
expressions can be specified by preceding the file name with @.
"
Regards.
--
Adrian Klaver
adrian.kla...@aklaver.com
version.
2) OS and version.
3) Define 'difficulties' with:
a) Commands used.
b) Error messages received.
Very Respectfully
Yong
--
Adrian Klaver
adrian.kla...@aklaver.com
ry is run every time the view is
referenced in a query."
Would views automatically run, when you start the PgAmin?
See above. The view query will not execute until specifically asked for
and nothing I have seen in my limited use of pgAdmin does that
automatically.
Regards,
Davi
27;[2023-10-25 14:33:00, 2023-10-25 15:56:00)'::TSTZRANGE;
tstzrange
---
["10/25/2023 14:33:00 PDT","10/25/2023 15:56:00 PDT")
per:
https://www.postgresql.org/docs/current/rangetypes.html#RA
msg.df7cb.de
--
Поздрави,
Момчил Милев
momchil.mi...@gmail.com <mailto:momchil.mi...@gmail.com>
Greetings
Momchil Milev
momchil.mi...@gmail.com <mailto:momchil.mi...@gmail.com>
PPlease consider the impact on the environment before printing this e-mail
--
Adrian Klaver
adrian.kla...@aklaver.com
On 10/23/23 14:55, p...@pfortin.com wrote:
Please reply to list also.
Ccing the list for this post.
On Mon, 23 Oct 2023 12:44:56 -0700 Adrian Klaver wrote:
On 10/23/23 11:54, p...@pfortin.com wrote:
Hi,
I have a 1.6TB database with over 330 tables on a 4TB NVMe SSD. All
tables are static
took about a second), restarted PG and the problem persists...
Any suggestions where to look next?
Thanks,
Pierre
--
Adrian Klaver
adrian.kla...@aklaver.com
is that this is
the Wiki and you can sign up to edit it.
Thanks!
[1]
https://www.postgresql.org/docs/16/ddl-inherit.html#DDL-INHERIT-CAVEATS
--
Adrian Klaver
adrian.kla...@aklaver.com
tions to a database, so the same risks as any other
client that does the same thing.
TIA,
--
Adrian Klaver
adrian.kla...@aklaver.com
posted:
"pgAgent is available as a StackBuilder add-on package if you use EDB's
Installers for Windows. "
Thanks
Bin
--
Adrian Klaver
adrian.kla...@aklaver.com
ich are seen in the t2 transaction but not in the t1 session.
My suggestion would be to read through this:
https://www.postgresql.org/docs/current/transaction-iso.html
several times. There is a lot going on there.
Thanks in advance!
Yours,
Wen Yi
--
Adrian Klaver
adrian.kla...@aklaver.com
causing the issue.
4) Post relevant sections from the Postgres log.
Regards,
David
--
Adrian Klaver
adrian.kla...@aklaver.com
tps://wiki.postgresql.org/wiki/Locale_data_changes
Changing distro's mid stream increases the likely hood there will be issues.
--
Adrian Klaver
adrian.kla...@aklaver.com
https://www.postgresql.org/docs/current/runtime-config-logging.html
and then see what is set in the standby postgresql.conf.
Regards.
--
Adrian Klaver
adrian.kla...@aklaver.com
to get an answer, so share away.
Also include the report information from addresssanitizer.
Regards,
Sasmit Utkarsh
+91-7674022625
--
Adrian Klaver
adrian.kla...@aklaver.com
;t seem to figure out where the issue is.
1) Verify that your client is not lying to you, use psql to see if there
is data in the table.
2) Look at the Postgres log to see what is happening. You would want
log_statement in postgresql.conf to be at least 'mod'.
--
Adrian Klaver
adrian.kla...@aklaver.com
.
sounds okay
Nah. "The programmer -- and DBA -- on the Clapham omnibus" quite
reasonably expects that COPY table_name TO (output)" copies all the
columns listed in "\d table_name".
Yeah, I would agree.
--
Born in Arizona, moved to Babylonia.
--
Adrian Klaver
adrian.kla...@aklaver.com
riction" is there another file that contains it?
On Oct 3, 2023, at 2:27 PM, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
External Email
On 10/3/23 10:32, Johnson, Bruce E - (bjohnson) wrote:
I am trying to import an oracle schema with ora2pg and running into
an
been rewritten to its original from.
I know that I modified the correct file.
It happens even if I drop the database and recreate it.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
--
Adrian K
it being
too much.
David J.
--
Adrian Klaver
adrian.kla...@aklaver.com
. You might
want to check them out to see if they work better for your tasks:
pg_cron
https://github.com/citusdata/pg_cron
pg_timetable
https://pg-timetable.readthedocs.io/en/master/
--
Adrian Klaver
adrian.kla...@aklaver.com
On 9/30/23 14:54, p...@pfortin.com wrote:
On Sat, 30 Sep 2023 13:40:37 -0700 Adrian Klaver wrote:
On 9/30/23 11:32, p...@pfortin.com wrote:
As I told Tom, the "test" DB has this issue; the production and test1 DBs
are fine; I should have thought to check those first... Sorry for
Thanks for confirming my simple SQL runs...
regards, tom lane
Thanks Tom!
--
Adrian Klaver
adrian.kla...@aklaver.com
On 9/30/23 07:01, p...@pfortin.com wrote:
Hi Adrian,On Fri, 29 Sep 2023 14:27:48 -0700 Adrian Klaver wrote:
On 9/29/23 1:37 PM, p...@pfortin.com wrote:
Hi,
I'm going to say it is the
( -- import only a subset of columns
I suspect the -- comment is the issue.
I wish it was that
On 9/29/23 1:37 PM, p...@pfortin.com wrote:
Hi,
select version();
PostgreSQL 15.4 on x86_64-mageia-linux-gnu,
compiled by gcc (Mageia 12.3.0-3.mga9) 12.3.0, 64-bit
As a test, rather than use INSERT, I recently wrote a python test script
to import some 8M & 33M record files with COPY instead.
essfully, and continue.
Ignore - Ignore the error, and continue.
"
So in the first step induce an error if the conditions are not met.
--
best regards
--
Adrian Klaver
adrian.kla...@aklaver.com
On 9/26/23 13:29, Adrian Klaver wrote:
On 9/26/23 12:30, Ron wrote:
On 9/26/23 13:15, Tom Lane wrote:
Ron writes:
On 9/26/23 12:46, Tom Lane wrote:
I'm not really sure what functionality you think is missing from RETURNS
TABLE, granting that you do want to return a set of rows an
some other logic in the body of the FOR loop that is not
practical to embed in the body of the SELECT statement.
I think you are conflating RETURNS TABLE and RETURN QUERY. You can build
a 'TABLE' from variables outside of a query.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 9/26/23 11:31 AM, Atul Kumar wrote:
Hi,
I have a query about parameters and log_statement
my postgres version is 12 and running on centos 7
my log_statement is set to "DDL".
and log_min_duration_statement is set to "1ms"
so technically it should log "ONLY DDLs" that take more than 1ms.
On 9/26/23 11:03 AM, Ron wrote:
On 9/26/23 12:46, Tom Lane wrote:
Ron writes:
Is there a way to define the SETOF record on the fly, like you do with
RETURNS TABLE (f1 type1, f2 type2)?
Doesn't RETURNS TABLE meet the need already?
That rationale means that RETURN SETOF is not needed, and ca
On 9/25/23 19:30, shashidhar Reddy wrote:
Thank you Adrian! I will apply the patch and see.
Just to be clear 11.21 represents the changes from 16 different minor
releases.
--
Adrian Klaver
adrian.kla...@aklaver.com
h is already 4 years old.
[1]
https://www.postgresql.org/docs/11/runtime-config-statistics.html#GUC-TRACK-ACTIVITY-QUERY-SIZE
<https://www.postgresql.org/docs/11/runtime-config-statistics.html#GUC-TRACK-ACTIVITY-QUERY-SIZE>
--
Erik
--
Adrian Klaver
adrian.kla...@aklaver.com
pg_hba.conf looks like:
host all all 192.168.1.0/24 <http://192.168.1.0/24>
password
I can't see what else I'm missing.
--
Adrian Klaver
adrian.kla...@aklaver.com
that when you refer to Ubuntu 18 and 20 you mean 18.04
LTS and 20.04 LTS. Is that correct?
2) What Postgres version?
3) What did you try?
--
Adrian Klaver
adrian.kla...@aklaver.com
On 9/20/23 10:59 AM, Harry Green wrote:
Thank you Laurenz for your answer,
I have done a complete pg_dump and complete restore, and tried all
forms of complete pg_dumps and restores (i.e. the different formats).
There is no partial or tables only or data only dumping or restoring.
Further, yo
provide a simplified version of what you are trying to achieve.
--
Adrian Klaver
adrian.kla...@aklaver.com
without ssl. I am not sure why it
tried twice.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
--
Adrian Klaver
adrian.kla...@aklaver.com
versity of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
--
Adrian Klaver
adrian.kla...@aklaver.com
On 9/18/23 08:16, Adrian Klaver wrote:
On 9/18/23 08:08, Harry Green wrote:
Hello,
I am having trouble restoring a database backed up with
pg_dump/pg_dump_all. The error messages I get are below and appear to
suggest that certain sql-language or pl/pgsql-language functions which
include an
the restore does not work because the relations are
created in the wrong order. Any ideas how I can solve it?
Please see the error message below:
Thanks a lot!
--
Adrian Klaver
adrian.kla...@aklaver.com
On 9/15/23 9:55 AM, Martin Mueller wrote:
I am thinking of upgrading from version 13 to version 16.
I think I can do this by leaving the data alone and just replacing the
software. My data are extremely simple and consist of several hundred
No you can't.
You will need to either use pg_up
Admin-support list:
https://www.postgresql.org/list/pgadmin-support/
--
Adrian Klaver
adrian.kla...@aklaver.com
specified as equals in the where clause.
--
Adrian Klaver
adrian.kla...@aklaver.com
.
I'm thinking you would be better off doing a pg_dumpall of the old
cluster and psql -f dump_file.sql on the new
cluster per:
https://www.postgresql.org/docs/current/app-pg-dumpall.html
--
Adrian Klaver
adrian.kla...@aklaver.com
g or
validating non-ASCII characters."
Thanks,
Graeme
--
Adrian Klaver
adrian.kla...@aklaver.com
On 9/11/23 09:33, Graeme wrote:
On 11/09/2023 17:13, Adrian Klaver wrote:
On 9/11/23 09:04, Graeme wrote:
Preparing to upgrade my small cluster from Mageia 8/Pg 9 to Mageia
9/Pg 15. I'm at the point of running pg_upgrade but have received
anerror message:
You are going to have to be
o.1.1*
-r-xr-xr-x 1 root root 442424 Feb 27 2021 libssl.so.1.0.0*
-rwxr-xr-x 1 root root 666496 Jun 1 09:36 libssl.so.1.1*
Can someone suggest my next move please?
Ta
Graeme Gemmill
--
Adrian Klaver
adrian.kla...@aklaver.com
is a function that
has return value and that is what you are seeing.
Thank you,
Laszlo
--
Adrian Klaver
adrian.kla...@aklaver.com
ting of the dump file to remove syntax not understood by the
older server. Use of the --quote-all-identifiers option is recommended
in cross-version cases, as it can prevent problems arising from varying
reserved-word lists in different PostgreSQL versions."
Thank you,
Laszlo
--
Adrian Klaver
adrian.kla...@aklaver.com
in *postgresql.conf*
#temp_tablespaces = '' # a list of tablespace names, '' uses
# only default tablespace
#temp_file_limit = -1 # limits per-process temp file space
# in kilobytes, or -1 for no limit
What do you suggest?
cheers,
Enzopolo
--
Adrian Klaver
adrian.kla...@aklaver.com
listen_addresses (string)
vs
port (integer)
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
--
Adrian Klaver
adrian.kla...@aklaver.com
. See:
https://explainshell.com/explain?cmd=rm+-rf+%2Fdata
It explains why you don't get the /data content.
Jeremy
Jeremy Garniaux
https://mapper.fr
--
Adrian Klaver
adrian.kla...@aklaver.com
eption at runtime,
Maybe this?:
https://www.postgresql.org/docs/current/sql-do.html
"If DO is executed in a transaction block, then the procedure code
cannot execute transaction control statements. Transaction control
statements are only allowed if DO is executed in its own transaction."
David J.
--
Adrian Klaver
adrian.kla...@aklaver.com
will not accept it.
--
Adrian Klaver
adrian.kla...@aklaver.com
tabase'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname =
'jme_test_database')\gexec);**
\gexec is a psql specific meta-command.
See Meta-Commands here:
https://www.postgresql.org/docs/current/app-psql.html
Any help would be very much appreciated.
Thanks in
is question for Azure tech support. Contact them.
Thanks,
Sai
--
Adrian Klaver
adrian.kla...@aklaver.com
On 8/28/23 13:19, Alan Stange wrote:
On 8/28/23 16:11, Adrian Klaver wrote:
On 8/28/23 13:06, Alan Stange wrote:
All,
Are you sure that is coming from autovacuum?
What are the log lines preceding the WARNING?
What is the complete warning line?
Thank you for your quick response.
The
d to
these same warnings.
So, I'm wondering how we can move the superuser role from role A to B,
so that the autovacuum process will still work? I googled around a
bit, but didn't come up with anything useful for this.
Thank you,
Alan
--
Adrian Klaver
adrian.kla...@aklaver.com
de us download links for oracle_fdw for psql (PostgreSQL)
9.4.24. ..."
1) Are you on 9.2 or 9.4?
2) Where did you get Postgres from?
--
Adrian Klaver
adrian.kla...@aklaver.com
rules and regulations.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 8/21/23 09:31, Rihad wrote:
On 8/21/23 20:17, Adrian Klaver wrote:
On 8/21/23 09:09, Rihad wrote:
On 8/21/23 20:00, Adrian Klaver wrote:
Sorry, they are all as per default, commented out in the config.
There are no long running queries, otherwise they wouldn't be
vacuumed/ana
ed and if it is not at this
point(Beta) it will not be in the production release.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 8/21/23 09:09, Rihad wrote:
On 8/21/23 20:00, Adrian Klaver wrote:
Thanks for the detailed reply, no tables have custom settings.
I need to make it clear once again that all autovac/analyze work as
expected when n_live_tup matches reality, i.e. when analyze has been run
on them since
On 8/20/23 22:31, Rihad wrote:
On 8/21/23 00:15, Adrian Klaver wrote:
On 8/20/23 12:10, Rihad wrote:
On 8/20/23 20:22, Adrian Klaver wrote:
On 8/18/23 22:35, Rihad wrote:
On 8/17/23 13:01, rihad wrote:
Hard to say without seeing the actual settings in postgresql.conf that
match
orcing the server to use either
generic or custom plans, by setting plan_cache_mode to
force_generic_plan or force_custom_plan respectively. This setting is
primarily useful if the generic plan's cost estimate is badly off for
some reason, allowing it to be chosen even though its actual cost is
much more than that of a custom plan.
"
thank you
Edoardo
--
Adrian Klaver
adrian.kla...@aklaver.com
On 8/20/23 12:10, Rihad wrote:
On 8/20/23 20:22, Adrian Klaver wrote:
On 8/18/23 22:35, Rihad wrote:
On 8/17/23 13:01, rihad wrote:
Hi, all. After calling pg_stat_reset all statistics used by
autovacuum got zeroed, and started accumulating from scratch. Some
tables get acted upon properly
les having only 60-70 (not 60-70K) n_live_tup
that have had autovacuum run on them. Weird.
--
Adrian Klaver
adrian.kla...@aklaver.com
active.
Regards, Bryn Llewellyn
--
Adrian Klaver
adrian.kla...@aklaver.com
) Describe the upgrade process
2) Describe the data problems.
Has anyone met similar issues? Compatibility of data files?
Thanks
Danny
--
Adrian Klaver
adrian.kla...@aklaver.com
original value in the user column is "me", what is the difference between "set
other_column = some_value, user = 'me'" and "set other_column = some_value" at the business
level?
Affirmation that the user updating the record explicitly set the user value.
--
Adr
ot;me", what is the difference
between "set other_column = some_value, user = 'me'" and "set
other_column = some_value" at the business level?
Affirmation that the user updating the record explicitly set the user value.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 8/15/23 13:52, Rob Sargent wrote:
On 8/15/23 12:57, Adrian Klaver wrote:
On 8/15/23 11:43, Rob Sargent wrote:
On 8/15/23 12:38, Adrian Klaver wrote:
On 8/15/23 08:08, Jason Long wrote:
Hello,
Does PostgreSQL have a graphical environment for management or is
it only managed through CLI
On 8/15/23 11:43, Rob Sargent wrote:
On 8/15/23 12:38, Adrian Klaver wrote:
On 8/15/23 08:08, Jason Long wrote:
Hello,
Does PostgreSQL have a graphical environment for management or is it
only managed through CLI?
There are, but make your life easier and learn to use psql:
https
601 - 700 of 3990 matches
Mail list logo