Hi Ron,
> On 22. Sep, 2024, at 16:11, Ron Johnson wrote:
>
> The real question is why nobody notices it in other RDBMSs like Oracle, SQL
> Server and MySQL.
The answer is simple for Oracle: It includes a whole zoo of locale mappings and
uses each one as it is needed. This is one of the many t
Hi Joe
> On 22. Sep, 2024, at 15:47, Joe Conway wrote:
>
> Note that moving to ICU might improve things, but there are similar potential
> issues with ICU as well. The trick there would be to get your OS distro
> provider to maintain the same ICU version across major versions of the
> distro,
Hi Nikolay,
> On Nov 2, 2023, at 07:36, Nikolay Samokhvalov wrote:
> There is also a good trick described in
> https://www.crunchydata.com/blog/fun-with-pg_checksums to avoid
> accidental start of Postgres:
[...]
> Additionally, I compiled some thoughts about running pg_checksums
> without downt
Hi Alexander,
> On Oct 30, 2023, at 19:49, Alexander Kukushkin wrote:
> That's not what I said.
That's why I asked. Because you used the word orthogonal. 🤣
> Patroni only manages Postgres. It is exactly the same Postgres as you would
> run it without Patroni.
> Everything will work.
Now that
Hi Alexander,
> On Oct 30, 2023, at 14:56, Alexander Kukushkin wrote:
...
> But anyway, Patroni is orthogonal to pg_checksums.
...
Just to be sure I understand you correctly: This does not work with Patroni?
Cheers
Paul
Hi Peter,
> On Oct 30, 2023, at 11:03, Peter J. Holzer wrote:
> On 2023-10-29 13:26:27 -0500, Ron wrote:
>> Best to ask Percona.
>
> Why Percona?
Probably a typo. Patroni is used.
Cheers
Paul
Hi Michael,
> On Oct 30, 2023, at 01:56, Michael Paquier wrote:
>
> Hm? Page checksums are written when a page is flushed to disk, we
> don't set them for dirty buffers or full-page writes included in WAL,
> so it should be OK to do something like the following:
> - Stop cleanly a standby.
> -
Hi Ron,
> On Oct 29, 2023, at 16:38, Peter J. Holzer wrote:
> And this is where it would break down. The modifications can't be
> applied to the replica any more because the replica now contains
> checksums and the modifications don't. In the best case the replica
> would catch the discrepancy a
Hi Ron,
> On Oct 29, 2023, at 16:37, Ron wrote:
>
> As for safety, what do you mean by "safe"?
Safe in the sense that, if I enable checksums on a replica, switch over and the
enable checksums on the other side, if this is ok, or whether future mutations
on the primary will corrupt the replica
Hi Peter,
> On Oct 29, 2023, at 11:49, Peter J. Holzer wrote:
>
> It *might* work if there are zero writes on the primary during the
> downtime of the replica (because those writes couldn't be replicated),
> but that seems hard to ensure. Even if you could get away with making
> the primary read
Hi Peter
> On Oct 29, 2023, at 02:43, Peter J. Holzer wrote:
> I don't think so. AFAIK Replication keeps the data files in sync on a
> bit-for-bit level and turning on checksums changes the data layout.
> Running a cluster where one node has checksums and the other doesn't
> would result in a com
Hi Bruce, hi Daniel,
> On Oct 27, 2023, at 23:21, Bruce Momjian wrote:
>
> On Fri, Oct 27, 2023 at 10:45:16PM +0200, Daniel Gustafsson wrote:
>>> On 27 Oct 2023, at 20:34, Paul Förster wrote:
>>
>>> a) why isn't it possible to enable checksumming while a
Hi Ron,
> On Oct 27, 2023, at 21:02, Ron wrote:
>> b) why isn't it possible to check whether checksums are enabled or not?
>
> (This is my tiny test instance.)
>
> $ pg_controldata | grep checksum
> Data page checksum version: 0
>
> postgres=# show data_checksums;
> data_checksums
>
Hi,
I have a few questions about pg_checksums.
Long story short, checksums were disabled in our environment but are getting
enabled now (again!) because of block corruptions which destroyed a few
databases in a database cluster. And before you say "told you so", the decision
to disable checksu
Hi Ludovico,
> Sorry for this reply, but I feel it is necessary to make it clear what is
> reality and what is FUD against Oracle from Paul's e-mails in this thread...
nothing of it was a FUD. It was a comparison done on a single machine. Then, I
drew my conclusions from that and added my perso
Hi Markus,
On 13. Apr, 2021, at 14:43, Zwettler Markus (OIZ)
wrote:
> We assume to get more than 100 Postgres clusters in the future.
>
> We will get a very heterogeneous binary installation basis if we install
> needed extensions (e.g. ip4r) or software (e.g. patroni) on a per project
> bas
Hi Tom,
> On 26. Feb, 2021, at 21:29, Tom Lane wrote:
>
> Actually we need a patch against the SGML sources, not the generated
> files.
I didn't know this, sorry. I'm not a developer. :-)
> I took this and marked it up into SGML, and (as usual when
> looking at this text, it seems) failed to
Hi Tom,
> On 26. Feb, 2021, at 19:02, Paul Förster wrote:
>
> as I said, I don't know how to write a patch. But I played around with diff &
> patch.
>
> However, does this do when applied to
> https://www.postgresql.org/docs/current/libpq-connect.html? Would thi
Hi Tom,
> On 26. Feb, 2021, at 17:13, Tom Lane wrote:
>
> WFM. Who's going to write the patch? (I can, but if one of you
> wants to, be my guest.)
as I said, I don't know how to write a patch. But I played around with diff &
patch.
However, does this do when applied to
https://www.postgres
Hi Tom,
> On 26. Feb, 2021, at 17:13, Tom Lane wrote:
>
> WFM. Who's going to write the patch? (I can, but if one of you
> wants to, be my guest.)
I don't know how to write a patch. Is there any documentation about that?
Cheers,
Paul
Hi Tom,
> On 26. Feb, 2021, at 15:51, Tom Lane wrote:
>
> +1. I think you could lose the outer brackets in hostspec in
> this formulation, ie given that hostspec is already bracketed
> above, it should be enough to write
>
>hostspec is [host][:port][,...]
>
> Also, the paramspec is under-
Hi Alvaro,
> On 26. Feb, 2021, at 15:30, Alvaro Herrera wrote:
>
> We could say something like
>
> postgresql://[userspec@][hostspec][/dbname][?paramspec]
>
> where
> userspec is user[:password]
> hostspec is [[host][:port]][,...]
> paramspec is param1=value1&...
>
> which makes it easier
Hi Tom,
> On 25. Feb, 2021, at 16:43, Tom Lane wrote:
>
> Experimenting, it does let you omit the host and specify a port:
>
> $ psql -d postgresql://:5433
> psql: error: could not connect to server: No such file or directory
>Is the server running locally and accepting
>connect
Hi Tom,
> On 25. Feb, 2021, at 16:22, Tom Lane wrote:
>
> Hmm. Maybe
>
> postgresql://[user[:password]@][host[:port][,...]][/dbname][?param1=value1&...]
>
> ? Seems like that would clarify how much you can repeat.
yes, that looks better, thanks.
Cheers,
Paul
Hi Tom,
> On 25. Feb, 2021, at 16:09, Tom Lane wrote:
>
> =?utf-8?Q?Paul_F=C3=B6rster?= writes:
>> in
>> https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-CONNSTRING
>> it says that the syntax for a PostgreSQL URI is:
>
>> postgresql://[user[:password]@][host][:port][,...][/db
Hi,
in https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-CONNSTRING
it says that the syntax for a PostgreSQL URI is:
postgresql://[user[:password]@][host][:port][,...][/dbname][?param1=value1&...]
What I don't understand is the [,...] part, i.e. optionally repeating argument.
I
Hi Bryn,
> On 09. Feb, 2021, at 19:55, Bryn Llewellyn wrote:
>
> Using a MacBook Pro with the current Big Sur—Version 11.2 (20D64).
>
> I just upgraded to PostgreSQL 13.1. (Earlier, I was on 12.x.) Using psql, the
> behavior of ordinary copy-and-paste has change dramatically, and for the
> wo
Hi Taranum,
> On 09. Feb, 2021, at 11:09, Paul Förster wrote:
>> I am new to postgres, can you please guide me from which folder I can get
>> the downloadable and repository for 9.4?
you may also try this if you need a binary release:
https://www.enterprisedb.com/downloads/post
Hi Taranum,
> On 09. Feb, 2021, at 10:21, Taranum Fatima wrote:
>
> I am new to postgres, can you please guide me from which folder I can get the
> downloadable and repository for 9.4?
depends on what platform you're on. Windows? Linux? Solaris?...
Seems like all the directories in the binary
Hi Taranum,
> On 09. Feb, 2021, at 01:59, Taranum Fatima wrote:
>
> Do you have any place from where I can download this 9.4 repository and
> 94server?
old versions of PostgreSQL can still be downloaded from:
https://www.postgresql.org/ftp/
Cheers,
Paul
Hi Joao,
> On 08. Feb, 2021, at 17:39, Joao Miguel Ferreira
> wrote:
>
> NOTICE: identifier
> "y1972_1004_vat_periodic_declaration_suppliers_lines_dupl_c24_liq" will be
> truncated to "y1972_1004_vat_periodic_declaration_suppliers_lines_dupl_c24_li"
>
> Please advise on what I should do abo
Hi Tatsuo,
> On 29. Jan, 2021, at 03:51, Tatsuo Ishii wrote:
>
> Does anybody know whether a standby server waits for pending WAL
> records/files while promotion is requested? I assume that no data
> update is performed on the primary server while promotion.
>
> I imagine that a standby server
Hi Ingolf,
> On 26. Jan, 2021, at 14:41, Markhof, Ingolf
> wrote:
>
> You may not be able to delete tables / views that are referenced by other
> users objects, e.g. views. Unless you add the CASCADE option which will cause
> all depending views to be deleted as well. And the CASCASE will wor
Hi Robert,
> On 24. Jan, 2021, at 08:13, robert rottermann wrote:
>
> thanks a lot.
> why dos such stupidity not hurt. ?
the human brain does not contain pain generating or transmitting nerve cells,
that's why. :-P
Cheers,
Paul
Hi Rob,
> On 23. Jan, 2021, at 00:02, Rob Sargent wrote:
>
> I only wish I could set a default database as well, but IMHO that's a failing
> of JDBC as much as postgres.
you can't for a role or a user. You'd have to specify the database in the jdbc
connection string. It's all here:
https://j
Hi Rob,
> On 22. Jan, 2021, at 23:48, Rob Sargent wrote:
>
> Yes, I'm confused. As I said in reply to Jeff, I would rather not need to
> remember to set the search_path, which I can avoid if I login as "role".
I didn't follow the whole discussion, so sorry, to just jump in here.
You don't ne
Hi Michael,
> On 20. Jan, 2021, at 20:37, Michael Lewis wrote:
>
> Using pg_upgrade takes minutes for an in place upgrade. If you can allow 1+
> hour of downtime, it seems overly complicated to use logical replication.
my all time best score was 18 seconds for migrating from 11 to 12. :-)
Che
Hi Peter,
> On 18. Jan, 2021, at 17:34, Peter J. Holzer wrote:
>
> In 1990, MIME didn't exist. E-Mail was by definition US-ASCII text
> (except for uuencode or by private arrangement). People often used text
> terminals and may not have any Internet access.
yes, those were the days! :-) As for
Hi Thiemo,
> On 17. Jan, 2021, at 11:23, Thiemo Kellner
> wrote:
>
> I would not do that. It is the work on the wrong end with doubtful result.
> Wouldn't it be better to reject non-plain-text postings?
coming to think of it:
+1
> While at it, is there a rule of thumb for the length of inlin
Hi Tim,
> On 17. Jan, 2021, at 10:04, Tim Cross wrote:
>
> There is nothing stopping you from using a text mail program, like mutt,
> on macOS.
right. And what I said was not meant to be a complaint. Otherwise I would have
complained long ago. It was just a wish. :-)
Cheers,
Paul
Hi Tim,
> On 17. Jan, 2021, at 09:43, Tim Cross wrote:
>
> Highly recommend a mutt and imap combination. Your not locked into any
> particular mail folder format, can still access things via mobile
> devices and can process messages fast and efficiently.
also, there's the good old elm. ;-)
> H
Hi raf,
> On 17. Jan, 2021, at 02:59, raf wrote:
>
> I once wrote a program to do that very thing:
>
> http://raf.org/textmail/
> https://github.com/raforg/textmail/
thanks very much for the nice offer but I mostly read my Mails on a Mac,
sometimes Windows, but never Linux. I have no mail a
Hi Adrian,
> On 16. Jan, 2021, at 23:46, Adrian Klaver wrote:
>
> That is trying to put the toothpaste back in the tube.
yes, but sometimes, just sometimes, things in the olden days were just better.
:-)
> Too many GUI email interfaces these days that use 'advanced` formatting. I
> use Thund
Hi Bruce,
> On 16. Jan, 2021, at 19:36, Bruce Momjian wrote:
>
> That "quoting entire messages on reply" is something I see far too often
> here. I have been meaning to mention this problem. Thousands of people
> are reading postings here, so it pays to take time to trim down what
> others hav
Hi Mike,
> On 16. Jan, 2021, at 18:29, Michael Nolan wrote:
>
> There's so much garbage in a Google search any more that they're becoming
> nearly useless. Between 'sponsored' hits and ones that have little or no
> relevance but throw in words to get included, I find as often as not that IF
Hi Laurenz,
> On 14. Jan, 2021, at 04:59, Laurenz Albe wrote:
>
> If PostgreSQL were to store the original text, either that text would become
> wrong, or you would have to forbid renaming of anything that is referenced
> by a view.
this is why views, procedures, functions and packages can beco
Hi Stephen,
> On 08. Jan, 2021, at 22:59, Stephen Frost wrote:
>
> Done correctly, the developers will hopefully be going from "this stupid
> thing prompts me to provide a username/password in order to log in" to
> "no more prompt for logging in, it just *works*". Further, as Magnus
> explained
Hi Magnus,
> On 07. Jan, 2021, at 12:43, Magnus Hagander wrote:
>
> The docs say "When using an external authentication system such as
> Ident or GSSAPI, the name of the operating system user that initiated
> the connection might not be the same as the database user (role) that
> is to be used."
Hi Magnus,
> On 07. Jan, 2021, at 11:04, Magnus Hagander wrote:
>
> No, I think this is correct.
>
> "Set to ldaps to use ldaps" means you set it to the value "ldaps" in
> order to use ldaps.
>
> I think you missed the "to" in the sentence -- without that one, your
> reading of it would make m
Hi Stephen,
> On 06. Jan, 2021, at 18:14, Stephen Frost wrote:
>
> When in an Active Directory environment, it's far more secure to use
> Kerberos/GSSAPI and not LDAP (or LDAPS). Using the ldap authentication
> method with PostgreSQL will result in the credentials of users being
> sent to the d
Hi Magnus,
> On 06. Jan, 2021, at 16:57, Magnus Hagander wrote:
>
> Yes. But you have a really hacky environment :P
actually not. We have an old LDAP which we want to retire this year. And we
also have Windows AD, which offers LDAP. So the idea is to switch the LDAP
environments in PostgreSQL
Hi Magnus,
> On 06. Jan, 2021, at 15:48, Magnus Hagander wrote:
>
> Only if you can create rules in your pg_hba.conf file that knows where
> the users are. You can specify multiple servers on one line, but that
> only balances across servers that don't work. If a server replies "no"
> to a respo
Hi,
can I use more than one LDAP server entry in pg_hba.conf? My tests show that
only the first one is used.
Example:
ldap1.domain contains user1, user2
ldap2.another.domain contains user3, user4
All 4 users have an account in a PostgreSQL cluster.
ldap1 is openLDAP and ldap2 is Windows AD. B
Hi,
I found what I believe to be misleading in the LDAP documentation:
https://www.postgresql.org/docs/current/auth-ldap.html
It says:
"ldapscheme
Set to ldaps to use LDAPS."...
IMHO, it should say:
"ldapscheme
Set to ldapscheme to use LDAPS (ldapscheme=ldaps)."...
I found this because I'm in
Hi Dan,
> I am trying to find out if there is any step by step instruction to reconcile
> old data dir and upgraded data dir after using “—link” option to do an
> upgrade.
>
> I ran this to do an upgrade from 11.5 to 12.1: pg_upgrade -d
> /hostname/pg/dev115/data -D /hostname/pg/dev121upg/dat
Hi,
> On 15. Dec, 2020, at 18:37, Ron wrote:
>
> On 12/15/20 11:26 AM, Laurenz Albe wrote:
>> On Tue, 2020-12-15 at 10:00 -0600, Ron wrote:
After abrupt shutdown of Windows, we are seeing the pg_ctl.exe file
getting deleted automatically.
>>> Only pg_ctl.exe gets deleted? Anyway, th
Hi Rich,
> On 09. Dec, 2020, at 19:22, Rich Shepard wrote:
>
> Okay. I use mupdf to view the document and my search string were 'prompt',
> and 'prompt command'. I didn't use '\prompt',
\prompt is a psql special command, hence the backslash. Only psql knows that,
the database does not, as with
Hi Rich,
> On 09. Dec, 2020, at 19:10, Rich Shepard wrote:
>
> Looking at the postgres-12 doc I cannot find a command 'PROMPT' anywhere in
> it.
but 12 has it:
postgres=# \prompt 'input: ' input
input: this is test input
postgres=# select version(), :'input';
Hi Rich,
> On 09. Dec, 2020, at 18:53, Rich Shepard wrote:
>
> My business tracking tool. Yes, the GUI will have text entry widgets for
> user input but I want to apply these queries using psql on the command line
> until I build the GUI.
maybe you're looking for this?
https://stackoverflow.co
Hi Adrian,
> On 05. Dec, 2020, at 15:58, Adrian Klaver wrote:
>
> Given that the OP changed pg_hba.conf.sample, probably not:).
sorry, I overlook the *.sample part. :D
Cheers,
Paul
Hi Hemil,
> On 05. Dec, 2020, at 07:50, Hemil Ruparel wrote:
>
> Did you restart postgres after changing pg_hba.conf?
that shouldn't be necessary for changes in pg_hba.conf. Just do either on the
command line:
$ pg_ctl reload
or from psql:
postgres=# select pg_reload_conf();
You can then s
Hi Adrian,
> On 04. Dec, 2020, at 16:13, Adrian Klaver wrote:
> That is the wrong file, the *.sample is the giveaway.
hmmm, I'd rather call it essential reference documentation or template for
automation. It's perfectly well suited to automatically strip all comments and
then diff the result t
Hi Raul,
> On 20. Nov, 2020, at 11:45, Raul Kaubi wrote:
>
> Hmm, ok.
>
> But how is this possible..?
>
> when b.sender>0 and c.receiver>0 then
> 'Primary+Replica'
>
> Raul
this happens for example if you have a primary a and replica b running as a
normal cluster (we use Patron
Hi Raul,
> On 20. Nov, 2020, at 10:41, Raul Kaubi wrote:
>
> Hi
>
> Thanks.
> Seems like 9.5 does not work.
>
> ERROR: relation "pg_stat_wal_receiver" does not exist
> LINE 20: from pg_stat_wal_receiver
>
> Any ide how to achieve this in 9.5 ?
>
> Raul
this query is tested to work
Hi David,
> On 20. Nov, 2020, at 10:34, David G. Johnston
> wrote:
>
>
> On Friday, November 20, 2020, Paul Förster wrote:
>
> > On 20. Nov, 2020, at 10:03, Thomas Kellerer wrote:
>
> >
> > select pg_is_in_recovery();
>
> I usually d
Hi Thomas,
> On 20. Nov, 2020, at 10:03, Thomas Kellerer wrote:
>
> Raul Kaubi schrieb am 20.11.2020 um 09:53:
>> CentOS 7
>> Postgres 9 to 12
>>
>> For monitoring purpose, I would like that certain scripts are only run in
>> primary server.
>> So I am looking ways to universally discover if p
Hi Jayadevan,
> On 19. Nov, 2020, at 11:07, Jayadevan M wrote:
>
> May be you could also make sure that loading actually stopped, by checking
> the size of the data directory. In another session, you could try
> watch du -h -s
that might be misleading if you have the pg_wal directory inside
Hi,
> On 18. Nov, 2020, at 22:08, Post Gresql wrote:
>
> I might be stupid, but where in the document for create function does it say
> that the return type can be a table?
>
> From the doc for version 13
> https://www.postgresql.org/docs/13/sql-createfunction.html
>
> "rettype
> The return
Hi Ravi,
> On 18. Nov, 2020, at 15:30, Ravi Krishna wrote:
>
> ALTER TABLE TABLE_NAME DROP PARTITION PARTITION_NAME UPDATE INDEXES;
IIRC the statement is
alter table drop partition update *GLOBAL* indexes;
But we experienced big problems in the past which is why we changed all to
local ind
Hi Laurenz,
> On 18. Nov, 2020, at 13:02, Laurenz Albe wrote:
>
> I personally hope that we will never have global indexes.
> I am not looking forward to helping customers with the problems that
> they create (long duration of ATTACH/DETACH PARTITION, index fragmentation).
+1.
Experience shows
Hi Mark,
> On 12. Nov, 2020, at 16:37, Paul Förster wrote:
>
> how about searching for pg_ctl only inside a bin directory:
>
> $ find / -type f -name "pg_ctl" -exec grep "/bin/" {} \; 2>/dev/null
> Binary file /data/postgres/12.4/bin/pg_ctl matches
>
Hi Mark,
> On 12. Nov, 2020, at 16:19, Mark Johnson wrote:
>
> # find / -name pg_ctl
> /usr/pgsql-13/bin/pg_ctl
> /usr/local/pgsql/bin/pg_ctl
> /usr/pgsql-12/bin/pg_ctl
> /usr/pgsql-9.6/bin/pg_ctl
> /root/Downloads/postgresql-12.1/src/bin/pg_ctl
> /root/Downloads/postgresql-12.1/src/bin/pg_ctl/p
Hi Raul, hi Adrian,
> On 11. Nov, 2020, at 23:26, Adrian Klaver wrote:
>
> On 11/11/20 2:22 PM, Raul Kaubi wrote:
>> Hi
>> CentOS 7
>> Postgres 9 to 12
>> I am looking ways to universally discover postgresql binary directory for
>> monitoring purpose.
>> For example postgres 12, it is: */usr/pg
Hi Matt,
> On 09. Nov, 2020, at 18:00, Matt Zagrabelny wrote:
>
> Hello,
>
> I see the --data-checksums option for initdb. Is it possible to use
> --data-checksums after the cluster has been initialized? I'm guessing "not",
> but thought I'd ask.
>
> I'm running v12 on Debian.
>
> Thanks fo
Hi David,
> On 29. Oct, 2020, at 17:21, David G. Johnston
> wrote:
>
> On Thu, Oct 29, 2020 at 9:16 AM Paul Förster wrote:
> But I guess that Emacs shows the matching closing bracket at the beginning of
> the line, which matches that single tuple. But you also need a clos
Hi Rich,
> On 29. Oct, 2020, at 17:08, Rich Shepard wrote:
>
> On Thu, 29 Oct 2020, Paul Förster wrote:
>
>>> (2698,'Port of
>>> Portland','http://www.portofportland.com',null,'Port','Opportunity',null);
>> the
Hi Rich,
> On 29. Oct, 2020, at 16:58, Rich Shepard wrote:
>
> On Thu, 29 Oct 2020, Rob Sargent wrote:
>
>> Can we see the last two line of the file (1924, 1925)?
>
> Rob,
>
> (2697,'Port of
> Newport','http://www.portofnewport.com',null,'Port','Opportunity',null),
> (2698,'Port of
> Portla
Hi Laurent,
> On 22. Oct, 2020, at 08:42, W.P. wrote:
>
> Hi there,
>
> how to do "hot backup" (copying files) while database running?
>
> Not using pg_dump.
>
> Is there some equivalent of Oracle (I knew v8) "ALTER DATABASE BEGIN BACKUP",
> which froze writes to database files, pushing ever
Hi Peter,
> On 14. Oct, 2020, at 14:49, Peter J. Holzer wrote:
>
> "IOT" means "Internet of things".
IOT also means "index organized table"...
So much for using abbreviations. :-)
Cheers,
Paul
Hi Mark,
> On 06. Oct, 2020, at 10:23, Mark wrote:
>
> Actually, a single quotation will work.
> \ir 'C:\\Program Files\\PostgreSQL\\12\\demo-big-en-20170815.sql'
> But I don't know why a single quotation will work.
> It would be very helpful if you guys can explain to me.
because Microsoft
Hi James,
> On 05. Oct, 2020, at 19:16, James B. Byrne wrote:
>
> As this is an application package it is not within my purview to alter the
> code. To do so would rik a return of the problem with every update.
>
> Adding public to the search path is fine by me. However, I still need to find
Hi Adrian,
> On 05. Oct, 2020, at 19:20, Adrian Klaver wrote:
> Actually it does:
>
> From the prompt I'm guessing you are logging in as 'postgres' user. In that
> case "$user" will become postgres and you will get:
>
> postgres=# select current_schemas(false);
> current_schemas
> ---
Hi James,
> idempiere=# select uuid_generate_v4();
> ERROR: function uuid_generate_v4() does not exist
> LINE 1: select uuid_generate_v4();
> ^
> HINT: No function matches the given name and argument types. You might need
> to
> add explicit type casts.
> idempiere=# select public
Hi James,
> On 05. Oct, 2020, at 17:57, James B. Byrne wrote:
>
> [root@accounting-2 ~ (master)]# psql --dbname=idempiere
> --username=idempiere_dbadmin
> Password for user idempiere_dbadmin:
> psql (11.8)
> Type "help" for help.
>
> idempiere=# select current_schemas(true);
>current_schema
Hi James,
> On 03. Oct, 2020, at 04:17, James B. Byrne wrote:
>
> On Fri, October 2, 2020 21:13, Tom Lane wrote:
>> "James B. Byrne" writes:
>>> On Fri, October 2, 2020 18:46, Tom Lane wrote:
>>
>>> idempiere=# \dn
>>>List of schemas
>>> Name| Owner
>>> ---+---
>>>
Hi Adrian,
> On 28. Sep, 2020, at 16:30, Adrian Klaver wrote:
> Not necessarily, if it is installing plpythonu functions.
I'll have to check that anyway. I'm already logged out of work, so I won't do
that now. 😇
Cheers,
Paul
Hi Adrian,
> On 28. Sep, 2020, at 16:03, Adrian Klaver wrote:
>
> So pgwatch2 installs functions that use plpythonu?
> How does that work if there is no plpython language installed?
at work, the extension is installed everywhere. But it seems we have an old
version. The current version seems t
Hi Adrian,
> On 28. Sep, 2020, at 15:34, Adrian Klaver wrote:
>
> Well I'm out of ideas. That means circling back to having Python 2 installed,
> should the powers that be agree.
they don't. But fortunately, it seems that the number of applications which use
Python code inside a database, see
Hi Laurenz,
> On 28. Sep, 2020, at 13:13, Laurenz Albe wrote:
>>
>> but then I'd have to do a reindex anyway, right? My goal was to avoid the
>> reindex altogether, if possible.
>
> That couldn't be avoided anyway if you change the collation no matter
> if you do it on the database or on the c
Hi Matthias,
> On 28. Sep, 2020, at 12:06, Matthias Apitz wrote:
>
>
> Hello,
>
> Maybe it's a FAQ, but I haven't seen the answer. I want to switch of the
> warning (because I know the fact of version not matching):
>
> $ psql -Usisis -dsisis
> SET
> psql (11.4, server 13.0)
> WARNING: psql m
Hi Laurenz,
> On 28. Sep, 2020, at 11:04, Laurenz Albe wrote:
>
> There have been efforts to add this functionality:
> https://www.postgresql.org/message-id/flat/5e756dd6-0e91-d778-96fd-b1bcb06c161a%402ndquadrant.com
> but it didn't get done.
seems to be a rather complex thing according to the
Hi,
I have a general question about the use of ICU. Currently, we have PostgreSQL
compiled from source (Linux) without ICU support. All database clusters and
databases are UTF8 and of course relying on glibc.
With the sooner or later upcoming glibc release 2.28, there will probably a big
reind
Hi Adrian,
> On 27. Sep, 2020, at 19:30, Adrian Klaver wrote:
>
> Does:
>
> SELECT
>lanname, proname, probin
> FROM
>pg_proc
> JOIN
>pg_language
> ON
>pg_language.oid = pg_proc.prolang
> WHERE
>pg_language.lanname='plpythonu'
> AND
> probin IS NOT NULL;
>
> show anything?
Hi Adrian,
> On 27. Sep, 2020, at 00:09, Adrian Klaver wrote:
> Could it be that at some point in these instances history plpython* where
> installed as CREATE LANGUAGE and you are dealing with the vestiges of that?
I do know for sure that that never happened because the database clusters with
Hi Adrian,
> On 26. Sep, 2020, at 17:43, Adrian Klaver wrote:
>
> I suppose getting them to install Python 2 is out of the question? It is an
> official package.
I can try, but chances are at 99% that they refuse.
> Well there is always going to be versioning. If you mean the incompatibility
Hi Adrian,
> On 26. Sep, 2020, at 17:17, Adrian Klaver wrote:
>
> On 9/26/20 2:33 AM, Paul Förster wrote:
>> Hi,
>> the OS here is openSUSE Leap 15.2. I downloaded the PostgreSQL 13.0 source
>> and built it without issues like so:
>
>> openSUSE has no pytho
Hi Adrian,
> On 26. Sep, 2020, at 17:07, Adrian Klaver wrote:
>
> I believe the issue is here:
>
> select * from pg_pltemplate ;
>
>
> plpythonu | f | f | plpython_call_handler |
> plpython_inline_handler | plpython_validator | $libdir/plpython2 | NULL
> plpython2u
Hi Tom,
> On 26. Sep, 2020, at 16:49, Tom Lane wrote:
>
> Actually, now that I think about it, you're querying the wrong view.
> I'm too lazy to check the source code right now, but I'm pretty sure
> that pg_available_extension_versions is mostly driven off what control
> files exist in the on-d
Hi Tom,
> On 26. Sep, 2020, at 16:07, Tom Lane wrote:
>
> =?utf-8?Q?Paul_F=C3=B6rster?= writes:
>> seems, I found some kind of solution:
>
>> - before running "pg_upgrade --check -k":
>> drop extension plpythonu;
>> - run pg_upgrade
>> - after the upgrade:
>> create extension plpython3u;
>
Hi Tom,
> On 26. Sep, 2020, at 16:07, Tom Lane wrote:
>
> If you had plpythonu installed before, that's a plausible thing
> to do. (There was discussion some time ago about making the
> python-2-to-3 transition less painful for users, but we failed
> to come to any consensus about how; so manua
1 - 100 of 196 matches
Mail list logo