Hi All,
I am trying to upgrade Postgresql 11.5 to 12 RC1, OS Centos 6. Running
pg_upgrade with --check it fails with "Checking for reg* data types in user
tables" The table listed are: pg_ts_dict,pg_ts_parser. Trying to drop the
tables I get msg " permission denied: "pg_ts_dict" is a system catalo
from the original article:
> For example, the PostgreSQL speeds depend on the Django ORM code
> that makes the SQL and sends the query and then turns it into the model
instance.
> I don't know what the proportions are between that and
> the actual bytes-from-PG's-disk times. But I'm not sure I care
Hi,
On Fri, 2019-09-27 at 09:38 -0400, Tom Lane wrote:
> It doesn't surprise me so much that the contrib package does, though.
> Most likely, that includes the plpython transform modules
> (hstore_plpython, jsonb_plpython, etc), which are certainly going to
> depend on whichever libpython PG was
SELECT * FROM pg_extension;
extname, extversion
plpgsql,1.0
pg_stat_statements,1.6
pg_trgm,1.4
tablefunc,1.0
unaccent,1.1
pageinspect,1.7
--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
This select gives me:
ERROR: more than one function named "pg_catalog.day_inc"
--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
On 9/30/19 5:48 AM, PegoraroF10 wrote:
This select gives me:
ERROR: more than one function named "pg_catalog.day_inc"
In psql:
\df pg_catalog.day_inc
Or if you cannot get to psql then the query behind the above:
SELECT n.nspname as "Schema",
p.proname as "Name",
pg_catalog.pg_get_functi
your select returns no records but if I use
WHERE p.proname ~ 'day_inc'
instead of
WHERE p.proname OPERATOR(pg_catalog.~) '^(pg_catalog.day_inc)$'
Schema
Name
Result data type
Argument data types
Type
pg_catalog
day_inc
anyelemen
On 9/30/19 7:28 AM, PegoraroF10 wrote:
your select returns no records but if I use
WHERE p.proname ~ 'day_inc'
instead of
WHERE p.proname OPERATOR(pg_catalog.~) '^(pg_catalog.day_inc)$'
Yeah I was not paying attention to what it was really looking for, the
function name.
The list of extensio
Adrian Klaver writes:
> The list of extensions that you sent earlier are fairly common. I would
> not expect them to be contributing to the below otherwise there would
> have been more reports of what you are seeing.
A quick "grep" shows that there is nothing named "day_inc" in core
Postgres no
Following the indications found here:
https://joelonsql.com/2013/04/27/securing-postgresql-using-hostssl-cert-clientcert1/
I created and modified these files:
CA:
root@pc:/home/marco# ls -lah /etc/ssl/private/fabric_ca.key
-rw-r- 1 root ssl-cert 1.8K Sep 30 14:50 /etc/ssl/private/fabric_ca.key
Hi Adrian,
important update.
After adding in fabric-ca-server-config.yaml
ca:
# Name of this CA
name: fabric_ca
# Key file (is only used to import a private key into BCCSP)
keyfile: /etc/ssl/private/fabric_ca.key
# Certificate file (default: ca-cert.pem)
certfile: /etc/ssl/certs/fabri
It seems it does, only 10 and 11 as of this:
"We support Postgres 10 and Postgres 11. "
https://cloudblogs.microsoft.com/opensource/2019/05/06/introducing-pg_auto_failover-postgresql-open-source-extension-automated-failover-high-availability/
On Sat, Sep 28, 2019 at 8:44 AM Sonam Sharma wrote:
>
I didn't specify the real problem as it's all wrapped up in layers and I
didn't want to post a "can someone write the query for me". The real
problem was I have a table with a string holding comma separated numbers,
and needed to go to a lookup table and replace each of those numbers with
it's cor
> "David" == David Salisbury writes:
David> I didn't specify the real problem as it's all wrapped up in
David> layers and I didn't want to post a "can someone write the query
David> for me". The real problem was I have a table with a string
David> holding comma separated numbers, and need
*Hello All,*
We are in process of testing a Postgres 9.6 active-passive HA cluster using
streaming replication on Rhel 7.5.
We are seeing below issue with the setup :
1. When a failover is triggered while data is being added to the primary
by killing primary (killall -9 postgres), the failed no
Andrew Gierth writes:
> "Tom" == Tom Lane writes:
> Tom> Hmm. I think this is a reasonable direction to go in, but
> Tom> what about groupingSets and rowMarks?
> groupingSets ultimately contains nothing but numbers which are
> meaningless without reference to the matching groupClause list. So
On Mon, Sep 30, 2019 at 11:15:47AM +0200, Gerrit Fouche wrote:
>
> Hi All,
>
> I am trying to upgrade Postgresql 11.5 to 12 RC1, OS Centos 6. Running
> pg_upgrade with --check it fails with "Checking for reg* data types in user
> tables" The table listed are: pg_ts_dict,pg_ts_parser. Trying to dr
On Mon, Sep 30, 2019 at 11:15:47AM +0200, Gerrit Fouche wrote:
>
> Hi All,
>
> I am trying to upgrade Postgresql 11.5 to 12 RC1, OS Centos 6. Running
> pg_upgrade with --check it fails with "Checking for reg* data types in user
> tables" The table listed are: pg_ts_dict,pg_ts_parser. Trying to dr
Hi,
The documentation (https://www.postgresql.org/docs/10/ddl-alter.html) clearly
states that adding a column with a default requires updating all the rows in
the table, to store the new column value (this is prior to PG11, obviously).
I can understand why this behaviour was required when addin
Thank you very much.
On Mon, Sep 30, 2019 at 10:33 PM Bruce Momjian wrote:
> On Mon, Sep 30, 2019 at 11:15:47AM +0200, Gerrit Fouche wrote:
> >
> > Hi All,
> >
> > I am trying to upgrade Postgresql 11.5 to 12 RC1, OS Centos 6. Running
> > pg_upgrade with --check it fails with "Checking for reg*
Joe Horsnell writes:
> The documentation (https://www.postgresql.org/docs/10/ddl-alter.html) clearly
> states that adding a column with a default requires updating all the rows in
> the table, to store the new column value (this is prior to PG11, obviously).
> Obviously the desired effect of ad
Thanks for the quick response Tom.
Cheers,
Joe.
On 30/09/2019, 22:19, "Tom Lane" wrote:
Joe Horsnell writes:
> The documentation (https://www.postgresql.org/docs/10/ddl-alter.html)
clearly states that adding a column with a default requires updating all the
rows in the table, to st
Hello,
Which line(s) in the perl build files would I modify to generate Visual
Studio project files with the /MD flag set to include the vcruntime lib for
example?
Thank you,
Nicolas
23 matches
Mail list logo
