Re: PG 14.5 -- Impossible to restore dump due to interaction/order of views, functions, and generated columns

2022-12-06 Thread Adrian Klaver
going to say hiding the table/view reference in a function is not going to work any better then when folks try that in a CHECK constraint. Any insight is appreciated.  Please reply-all as I'm not currently subscribed to the list.  Thanks in advance! -- Adrian Klaver adrian.kla...@aklaver.com

Re: Q: error on updating collation version information

2022-12-04 Thread Adrian Klaver
n text Provider-specific version of the collation. This is recorded when the collation is created and then checked when it is used, to detect changes in the collation definition that could lead to data corruption. Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B --

Re: Stored procedure code no longer stored in v14 and v15, changed behaviour

2022-12-01 Thread Adrian Klaver
piggyback of that then great, but with the knowledge that the information may change to meet the needs of the server not external users. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Upgrading to v12

2022-11-28 Thread Adrian Klaver
-see-from-running-initdb#comment131694419_74607304 Brad was double clutching on the initdb. regards, tom lane -- Adrian Klaver adrian.kla...@aklaver.com

Re: Get table catalog from pg_indexes

2022-11-27 Thread Adrian Klaver
uot;draft" does not exist [/quote] Because the layout is catalog.schema.table so: SELECT 1 FROM draft.pg_catalog.pg_indexes; Just because this works don't leap to assumption that: .pg_catalog.pg_indexes will work. This only works with the current database name. Thank you/ David J. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Get table catalog from pg_indexes

2022-11-27 Thread Adrian Klaver
r words to filter the pg_index results by database/catalog name. Since pg_index is scoped to the database you are in when you do the query that is not going to happen. -- Angular momentum makes the world go 'round. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Get table catalog from pg_indexes

2022-11-27 Thread Adrian Klaver
er, not one per database." However, I think I can try "SELECT 1 FROM .pg_indexes...". Will this work? Thank you. [1] https://www.postgresql.org/docs/current/view-pg-indexes.html -- Erik -- Adrian Klaver adrian.kla...@aklaver.com

Re: [BeginnerQuestion]Why the postgres_fe.h not found?

2022-11-25 Thread Adrian Klaver
m/files-pri/T0FS7GCKS-F04CV4MB9ND/image.png> // <https://files.slack.com/files-pri/T0FS7GCKS-F04CV4MB9ND/download/image.png?origin_team=T0FS7GCKS> 6:55 <https://postgresteam.slack.com/archives/C0FS3UTAP/p1669373715852069> How can I solve this problem? Thanks in advance! -- Adrian Klaver adrian.kla...@aklaver.com

Re: Configure my pgadmin

2022-11-25 Thread Adrian Klaver
lhost" (::1), port 5432 failed: fe_sendauth: no password supplied * -- With kindest regards, William. ⢀⣴⠾⠻⢶⣦⠀ ⣾⠁⢠⠒⠀⣿⡁ Debian - The universal operating system ⢿⡄⠘⠷⠚⠋⠀ https://www.debian.org <https://www.debian.org> ⠈⠳⣄⠀⠀⠀⠀ -- Adrian Klaver adrian.kla...@aklaver.com

Re: Fwd: Change the auth. postgresql and GIS

2022-11-23 Thread Adrian Klaver
e Best Regards Nikola Lubenov -- Adrian Klaver adrian.kla...@aklaver.com

Re: Upgrading to v12

2022-11-22 Thread Adrian Klaver
On 11/22/22 12:53, Brad White wrote: On 11/18/2022 6:34 PM, Adrian Klaver wrote: On 11/18/22 16:05, Brad White wrote: --> The Microsoft Access database engine stopped the process because you and another user are attempting to change the same data at the same time. Code in quest

Re: system variable can be edited by all user?

2022-11-22 Thread Adrian Klaver
, Butching -- Adrian Klaver adrian.kla...@aklaver.com

Re: Seeking practice recommendation: is there ever a use case to have two or more superusers?

2022-11-21 Thread Adrian Klaver
on that authorizes as the bootstrap superuser that cannot be done by a session that authorizes as a regular superuser. I'll try to find out. Superuser is superuser, there is no magic associated with the bootstrap superuser. FYI, the answer is won't make a difference. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Seeking practice recommendation: is there ever a use case to have two or more superusers?

2022-11-21 Thread Adrian Klaver
tatement for a recommendation that only appeared at the same time? I for one have a poor record of mind reading and/or predicting the future:) -- Adrian Klaver adrian.kla...@aklaver.com

Re: Seeking practice recommendation: is there ever a use case to have two or more superusers?

2022-11-21 Thread Adrian Klaver
’m missing of the essential mental model in this general space. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Seeking practice recommendation: is there ever a use case to have two or more superusers?

2022-11-20 Thread Adrian Klaver
ke whatever action you desire on a database whose only usage stipulation is that you maintain a copy of the license. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Upgrading to v12

2022-11-18 Thread Adrian Klaver
st PostgreSQL 12.10, compiled by Visual C++ build 1914, 64-bit Succeeds against PostgreSQL 9.4.1, compiled by Visual C++ build 1800, 64-bit I don't see anything in the data\logs folder that looks relevant. Where else should I look? -- Adrian Klaver adrian.kla...@aklaver.com

Re: RES: RES: session_user different from current_user after normal login

2022-11-18 Thread Adrian Klaver
--+--+--- user1    | mydb   | role=group_read_only -- Adrian Klaver adrian.kla...@aklaver.com

Re: copy databases from two differend backups to one cluster

2022-11-18 Thread Adrian Klaver
directory. You can't, at the file(binary) level, just rip a database out of one cluster and graft it into another. If you want to do this then the options are: 1) As Ron suggested dump/restore. 2) Setting up logical replication. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Drop role cascade ?

2022-11-17 Thread Adrian Klaver
org/docs/current/sql-reassign-owned.html -- Adrian Klaver adrian.kla...@aklaver.com

Re: RES: session_user different from current_user after normal login

2022-11-17 Thread Adrian Klaver
configuration? I’m pretty sure that few configurations were made to this database. Is there a psqlrc file that has SET ROLE group_read_only;? See the: Files psqlrc and ~/.psqlrc section here: https://www.postgresql.org/docs/current/app-psql.html for more information. Murillo. -- Adrian

Re: session_user different from current_user after normal login

2022-11-17 Thread Adrian Klaver
user1; After that, it was possible to change the user password. My question is: is that a normal behavior? should I, after a normal loggin, be logged as group_read_only as my current_user? Something or someone is doing SET ROLE group_read_only. Thanks in advance. Murillo. -- Adrian Klaver

Re: PostgreSQL server "idle in transaction"

2022-11-16 Thread Adrian Klaver
On 11/16/22 12:51 AM, Matthias Apitz wrote: El día Dienstag, November 15, 2022 a las 10:28:11 -0500, Tom Lane escribió: Adrian Klaver writes: On 11/15/22 04:28, Matthias Apitz wrote: I have below the full ESQL/C log and do not understand, why the PostgreSQL server is thinking "

Re: Calling function from VFP changes character field to Memo

2022-11-15 Thread Adrian Klaver
unction_result as ... I'll try the type definition and see if that helps. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Calling function from VFP changes character field to Memo

2022-11-15 Thread Adrian Klaver
You could perhaps work around that by defining a named composite type: create type testfunction_result as (firstname character(30), ...); create function testfunction() returns setof testfunction_result as ... regards, tom lane -- Adrian Klaver adrian.kla...@aklaver.com

Re: Calling function from VFP changes character field to Memo

2022-11-15 Thread Adrian Klaver
returns as a Memo field (similar to a Text field). Any idea what I need to do to get it to return the character(30) type? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Calling function from VFP changes character field to Memo

2022-11-15 Thread Adrian Klaver
? END; $BODY$; And I call: SELECT * FROM public.testFunction(); SELECT firstname from FROM public.testFunction(); Then FirstName returns as a Memo field (similar to a Text field). Any idea what I need to do to get it to return the character(30) type? -- Adrian Klaver adrian.kla

Re: PostgreSQL server "idle in transaction"

2022-11-15 Thread Adrian Klaver
43: query: select name from pg_cursors where name = $1 ; with 1 parameter(s) on connection testdb So that query is being executed after the COMMIT. -- Adrian Klaver adrian.kla...@aklaver.com

Re: ON CONFLICT and WHERE

2022-11-13 Thread Adrian Klaver
On 11/13/22 13:07, Tom Lane wrote: Adrian Klaver writes: INSERT INTO books VALUES (12, 0, CURRENT_TIMESTAMP) ON CONFLICT (id) WHERE updated IS NULL OR updated + INTERVAL '2min' < CURRENT_TIMESTAMP DO UPDATE SET version = books.version + 1, updated = CURRENT_TIMESTAMP; I have not used WH

ON CONFLICT and WHERE

2022-11-13 Thread Adrian Klaver
ts. The question is why did the first case just ignore the WHERE instead of throwing a syntax error? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Upgrading to v12

2022-11-13 Thread Adrian Klaver
On 11/12/22 22:07, Tom Lane wrote: Ron writes: On 11/11/22 23:09, Adrian Klaver wrote: 2) For your explanation above, pg_dump from 9.4(5432) to pg_restore 12(5433) the issue would be ...\9.4\bin\pg_dump.exe of 9.4 and pg_restore of said dump file to version 12. When moving up in version you

Re: Upgrading to v12

2022-11-13 Thread Adrian Klaver
copies meant and where they came from. Not sure that this is actually pertinent to the problem at hand, I was just trying to nail down the moving pieces. I've since hijacked it and used it to restore to other versions. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Upgrading to v12

2022-11-11 Thread Adrian Klaver
On 11/11/22 20:59, Brad White wrote: On Fri, Nov 11, 2022, 9:57 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: Yes. The backup is from production. V9.4 is running on 5432 on all servers. That particular restore happens to be on the dev server. 5433 is v12. 1)

Re: Upgrading to v12

2022-11-11 Thread Adrian Klaver
abase on one cluster. The above though shows you restoring to different cluster(5433) then the cluster(5432) you dumped from. Also why "C:\Program Files\PostgreSQL\9.4\bin\pg_dump.exe vs $pgdir\pg_restore.exe ? Is pgdir different from "C:\Program Files\PostgreSQL\9.4\bin\ ? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Upgrading to v12

2022-11-11 Thread Adrian Klaver
On 11/11/22 14:06, Brad White wrote: > Can you do a pg_dump of that database? Yes. No visible problems. No errors reported. From your original post, what did "Not the half dozen restored copies" mean? In other words define the restore process. -- Adrian Klav

Re: Upgrading to v12

2022-11-11 Thread Adrian Klaver
Can you do a pg_dump of that database? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Upgrading to v12

2022-11-11 Thread Adrian Klaver
file "pg_clog/0015" at offset 73728: No error. -- Adrian Klaver adrian.kla...@aklaver.com

Re: pgadmin4 versions on Ubuntu 22.04

2022-11-10 Thread Adrian Klaver
<https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/focal> pgadmin4 main # disabled on upgrade to jammy will retry shortly. richard On Thu, 10 Nov 2022 10:58:12 -0500 *Adrian Klaver mailto:adrian.kla...@aklaver.com>>* wrote --- On 11

Re: pgadmin4 versions on Ubuntu 22.04

2022-11-10 Thread Adrian Klaver
for one.) What repo? Have you run apt update on the repo? What is the command you are using to do the upgrade? wondering when the repo might get updated, or whether i should be concerned about it at all. thanks,    richard -- Adrian Klaver adrian.kla...@aklaver.com

Re: "set role" semantics

2022-11-09 Thread Adrian Klaver
uot;execute" privilege of those few of all the user-defined subprograms that jointly define the database's API. The point (conforming to the principle of least privilege) is that sessions that connect as "client" must not be allowed to do arbitrary SQL. Rather, they should be able to do only what has been explicitly "white-listed" in by the encapsulation provided by the API-defining subprograms. All right that I get. -- Adrian Klaver adrian.kla...@aklaver.com

Re: List user databases

2022-11-09 Thread Adrian Klaver
eated if necessary. " "postgres" is created by default for operational convenience, but is not essential and can be removed if you really want to. Regards Ian Barwick -- Adrian Klaver adrian.kla...@aklaver.com

Re: "set role" semantics

2022-11-09 Thread Adrian Klaver
you actually done that and tried to run SQL statements? They are called system catalogs because they are used by the system to get the information necessary to do things. Throwing restrictions on their access would be akin to pouring sand in a gearbox, lots of strange behavior and then nothing. -- Adrian Klaver adrian.kla...@aklaver.com

Re: "set role" semantics

2022-11-09 Thread Adrian Klaver
hat I failed to do? -- Adrian Klaver adrian.kla...@aklaver.com

Re: "set role" semantics

2022-11-09 Thread Adrian Klaver
 nobypassrls   connection limit -1   login password 'p'; create database d1; revoke all on database d1 from public; grant connect on database d1 to mary; grant joe to mary; * Then I did this on the client machine: *psql -h u -p 5432 -d d1 -U mary* *set role joe; * Here, too, I ended up with "Joe" as the "current_user" and "d1" (to which Joe cannot connect) as the "current_database()". -- Adrian Klaver adrian.kla...@aklaver.com

Re: "set role" semantics

2022-11-08 Thread Adrian Klaver
yn Llewellyn). A quick search: https://www.postgresql.org/message-id/2176817.1644613...@sss.pgh.pa.us https://www.postgresql.org/message-id/CAKFQuwayij=aqrqxjhfuj3qejq3e-pfibjj9cohx_l_46be...@mail.gmail.com https://www.postgresql.org/message-id/cakfquwzvq-lergmtn0e3_7mqhjwtujuzf0gsnkg32mh_qf2...@mail.gmail.com David J. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Segmentation Fault PG 14

2022-11-07 Thread Adrian Klaver
il now the database did not restarted again... (not sure if it's coincidence) I did not see that post or suggestion. What was the suggestion? Are you saying the database does not start up now? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Segmentation Fault PG 14

2022-11-07 Thread Adrian Klaver
upgrades, so that is a dead end. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Segmentation Fault PG 14

2022-11-07 Thread Adrian Klaver
messages issued at any point in below? A: no errors during the dump and restore. 4) Are the database clusters on the same machine? A: No, the origin and destination were different servers at the same VPC. Are servers using the same version of OS? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Segmentation Fault PG 14

2022-11-07 Thread Adrian Klaver
                      regards, tom lane -- <http://www.trimble.com/> *Willian Cezar de O. Colognesi * Systems Analysis Specialist, Trimble Transportation Brazil Avenida Santos Dumont, 271 | Londrina, PR | 86039-090 -- Adrian Klaver adrian.kla...@aklaver.com

Re: copy file from a client app to remote postgres isntance

2022-11-07 Thread Adrian Klaver
tgres_fdw: https://www.postgresql.org/docs/current/postgres-fdw.html on local machine to point at table on remote machine and then \copy or COPY to local machine. 2) Copy the CSV file to remote machine and then do \copy or COPY there. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all"

2022-11-03 Thread Adrian Klaver
of using a VM and file backups (or snapshots). I suppose this is to be expected. Hence commitment instead of involvement. *Can I declare victory, now, with the approach that I showed above?* You are setting the goals not us, that is your decision. p.s. Is my pessimism justified—that there s

Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all"

2022-11-03 Thread Adrian Klaver
s that I got when I tried to use the new cluster. There's no useful doc for that approach and I've already established that Internet search gets me nowhere. So I'm inclined not to use it. Per the saying, "In a ham and eggs breakfast the chicken is involved but the pig is committed", right now you are involved in the Debian/Ubuntu process not committed. Until you commit you will not get the results you want. Rather, I want, now, simply to declare victory with the script that I showed and return to ordinary productive work. -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_restore error on function

2022-11-03 Thread Adrian Klaver
On 11/3/22 08:38, Post Gresql wrote: On 2022-11-03 15:43, Adrian Klaver wrote: On 11/3/22 07:28, Post Gresql wrote: Hello I first successfully ran pg_dump -U postgres -b -E UTF8 -f my_dump --format=custom -n my_schema --no-owner -v my_db but then pg_restore --single-transaction -v -U

Re: pg_restore error on function

2022-11-03 Thread Adrian Klaver
On 11/3/22 07:45, Ron wrote: On 11/3/22 09:28, Post Gresql wrote: Hello I first successfully ran pg_dump -U postgres -b -E UTF8 -f my_dump --format=custom -n my_schema --no-owner -v my_db What was the *complete* pg_dump command? I'm going to say the above. -- Adrian Klaver

Re: pg_restore error on function

2022-11-03 Thread Adrian Klaver
This is PG version 10.19 Is there a solution for this (apart from upgrading to a newer PG version)? Was there another error before this? Did the -v show the schema my_schema being created? The only workaround I can think of is to dump in plain text and then edit the dump file. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all"

2022-11-02 Thread Adrian Klaver
d as intended, though you may end up with Postgres clusters outside the place where the packaging expects them. Yet, somehow, "systemctl start postgresql" happily manages to find my customized config files in the location where I did the customization. It's hard to imagine a more confusing design. What thinking underlies it? Don't customize, use the provided tools. The idea behind all this is to have the provided tools allow you to run multiple clusters of the same version or different versions of Postgres concurrently and have the tools take care of setting up the cluster data_dir and config_dir and assign ports. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all"

2022-11-01 Thread Adrian Klaver
this design? In other words, when is it proper to put an O/S user in the "postgres" group? After all, if the answer is "never" than no privileges on "postgres/postgres" files would ever have been granted to "group".* *»* -- Adrian Klaver adrian.kla...@aklaver.com

Re: Delete a table automatic?

2022-11-01 Thread Adrian Klaver
/functions-event-triggers.html#PG-EVENT-TRIGGER-SQL-DROP-FUNCTIONS 9.29.2. Processing Objects Dropped by a DDL Command Though this will not be specific to one table. -- Adrian Klaver adrian.kla...@aklaver.com

Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

2022-10-31 Thread Adrian Klaver
only connections to the cluster will be done as local, is that correct? But when I'm working interactively, I might well allow myself to type the bare minimum, on the fly, that gets the result. -- Adrian Klaver adrian.kla...@aklaver.com

Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

2022-10-31 Thread Adrian Klaver
res -U 'clstr$mgr' calls for "local", "peer" authentication as so it does NOT require a password. That would be enough for me. But, naturally, and now that it's working. I prefer the Peter-inspired bare "psql". Personally, I use longer forms like above as a form of explicit is better then implicit. There are no end of posts to this list where the issue was someone or something had changed a 'hidden' value in a env variable or conf file could not connect or connected to wrong cluster and/or database. -- Adrian Klaver adrian.kla...@aklaver.com

Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

2022-10-30 Thread Adrian Klaver
On 10/30/22 09:16, Karsten Hilbert wrote: Am Sat, Oct 29, 2022 at 09:15:08PM -0700 schrieb Adrian Klaver: *# MAPNAME    SYSTEM-USERNAME   PG-USERNAME* *# ---    ---   ---   bllewell   mary              mary * As has been said numerous times

Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

2022-10-29 Thread Adrian Klaver
command line have "-U bob" It is not possible to make an alias mapping work without specifying "-U" on the psql command line.  Period.  The -U is precisely how you tell the server you are using an alias - without it the server expects that the o/s user is logging in using their own name as the requested login role.  In that case either a peer entry for the user exists - and thus authentication is successful - or it doesn't - and authentication will fail. +1 David J. -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to add a variable to a timestamp.

2022-10-29 Thread Adrian Klaver
.me/> secure email. -- Adrian Klaver adrian.kla...@aklaver.com

Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

2022-10-29 Thread Adrian Klaver
2.168.0.0/16 ident map=omicron pg_ident.conf and pg_hba.conf are two separate files and the only way information gets from the former to the latter is if you explicitly include the map name under METHOD for the the auth line. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all

2022-10-27 Thread Adrian Klaver
ing "connect" on it to "usr".) Then I could create a new session from the O/S prompt when "whoami" shows "user" with the bare "psql"—just as I could the moment after the PG install finished from the O/S prompt when "whoami" shows "postgres". I did think that I'd tried all this at the outset. But clearly I must've missed one of those steps or done a typo. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all

2022-10-26 Thread Adrian Klaver
ion e.g the server code. It also by default uses that same name as the database superuser when creating a new cluster. This user then owns the SQL side. You can, however, change the SQL 'owner' for new cluster as you did. *Where can I read a nice, linear, soup-to-nuts acount of this whole business that introduces, and that consistently uses, the proper terms of art?* -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to load data from CSV into a table that has array types in its columns?

2022-10-26 Thread Adrian Klaver
LICT from here: https://www.postgresql.org/docs/current/sql-insert.html#SQL-ON-CONFLICT insert into table tbl select id, array[fid] from staging_table on conflict(id) DO UPDATE SET fids = array_append(fids, excluded.fid); I would test with a smaller example data set to vetify. -- Adri

Re: How to find an oid that's not uesd now?

2022-10-23 Thread Adrian Klaver
needed: 1) Postgres version? 2) What client reported that error? 3) What is the index creation statement you used? -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_restore 12 "permission denied for schema" errors

2022-10-22 Thread Adrian Klaver
On 10/22/22 14:45, Ron wrote: On 10/22/22 16:29, Adrian Klaver wrote: To pseudo for me. What file exactly is: pg_restore --jobs=X --no-owner $NEWDB restoring? And how was that file created? Knowing this might help get at why the more straight forward method does not work. This is what

Re: pg_restore 12 "permission denied for schema" errors

2022-10-22 Thread Adrian Klaver
On 10/22/22 14:02, Ron wrote: On 10/22/22 12:00, Adrian Klaver wrote: On 10/22/22 09:41, Ron wrote: On 10/22/22 11:20, Adrian Klaver wrote: On 10/20/22 14:34, Ron wrote: On 10/20/22 10:02, Adrian Klaver wrote: On 10/20/22 06:20, Ron wrote: On 10/20/22 00:12, Tom Lane wrote: I

Re: pg_restore 12 "permission denied for schema" errors

2022-10-22 Thread Adrian Klaver
On 10/22/22 09:41, Ron wrote: On 10/22/22 11:20, Adrian Klaver wrote: On 10/20/22 14:34, Ron wrote: On 10/20/22 10:02, Adrian Klaver wrote: On 10/20/22 06:20, Ron wrote: On 10/20/22 00:12, Tom Lane wrote: I was afraid you were going to say that. The work-around is to: pg_dump $SRCDB

Re: pg_restore 12 "permission denied for schema" errors

2022-10-22 Thread Adrian Klaver
On 10/20/22 14:34, Ron wrote: On 10/20/22 10:02, Adrian Klaver wrote: On 10/20/22 06:20, Ron wrote: On 10/20/22 00:12, Tom Lane wrote: I ran "pg_dumpall --globals-only --no-role-passwords" on the source instance, and applied it to the new instance before doing the pg_restore. I

Re: High CPU usage

2022-10-22 Thread Adrian Klaver
. This is a single instance server which alows certification login only. I appreciate any help to figure this out. Thanks & Regards, Ertan -- Adrian Klaver adrian.kla...@aklaver.com

Re: possible bug

2022-10-21 Thread Adrian Klaver
ost. Also to trim out material which was covered in previous posts. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Asking for existence of a GUI frame work similar to Oracle APEX for PostgreSQL

2022-10-21 Thread Adrian Klaver
y head I can't come with a replacement. Thank you for your response! On Fri, 21 Oct 2022 at 19:36, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 10/21/22 10:25 AM, Dionisis Kontominas wrote: > Hello Adam, > >     Thank you fo

Re: possible bug

2022-10-21 Thread Adrian Klaver
be wrong. Please help me! I suspect an index problem. Have you tried reindexing the source table, kap.course if I am following correctly. Have there been any issues with the database lately, e.g. crash or other significant event? The actual test view looks like this: -- Adrian Klaver

Re: Asking for existence of a GUI frame work similar to Oracle APEX for PostgreSQL

2022-10-21 Thread Adrian Klaver
to retain the Tomcat+ORDS portion of the stack? Thank you for your time! Kindest regards, Dionisis Kontominas -- Adrian Klaver adrian.kla...@aklaver.com

Re: Asking for existence of a GUI frame work similar to Oracle APEX for PostgreSQL

2022-10-21 Thread Adrian Klaver
regards, Dionisis Kontominas -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_restore 12 "permission denied for schema" errors

2022-10-20 Thread Adrian Klaver
? 4) What user are you running the pg_restore as? 5) Why the --no-role-passwords in the pg_dump? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Column value derived from generated column in INSERT?

2022-10-19 Thread Adrian Klaver
On 10/19/22 12:58 PM, Adrian Klaver wrote: On 10/19/22 12:48, Mark Raynsford wrote: On 2022-10-19T12:43:31 -0700 Adrian Klaver wrote: HINT:  There is an entry for table "t", but it cannot be referenced from this part of the query. HINT:  There is a column named "

Re: Column value derived from generated column in INSERT?

2022-10-19 Thread Adrian Klaver
On 10/19/22 12:48, Mark Raynsford wrote: On 2022-10-19T12:43:31 -0700 Adrian Klaver wrote: HINT: There is an entry for table "t", but it cannot be referenced from this part of the query. HINT: There is a column named "x" in table "t", but it cannot be referenc

Re: Column value derived from generated column in INSERT?

2022-10-19 Thread Adrian Klaver
the query. insert into t (y) values (x * 2); ERROR: column "x" does not exist LINE 1: insert into t (y) values (x * 2); ^ HINT: There is a column named "x" in table "t", but it cannot be referenced from this part of the query. -- Adrian Klaver adrian.kla...@aklaver.com

Re: could not find shared library for Python

2022-10-17 Thread Adrian Klaver
interpreter? So type python and hit enter. -- Adrian Klaver adrian.kla...@aklaver.com

Re: could not find shared library for Python

2022-10-17 Thread Adrian Klaver
%5B%22jacktby%40gmail.com%22%5D> -- Adrian Klaver adrian.kla...@aklaver.com

Re: Attaching database

2022-10-15 Thread Adrian Klaver
e it is the "main" connection. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Attaching database

2022-10-15 Thread Adrian Klaver
On 10/15/22 08:20, Adrian Klaver wrote: On 10/14/22 21:46, Igor Korot wrote: Making catalog current means switching between DBs. Remember initially I connected to (finance) DB, which made the (finance) catalog current. Then I "opened a second connection" to (finance_2021),

Re: Attaching database

2022-10-15 Thread Adrian Klaver
e purposes of making the data visible in the foreign tables in finance. 4) The client you did this did not 'leave' the finance database, so the only information_schema you have access to is in the finance database. I hope now its clearer. Thank you. David J. -- Adrian Klaver

Re: Zheap Tech Problem

2022-10-14 Thread Adrian Klaver
jack...@gmail.com <https://maas.mail.163.com/dashi-web-extend/html/proSignature.html?ftlId=1=jacktby=jacktby%40gmail.com=https%3A%2F%2Fmail-online.nosdn.127.net%2Fsm0518731fe949f1e7d47bc70ba230c8b8.jpg=%5B%22jacktby%40gmail.com%22%5D> -- Adrian Klaver adrian.kla...@aklaver.com

Re: Where to flag an issue with EDB's PG15 Windows installer?

2022-10-14 Thread Adrian Klaver
/issues in a message to this mailing list and see if someone from EDB picks it up. Thanks, Anthony DeBarros -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_upgrade to 15 fails on Windows because of xml_is_well_formed()

2022-10-13 Thread Adrian Klaver
days. Regards Thomas -- Adrian Klaver adrian.kla...@aklaver.com

Exponentiation confusion

2022-10-13 Thread Adrian Klaver
power(10, -18::numeric); power 0. Why is the cast throwing off the result? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Same query, same data different plan

2022-10-10 Thread Adrian Klaver
or indexes, causing cost estimates to change. I will look into that and a couple of other ideas I got from this list.     regards, tom lane Thanks kostas -- Adrian Klaver adrian.kla...@aklaver.com

Re: Same query, same data different plan

2022-10-10 Thread Adrian Klaver
at above link, an answer to this question will be nothing more then guesses. -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_restore creates public schema?

2022-10-08 Thread Adrian Klaver
psql: https://fedingo.com/how-to-connect-to-postgresql-server-via-ssh-tunnel/ -- Adrian Klaver adrian.kla...@aklaver.com

Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE

2022-10-07 Thread Adrian Klaver
ng for writing's sake) takes away from any argument you are trying to make. Less is more. I have come to the point where I ignore most of what you write as it really does not go anywhere other then make noise. -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_restore creates public schema?

2022-10-07 Thread Adrian Klaver
. -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_restore creates public schema?

2022-10-06 Thread Adrian Klaver
On 10/6/22 1:54 PM, Ron wrote: On 10/6/22 14:32, Adrian Klaver wrote: On 10/6/22 10:46, Christophe Pettus wrote: On Oct 6, 2022, at 10:44, Ron wrote: Sadly, that VM doesn't have nearly enough disk space to hold the backup folder. Use file mode, and stream the output via scp/ssh

Re: pg_restore creates public schema?

2022-10-06 Thread Adrian Klaver
On 10/6/22 2:03 PM, Ron wrote: On 10/6/22 14:35, Adrian Klaver wrote: On 10/6/22 09:46, Ron wrote: On 10/6/22 10:20, Tom Lane wrote: Because installing new software on production servers requires hurdles (Service Now change ticket approved by the application support manager, Delivery

Re: pg_restore creates public schema?

2022-10-06 Thread Adrian Klaver
can move the data off site with no issue? -- Angular momentum makes the world go 'round. -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_restore creates public schema?

2022-10-06 Thread Adrian Klaver
EOL) server 2) Set up a 9.6.24 instance somewhere you have control. 3) pg_restore to it. 4) Then use pg_dump 13.8 on the new instance. -- Adrian Klaver adrian.kla...@aklaver.com

<    4   5   6   7   8   9   10   11   12   13   >