Re: Need Help On Upgrade

2023-07-11 Thread Adrian Klaver
; mean there is more then one PgBouncer instance in use? On Tue, Jul 11, 2023 at 11:46 AM Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 7/10/23 20:45, Laurenz Albe wrote: > On Mon, 2023-07-10 at 20:38 -0400, Johnathan Tiamoh wrote: >> Below is the full

Re: Need Help On Upgrade

2023-07-11 Thread Adrian Klaver
  0.0.0.0/0 md5" Then you must have entered the wrong password. If in doubt, change the password. Can you connect to the database at all or is this specific to certain users? What client(s) are you using and is the problem coming from a specific client? Yours, Laurenz Alb

Re: Need Help On Upgrade

2023-07-10 Thread Adrian Klaver
ntication| PGE-28P01: DETAIL:  Connection matched pg_hba.conf line 113: "host    all all 0.0.0.0/0 <http://0.0.0.0/0> md5" The above is not showing any actual error. There should a part that says what failed when connecting. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Need Help On Upgrade

2023-07-10 Thread Adrian Klaver
stgres 14.8     postgresql.conf        password_encryption  = ?   scram-sha-256  > wish is the default for 14.8     pg_hba.conf      md5 You have not answered: 2) Provide the error messages received when trying to connect. Thank you. On Mon, Jul 10, 2023 at 3:38 PM Adri

Re: Need Help On Upgrade

2023-07-10 Thread Adrian Klaver
and did not face similar issues. Kind regards Johnathan Tiamoh -- Adrian Klaver adrian.kla...@aklaver.com

Re: Using "exit" to bring "goto" functionality.

2023-07-10 Thread Adrian Klaver
e relevant documentation is here: https://www.postgresql.org/docs/15/plpgsql-control-structures.html#PLPGSQL-CONTROL-STRUCTURES-LOOPS -- Adrian Klaver adrian.kla...@aklaver.com

Re: INSERT UNIQUE row?

2023-07-09 Thread Adrian Klaver
On 7/9/23 17:04, Adrian Klaver wrote: On 7/9/23 15:58, p...@pfortin.com wrote: Hi, Trying to figure out how to insert new property addresses into an existing table. Can a UNIQUE constraint be applied to an entire row?  Adding UNIQUE to each column won't work in such a case since ther

Re: INSERT UNIQUE row?

2023-07-09 Thread Adrian Klaver
; but the columns are not... Is this covered in the docs? Thanks, Pierre -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to add function schema in search_path in option definitio

2023-07-09 Thread Adrian Klaver
-804e-7154-3f8c-f5f19628178e%40aklaver.com showed a way to do that. -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to add function schema in search_path in option definitio

2023-07-08 Thread Adrian Klaver
y > > -- > Domenico L. > > per stupire mezz'ora basta un libro di storia, > io cercai di imparare la Treccani a memoria... [F.d.A.] -- Adrian Klaver adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> -- Domenico L. per stupire mezz'ora basta un libro di storia, io cercai di imparare la Treccani a memoria... [F.d.A.] -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to add function schema in search_path in option definitio

2023-07-08 Thread Adrian Klaver
- test, public, history -- Domenico L. per stupire mezz'ora basta un libro di storia, io cercai di imparare la Treccani a memoria... [F.d.A.] -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to add function schema in search_path in option definitio

2023-07-08 Thread Adrian Klaver
3) Is this 'function_schema()' actually a function and if so what is it doing/returning? -- Domenico L. per stupire mezz'ora basta un libro di storia, io cercai di imparare la Treccani a memoria... [F.d.A.] -- Adrian Klaver adrian.kla...@aklaver.com

Re: track_activity_query_size max practical size?

2023-07-07 Thread Adrian Klaver
On 7/7/23 08:27, Ron wrote: Restarting is something I can do during a quiet point after the bulk of the day's work is complete, but before the nightly backups. For completeness there is the auto_explain module: https://www.postgresql.org/docs/current/auto-explain.html -- Adrian K

Re: track_activity_query_size max practical size?

2023-07-07 Thread Adrian Klaver
On 7/7/23 07:58, Ron wrote: On 7/7/23 09:55, Adrian Klaver wrote: On 7/7/23 07:51, Adrian Klaver wrote: On 7/7/23 07:42, Ron wrote: We've got some Very Large Queries that take a long time. An EXPLAIN(ANALYZE BUFFERS) would go a long way here. Even setting taqs to 10KB isn't adeq

Re: track_activity_query_size max practical size?

2023-07-07 Thread Adrian Klaver
On 7/7/23 07:51, Adrian Klaver wrote: On 7/7/23 07:42, Ron wrote: We've got some Very Large Queries that take a long time. An EXPLAIN(ANALYZE BUFFERS) would go a long way here. Even setting taqs to 10KB isn't adequate, so I want to significantly bump it, but am It is before c

Re: track_activity_query_size max practical size?

2023-07-07 Thread Adrian Klaver
what taqs is? concerned about side effects of setting it to 48KB or even 64KB. -- Adrian Klaver adrian.kla...@aklaver.com

Re: [bug]? insert returning composite type fails

2023-07-06 Thread Adrian Klaver
1 MAXVALUE 9223372036854775807 CACHE 1 ) PRIMARY KEY, user_ts_range tstzrange, db_ts_range tstzrange, has_future_record timestamp with time zone, is_valid boolean NOT NULL 't' ); -- Domenico L. per stupire mezz'ora basta un libro di storia, io cercai di imparare la Treccani a memori

Re: Need help

2023-07-06 Thread Adrian Klaver
install it. Thanks& Regards Aarthi Rajagopal -- Adrian Klaver adrian.kla...@aklaver.com

Re: Strange behaviour on function

2023-07-05 Thread Adrian Klaver
So I don't see how sqlstr is being set? I can't identify what is going to happens... any idea? thanks -- Domenico L. per stupire mezz'ora basta un libro di storia, io cercai di imparare la Treccani a memoria... [F.d.A.] -- Adrian Klaver adrian.kla...@aklaver.com

Re: Wrong passwords allowed

2023-06-28 Thread Adrian Klaver
://www.postgresql.org/docs/current/auth-trust.html or this: https://www.postgresql.org/docs/current/auth-peer.html Regards. -- Adrian Klaver adrian.kla...@aklaver.com

Re: connect postgres using url

2023-06-27 Thread Adrian Klaver
On 6/27/23 16:30, Adrian Klaver wrote: On 6/27/23 16:14, Atul Kumar wrote: HI, Could you please help me in telling how I can connect my postgres database using http url ? Are you actually talking about a Web based URL or a URI as in?: https://www.postgresql.org/docs/current/libpq

Re: connect postgres using url

2023-06-27 Thread Adrian Klaver
about a URL then that would be to some Web service that is in the background connecting to the database. How that is done is going to depend on the Web service. What steps need to be taken care of ? Please share any referral link, if possible. Regards, Atul -- Adrian Klaver adrian.kla

Re: typical active table count?

2023-06-27 Thread Adrian Klaver
eremy -- Adrian Klaver adrian.kla...@aklaver.com

Re: Large scale reliable software system

2023-06-27 Thread Adrian Klaver
roversial) * try to avoid assumptions that only one technical stack interacts with your database * do not waste time making ERDs use a tool that generates them (i like schemaspy) * test your DR strategy before disaster strikes * think about security model up front +1 merlin -- Adri

Re: When will trusted PL/Python be supported?

2023-06-27 Thread Adrian Klaver
so the trusted version of PL/Python was removed. If this situation changes, a version of PL/Python that can be used by non-superusers will be readded. " The situation has not changed. Regards Bowen Shi -- Adrian Klaver adrian.kla...@aklaver.com

Re: Large scale reliable software system

2023-06-26 Thread Adrian Klaver
backups and save the stored data from loss. The system will be hosted on a cloud. https://www.djangoproject.com/ Thank you in advance. -- Adrian Klaver adrian.kla...@aklaver.com

Re: A question about the postgres's website

2023-06-26 Thread Adrian Klaver
/www.postgresql.org/list/> (Quick Links: See the slack item) Can someone give me some advice? Read this thread at -www beginning here: https://www.postgresql.org/message-id/CACoCc8ALTqkSwFr%2BSkynQB-4NX75ddVL%3DhopRKyzqzXsu0QQvQ%40mail.gmail.com Thanks in advance! Yours, Wen Yi -- Ad

Re: a really dumb password question

2023-06-22 Thread Adrian Klaver
stern Univerrsity -- Adrian Klaver adrian.kla...@aklaver.com

Re: strange behavior of .pgpass file

2023-06-20 Thread Adrian Klaver
ame issue on slave and no issue on master although the password is > the same. > > > What am I missing here ? Please suggest. > > > > > Regards, > Atul > > > > -- Adrian Klaver adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> -- Adrian Klaver adrian.kla...@aklaver.com

Re: strange behavior of .pgpass file

2023-06-20 Thread Adrian Klaver
user but got the same issue on slave and no issue on master although the password is the same. What am I missing here ? Please suggest. Regards, Atul -- Adrian Klaver adrian.kla...@aklaver.com

Re: date format

2023-06-14 Thread Adrian Klaver
ords, does the conversion and then inserts into the destination table? -> one sql line insert as select  using the to_date() function with appropriate format. -- Born in Arizona, moved to Babylonia. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Dynamic binding issue

2023-06-12 Thread Adrian Klaver
/www.postgresql.org/docs/current/plpgsql-declarations.html#PLPGSQL-DECLARATION-ROWTYPES I suppose this is a recurrent question, but I can't find a solution... -- Domenico L. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Question about where to deploy the business logics for data processing

2023-06-09 Thread Adrian Klaver
rm manner. Some example software I have used or experimented with that can fill that role: Pandas https://pandas.pydata.org/ Duckdb https://duckdb.org/ Polars https://pola-rs.github.io/polars-book/ 2) Once something that resembles a solid plan has been developed then move to Postgres or n

Re: How to manipulate field in New record

2023-06-07 Thread Adrian Klaver
. A new row won't have the OLD RECORD. Read: https://www.postgresql.org/docs/current/plpgsql-trigger.html and look at the examples. Problem 1: how to get and set this field Problem 2: the field has Composit type -- Adrian Klaver adrian.kla...@aklaver.com

Re: No prompt for setting up a master password

2023-06-06 Thread Adrian Klaver
ac OS. Is there a way to set the master password without having the prompt appear? If yes, where/how? If not, what might you recommend for this situation? This probably will get an answer sooner on this list: https://www.postgresql.org/list/pgadmin-support/ Thank you in advance. S

Re: Composite type: Primary Key and validation

2023-06-05 Thread Adrian Klaver
On 6/5/23 11:19 AM, Lorusso Domenico wrote: thank's Adrian, my problem is I've to use CloudSql, so I can't install extensions not verified by google... It is not actually an extension, it is PERL program. Though I'm guessing that will still be an issue. -- Adri

Re: Composite type: Primary Key and validation

2023-06-05 Thread Adrian Klaver
mplate. Talking about first point I could use the "table inheritance", but I've to reset all constraints for each table :-( -- Domenico L. per stupire mezz'ora basta un libro di storia, io cercai di imparare la Treccani a memoria... [F.d.A.] -- Adrian Klaver adrian.kla...@aklaver.com

Re: Can't send mail to `pgsql-zh-gene...@lists.postgresql.org`

2023-06-03 Thread Adrian Klaver
to end of DATA command) Can someone provide some advice? Did you subscribe to it per?: https://lists.postgresql.org/ Thanks in advance! Yours, Wen Yi -- Adrian Klaver adrian.kla...@aklaver.com

Re: Number of dashes in the expanded view of psql

2023-06-03 Thread Adrian Klaver
le and data to see the effect of changing the format. test(5432)=# \pset format aligned Output format is aligned. test(5432)=# select * from wide_test ; test(5432)=# \pset format wrapped Output format is wrapped. test(5432)=# select * from wide_test ; -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_upgrade and schema complexity...

2023-06-02 Thread Adrian Klaver
On 6/2/23 18:06, Ron wrote: On 6/2/23 19:58, Adrian Klaver wrote: On 6/2/23 17:44, Ron wrote: Ran into this when upgrading from 13.11 to 15.3... The pg_restore phase failed with "ERROR: out of shared memory", and recommended that I increase max_locks_per_transaction. Doing s

Re: pg_upgrade and schema complexity...

2023-06-02 Thread Adrian Klaver
schema is 5.9M lines. Anything special you are doing in this cluster to create all those lines? What is the line count for the other instance? Is this to be expected of such a huge schema? -- Adrian Klaver adrian.kla...@aklaver.com

Re: speed up full table scan using psql

2023-06-01 Thread Adrian Klaver
irect to CSV and one with the row_to_json to see if that makes a difference. Then COPY directly to a file before applying the above pipeline. There are more ways you can slice this depending on what the preceding shows you. Hope this helps. -- Adrian Klaver adrian.kla...@aklaver.com

Re: speed up full table scan using psql

2023-05-31 Thread Adrian Klaver
ormat can be parquet? Thanks Lian -- Adrian Klaver adrian.kla...@aklaver.com

Re: speed up full table scan using psql

2023-05-31 Thread Adrian Klaver
..Using spark to read the postgres table...' and missed that you are trying to load into Snowflake. It seems Snowflake supports CSV as well: https://docs.snowflake.com/en/user-guide/data-load-prepare So the previous advice should still hold. Thanks Lian -- Adrian Klaver adrian.kla...@aklaver.com

Re: speed up full table scan using psql

2023-05-31 Thread Adrian Klaver
ot support json format which means extra work is needed to convert the supported format to jsonl (or parquet) so that they can be imported into snowflake. Still exploring but want to call it out early. Maybe 'custom' format can be parquet? Thanks Lian -- Adrian Klaver adrian.kla...@aklaver.com

Re: speed up full table scan using psql

2023-05-31 Thread Adrian Klaver
for any hints. Regards Lian -- Adrian Klaver adrian.kla...@aklaver.com

Re: Is there a bug in psql? (SELECT ''';)

2023-05-31 Thread Adrian Klaver
har); The hard way: INSERT INTO test values (''''); INSERT 0 1 The easier way: INSERT INTO test values ($$'$$); INSERT 0 1 select * from test; str - ' ' Yours, Wen Yi -- Adrian Klaver adrian.kla...@aklaver.com

Re: syntax pb

2023-05-30 Thread Adrian Klaver
oo my understanding it looks like the parser did not parse the select distinct as we think he does. Per Hubert we will need to see the complex query to be able to troubleshoot it. -- Adrian Klaver adrian.kla...@aklaver.com

Re: syntax pb

2023-05-30 Thread Adrian Klaver
b, NULL as c, NULL as d ^ HINT: You will need to rewrite or cast the expression. regards, tom lane -- Adrian Klaver adrian.kla...@aklaver.com

Re: syntax pb

2023-05-30 Thread Adrian Klaver
On 5/30/23 07:38, Adrian Klaver wrote: On 5/30/23 06:45, Marc Millas wrote: Hi, I always have had difficulties to understand syntax. So... If I have: create table t1 (t text); create table t2 (a text, b text, c test, d numeric); Is c supposed to be text? Or are you indeed referring to some

Re: syntax pb

2023-05-30 Thread Adrian Klaver
ich results in: select * from t2; a| b | c | d +-+--+-- azerty | abc | NULL | NULL thanks, Marc MILLAS Senior Architect +33607850334 www.mokadb.com <http://www.mokadb.com> -- Adrian Klaver adrian.kla...@aklaver.com

Re: Where I can find the achieve of the 'generate_series' ?

2023-05-29 Thread Adrian Klaver
r --include=*.c generate_series Yours, Wen Yi -- Adrian Klaver adrian.kla...@aklaver.com

Re: FW: Error!

2023-05-29 Thread Adrian Klaver
cific: " What is the encoding/locale for the database? To find out, in psql do \l and post the result here. " can be? Thanks for advance! Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for Windows -- Adrian Klaver adrian.kla...@aklaver.com

Re: FW: Error!

2023-05-29 Thread Adrian Klaver
st/last message. try change codepage (the docs says 1252 is appropriate for german). same result. password file in ANSI, same result. What is the encoding/locale for the database? To find out, in psql do \l and post the result here. conclusion: see above A.H. -- Adrian Klaver adrian.kla...@aklaver.com

Re: 15 pg_upgrade with -j

2023-05-22 Thread Adrian Klaver
On 5/22/23 16:29, Jeff Ross wrote: On 5/22/23 5:24 PM, Adrian Klaver wrote: On 5/22/23 16:20, Jeff Ross wrote: Hello! From docs: https://www.postgresql.org/docs/current/pgupgrade.html The --jobs option allows multiple CPU cores to be used for copying/linking of files and to dump and

Re: 15 pg_upgrade with -j

2023-05-22 Thread Adrian Klaver
inute pg_upgrade window we'll be okay but if there is anything we can do to knock that time down we will and any suggestions to do so would be greatly appreciated. Jeff Ross -- Adrian Klaver adrian.kla...@aklaver.com

Re: Would PostgreSQL 16 native transparent data encryption support database level encryption?

2023-05-22 Thread Adrian Klaver
really the point. It is that someone/thing can and if they do the files are encrypted. Pretty sure RDS is not magical enough to have no access from any source to the file system. Azure is probably the same. -- Born in Arizona, moved to Babylonia. -- Adrian Klaver adrian.kla...@aklaver.com

Re: DBeaver postgres localhost access

2023-05-22 Thread Adrian Klaver
have a new password set and shown to work then decide whether you want local to remain set at trust or change it to something more secure. If you change it then you will need to repeat 2). Kind Regards, Pedro Gonçalves -- Adrian Klaver adrian.kla...@aklaver.com

Re: Database size will be Huge difference while Restoring

2023-05-22 Thread Adrian Klaver
r of these catalogs is stored in a lower-level data structure, and can be obtained using the pg_relation_filenode() function. * Here I'm attaching Document, please check for your reference. Thanks & Regards, Rajamohan Masa * * -- Adrian Klaver adrian.kla...@aklaver.com

Re: a simple-minded question about updating

2023-05-19 Thread Adrian Klaver
release where X is new major version. So you can save some time by just looking at the notes for the .0 releases. -- Adrian Klaver adrian.kla...@aklaver.com -- Adrian Klaver adrian.kla...@aklaver.com

Re: a simple-minded question about updating

2023-05-18 Thread Adrian Klaver
hould upgrade. Martin Mueller Professor emeritus of English and Classiccs Northwestern University -- Adrian Klaver adrian.kla...@aklaver.com

Re: Would PostgreSQL 16 native transparent data encryption support database level encryption?

2023-05-18 Thread Adrian Klaver
ateurs are developing PostgreSQL. Looks like you will be migrating to Oracle or SQL Server. Good luck on keeping costs down. -- Born in Arizona, moved to Babylonia. -- Adrian Klaver adrian.kla...@aklaver.com

Re: JSONB operator unanticipated behaviour

2023-05-18 Thread Adrian Klaver
On 5/18/23 09:36, Tom Lane wrote: Adrian Klaver writes: On 5/18/23 08:46, Tom Lane wrote: You seem to be reading some fairly old version of the documentation. The extended definition that Adrian mentions has been there for awhile, but the JSON operator table didn't link to it before v1

Re: JSONB operator unanticipated behaviour

2023-05-18 Thread Adrian Klaver
been there for awhile, but the JSON operator table didn't link to it before v13. (I agree that the "top level" bit was just wrong, but it's gone.) Can you elaborate on gone and/or wrong as I see it in the 15 and devel documentation. regards, tom lan

Re: JSONB operator unanticipated behaviour

2023-05-18 Thread Adrian Klaver
Brian Mendoza br...@rotamap.net <mailto:br...@rotamap.net> Rotamap www.rotamap.net <https://www.rotamap.net> 020 7631 1555 3 Tottenham Street London W1T 2AF Registered in England No. 04551928 -- Adrian Klaver adrian.kla...@aklaver.com

Re: Is there a good way to handle sum types (or tagged unions) in PostgreSQL?

2023-05-18 Thread Adrian Klaver
uited for data of this kind? I don't really see why it should be though. Composite type?: https://www.postgresql.org/docs/current/rowtypes.html Thanks, Victor Nordam Suadicani -- Adrian Klaver adrian.kla...@aklaver.com

Re: PG_Cron - Error Message Connection failed

2023-05-14 Thread Adrian Klaver
On 5/14/23 13:04, FOUTE K. Jaurès wrote: Le dim. 14 mai 2023 à 16:12, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> a écrit : Not what was requested. In the post linked to here: https://www.postgresql.org/message-id/CAHQ1jffWF7Y8c1X7EK3JvbLJgw1GEcVk0uPa3%2B0CJ

Re: stop

2023-05-14 Thread Adrian Klaver
on how to unsubscribe from the list. This comes up on occasion and it is good to have something in the list archives that people can search on. On Sun, May 14, 2023 at 9:06 PM Tom Lane <mailto:t...@sss.pgh.pa.us>> wrote: Adrian Klaver mailto:adrian.kla...@aklaver.com>> writ

Re: stop

2023-05-14 Thread Adrian Klaver
you with step by step instructions for either unsubscribing through your account or finding the mail header information and using that. -- Adrian Klaver adrian.kla...@aklaver.com

Re: stop

2023-05-14 Thread Adrian Klaver
On 5/14/23 08:14, Sandeep Kumar Jakkaraju wrote: Isn't this spamming 🤔 No just someone lost on how to unsubscribe from the list. On Sun, 14 May, 2023, 20:38 Adrian Klaver, <mailto:adrian.kla...@aklaver.com>> wrote: On 5/13/23 23:50, Rahul Chordiya wrote: >

Re: PG_Cron - Error Message Connection failed

2023-05-14 Thread Adrian Klaver
On 5/14/23 00:20, FOUTE K. Jaurès wrote: Le sam. 13 mai 2023 à 15:59, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> a écrit : On 5/13/23 00:54, FOUTE K. Jaurès wrote: > > > >     In your original post in the image under the databas

Re: stop

2023-05-14 Thread Adrian Klaver
On 5/13/23 23:50, Rahul Chordiya wrote: unsub Go to: https://lists.postgresql.org/ -- Adrian Klaver adrian.kla...@aklaver.com

Re: PG_Cron - Error Message Connection failed

2023-05-13 Thread Adrian Klaver
On 5/13/23 00:54, FOUTE K. Jaurès wrote: In your original post in the image under the database column it looks like, to my old eyes, there is a list of database names. Is that the case? Copy and paste that content in your reply. Hello @Adrian Klaver <mailto:adrian.

Re: PG_Cron - Error Message Connection failed

2023-05-12 Thread Adrian Klaver
On 5/12/23 09:41, FOUTE K. Jaurès wrote: Understand @Adrian Klaver <mailto:adrian.kla...@aklaver.com> . the log show: 2023-05-12 17:30:19.327 WAT [46190] LOG:  cron job 8 starting: SELECT 1 2023-05-12 17:30:19.339 WAT [46190] LOG:  cron job 8 connection failed Well that did not go an

Re: PG_Cron - Error Message Connection failed

2023-05-12 Thread Adrian Klaver
pg_cron is trying to make connections? -- Adrian Klaver adrian.kla...@aklaver.com

Re: order by

2023-05-11 Thread Adrian Klaver
sion for each cluster is? >     14.2 FYI, 14.8 has just been released so the clusters are behind by 6 bug fix releases. Sadly.. I know. -- Adrian Klaver adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> -- Adrian Klaver adrian.kla...@aklaver.com

Re: order by

2023-05-11 Thread Adrian Klaver
On 5/11/23 08:00, Marc Millas wrote: On Thu, May 11, 2023 at 4:43 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 5/11/23 07:29, Marc Millas wrote: > Hi, > > I keep on investigating on the "death postgres" subject > but op

Re: order by

2023-05-11 Thread Adrian Klaver
my understanding, it's not a postgresql.conf parameter. thanks Marc MILLAS Senior Architect +33607850334 www.mokadb.com <http://www.mokadb.com> -- Adrian Klaver adrian.kla...@aklaver.com

Re: Death postgres

2023-05-07 Thread Adrian Klaver
On 5/7/23 04:46, Marc Millas wrote: Le sam. 6 mai 2023 à 21:46, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> a écrit : On 5/6/23 10:13, Marc Millas wrote: > > >     When you restarted the server where there any warnings shown? > >

Re: Death postgres

2023-05-06 Thread Adrian Klaver
was the case how can you do any of the below without restarting it? Using psql can you \d ? Yes, and no pb to check pg_statistic,... Can you select from any other table in the database? Yes -- Adrian Klaver adrian.kla...@aklaver.com <mailto:adrian.

Re: Death postgres

2023-05-06 Thread Adrian Klaver
On 5/6/23 05:25, Marc Millas wrote: Le sam. 6 mai 2023 à 06:18, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> a écrit : On 5/5/23 18:14, Marc Millas wrote: > Hi, > > postgres 14.2 on Linux redhat > > temp_file_limit set around 210 GB

Re: Death postgres

2023-05-05 Thread Adrian Klaver
are the cases where postgres may grow without caring about temp_file_limit ? thanks, Marc MILLAS Senior Architect +33607850334 www.mokadb.com <http://www.mokadb.com> -- Adrian Klaver adrian.kla...@aklaver.com

Re: Database size will be Huge difference while Restoring

2023-05-05 Thread Adrian Klaver
you might try Under Options --> Miscellaneous/Behavior turn on Exit on error. That may help determine what is going on. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Database size will be Huge difference while Restoring

2023-05-05 Thread Adrian Klaver
rrors/warnings during the restore? Thanks& Regards, Rajamohan M. On Fri, May 5, 2023 at 9:52 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 5/5/23 08:35, Rajmohan Masa wrote: > Hi Team, > I took Postgres database Backup through Directory format w

Re: Database size will be Huge difference while Restoring

2023-05-05 Thread Adrian Klaver
re? *_ _* *_ _* *_ _* Thanks & Regards, Rajamohan M. -- Adrian Klaver adrian.kla...@aklaver.com

Re: SSL Enablement in Postgres via Client App like PG-ADMIN-4, Java.

2023-05-05 Thread Adrian Klaver
-tcp.html Thanks & Regards Sujay Kadam -- Adrian Klaver adrian.kla...@aklaver.com

Re: Trigger questions

2023-05-04 Thread Adrian Klaver
Please note RULES should  be avoided beyond the use case for VIEWS. RULES are executed very early in the query tree; it is not trivial to write rules on Tables. Thanks -- Adrian Klaver adrian.kla...@aklaver.com

Re: PL/pgSQL doesn't support variables in queries?

2023-05-03 Thread Adrian Klaver
s the same terminology, in pgsql? So is this possible? Many things are possible and they are covered in the documentation: https://www.postgresql.org/docs/current/plpgsql.html Read through that and you will find your questions answered. -JA- -- Adrian Klaver adrian.kla...@aklaver.com

Re: Multiple Postgrest Verisons how to set one version as default.

2023-04-29 Thread Adrian Klaver
ase share the steps or any guidance on how to resolve the issue. Thank you so much. Anything would be helpful. Thanks & Regards, Gautham -- Adrian Klaver adrian.kla...@aklaver.com

Re: Postgres query doesn't accept double quote around schema name in query statement

2023-04-27 Thread Adrian Klaver
fusion, it is copied/pasted from OneNote which may have brought invalid quote, but the quotes used in pgadmin are correct. On Thu, Apr 27, 2023 at 12:46 PM Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 4/27/23 12:40, Michael Xu wrote: > Hi, > > By de

Re: Postgres query doesn't accept double quote around schema name in query statement

2023-04-27 Thread Adrian Klaver
_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-10), 64-bit Thanks! Michael -- Adrian Klaver adrian.kla...@aklaver.com

Re: FW: Error!

2023-04-25 Thread Adrian Klaver
n you would get this error: psql: error: connection to server at "::1", port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? -- Adrian Klaver adrian.kla...@aklaver.com

Re: FW: Error!

2023-04-24 Thread Adrian Klaver
reenshots have to be opened in another program. Also it is simple to get the text. In the terminal/console right click and click on Select All and then hit Enter to copy the content and then paste to your email. Thanks! Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for Wind

Re: FW: Error!

2023-04-24 Thread Adrian Klaver
ure Without knowing the command used and the error message it will be difficult to point at a documented answer. Thanks so much for attention and collaboration! Best regards! -- Adrian Klaver adrian.kla...@aklaver.com

Re: what happens if a failed transaction is not rolled back?

2023-04-24 Thread Adrian Klaver
On 4/24/23 08:43, Adrian Klaver wrote: On 4/24/23 08:37, Siddharth Jain wrote: Hi All, i understand when writing application code, we should rollback a transaction that fails to commit. this is typically done in the catch block of a try-catch exception handler. but what if the developer does

Re: what happens if a failed transaction is not rolled back?

2023-04-24 Thread Adrian Klaver
= psycopg2.connect("dbname=test host=localhost user=postgres") cur = con.cursor() cur.execute("select 1/0") DivisionByZero: division by zero cur.execute("select 1") InFailedSqlTransaction: current transaction is aborted, commands ignored until end of transaction block

Re: [EXT] Re: SCROLLABLE/UPDATABLE cursor question

2023-04-24 Thread Adrian Klaver
erformed without updating catalog tables: Note that CREATE TABLE from a non-SDM client does not maintain LzRelational catalog tables seems to indicate you are using some sort of Postgres fork. Is that the case and if so what is the fork? -- Adrian Klaver adrian.kla...@aklaver.com

Re: FW: Error!

2023-04-22 Thread Adrian Klaver
h a screen what I did… Thanks for his attention and collaboration! > -- Adrian Klaver adrian.kla...@aklaver.com

Re: What happened to the tip "It is good practice to create a role that has the CREATEDB and CREATEROLE privileges..."

2023-04-19 Thread Adrian Klaver
it was over only documentation files doc/src/sgml/ref/alter_role.sgml doc/src/sgml/ref/create_role.sgml doc/src/sgml/ref/createuser.sgml doc/src/sgml/user-manag.sgml so I don't see how it can change behavior. -- Adrian Klaver adrian.kla...@aklaver.com

Re: psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist

2023-04-19 Thread Adrian Klaver
change your situation, as others have pointed out that is a schema/search_path issue. You will still need to resolve that. -- Adrian Klaver adrian.kla...@aklaver.com

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