2024年10月31日(木) 0:32 alexander al (leiden) :
>
> Hi,
>
> we have a supplier (via our client) who has an self build PAAS-version
> of postgresql. Ok, you would say, that's fine. But, there is always an
> but, we think the settings are not quite ok. We really want to know how
> much memory etc there i
2024年9月7日(土) 9:55 Gus Spier :
>
> I find myself in new territory, Foreign Data Wrappers (FDW). I stumble closer
> to success through the documentation, youtube videos, and various google
> resources. But I've come across a concept that intrigues me very deeply.
>
> If I understand the concepts co
2024年5月29日(水) 6:10 Sumit Kochar :
>
> Installation of Foreign data Wrapper on EDB Postgres to connect to SQL server
> database is not working.
>
>
>
> https://github.com/tds-fdw/tds_fdw/issues/357
>
>
>
> Please advise if this has been encountered or a workaround is available.
(...)
> [root@hosti
2024年4月10日(水) 21:40 Matthias Apitz :
>
> El día miércoles, abril 10, 2024 a las 09:08:56 +0900, Ian Lawrence Barwick
> escribió:
>
> > > # cat postgresql151/data/postgresql.auto.conf
> > > # Do not edit this file manually!
> > > # It will be
Hi
2024年4月10日(水) 20:10 Matthias Apitz :
(...)
> End of March I started to investigate the TDE extension pg_tde within
> the 16.2 server. And only this software contains this extension:
>
> # find /usr/local/sisis-pap/pgsql** | grep pg_tde
> /usr/local/sisis-pap/pgsql-16.2/lib/pg_tde.so
> /usr/loca
2024年1月14日(日) 14:53 Lan Xu :
>
> With CREATE EXTENSION unaccent, I’m getting the following:
> ERROR: extension "unaccent" has no installation script nor update path for
> version “1.0"
>
> But I can find it under /usr/share/pgsql/extension/unaccent001.0.sql
For recent PostgreSQL versions, the ex
2023年12月11日(月) 18:09 Ayush Vatsa :
>
> Hello, PostgreSQL community,
> I'm reaching out to you about an issue I've had while trying to configure
> PostgreSQL by cloning its files from the GitHub repository.
> During the configuration process, I encountered an error message that
> appeared to be re
2023年10月13日(金) 20:47 Luca Ferrari :
>
> Hi all,
> in version 16 psql does not show anymore the "member of" group
> information when showing users with \du.
>
> The query (still working fine) in previous versions was:
>
> SELECT r.rolname, r.rolsuper, r.rolinherit,
> r.rolcreaterole, r.rolcreatedb,
ay (but if it's a fork,
that still won't
that mean oracle_fdw will compile against it)
HTH
Ian Barwick
>
> On Wed, Aug 23, 2023 at 2:04 PM Ian Lawrence Barwick
> wrote:
>
>> 2023年8月23日(水) 12:47 Christophe Pettus :
>> >
>> >
>> >
>> &g
2023年8月23日(水) 12:47 Christophe Pettus :
>
>
>
> > On Aug 22, 2023, at 19:57, Jethro Elmer Sanidad
> > wrote:
> >
> > Hello,
> >
> > I tried both the 1.5.0 and 2.0.0. Both returned error during 'make'
> > command. Please see below:
>
> The API between PostgreSQL and foreign data wrappers has chan
2023年7月11日(火) 2:45 Nathan Bossart :
>
> On Fri, Jun 30, 2023 at 02:56:08PM -0700, Nathan Bossart wrote:
> > Over in pgsql-hackers, I've proposed removing the db_user_namespace
> > parameter in v17 [0]. I am personally not aware of anyone using this
> > parameter, but I wanted to give folks an oppo
2023年6月10日(土) 14:30 Wen Yi <896634...@qq.com>:
>
> Hi team,
> I use the source to install the postgresql 15.3 (Fedora Linux 37), I create a
> install.sh as this:
>
> install.sh:
>
> sudo rm -r /home/postgres/pgsql
> sudo mkdir /home/postgres/pgsql
> sudo rm -r /home/postgres/pgsql/lib
> sudo mkdir
2023年5月29日(月) 12:39 Wen Yi <896634...@qq.com>:
>
> Hi team,
> when I study the generate_series function, I found that it can not only
> generate the number series but also can generate the date series.(ref:
> https://www.postgresql.org/docs/current/functions-srf.html)
> That means I can make the
2023年4月25日(火) 21:42 Matthias Apitz :
>
>
> Hello,
>
> We're using the above DBD::Pg version on Linux together with PostgreSQL 15.1
> On fetch empty char columns are returned as (Perl) 'undef'
>
> while ( my @row_ary = $dba->FetchArray()) {
>foreach my $i (0
2023年4月6日(木) 0:02 Steve Rogerson :
>
> On 05/04/2023 11:23, Erik Wienhold wrote:
> > Judging by the commit message and changed test cases, probably:
> >
> > https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=921d749bd4c34c3349f1c254d5faa2f1cec03911
> >
> That's the one. I can't see whic
2023年3月22日(水) 8:47 Vince McMahon :
>
> Is there cluster on postgres? Or, there is replication, not cluster.
>
> If there is active/passive cluster or active/active , may I have the steps to
> configure them?
See here for details about PostgreSQL's built-in streaming replication.
https://www
2023年2月28日(火) 22:30 Albert Cornelius :
>
> How can I quit a currently running query? I've issued a query and my server
> does not respond anymore. Is there another solution than using kill -9?
See here:
https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL
Regar
2023年2月19日(日) 9:51 Christophe Pettus :
>
>
>
> > On Feb 18, 2023, at 15:49, Bryn Llewellyn wrote:
> >
> > I’ve searched in vain for an account of how "autocommit" mode actually
> > works.
>
> I realize now I may have misinterpreted your question... apologies if so! If
> you mean the BEGIN and C
2023年1月19日(木) 8:50 Erik Wienhold :
>
> > On 19/01/2023 00:09 CET Hilbert, Karin wrote:
> >
> > I manage some PostgreSQL clusters on Linux. We have a Primary & two Standby
> > servers & for Production, there is also a DR server. We use repmgr for our
> > HA
> > solution & the Standbys are cloned f
2022年11月10日(木) 14:16 Adrian Klaver :
>
> On 11/9/22 20:57, Ian Lawrence Barwick wrote:
> > 2022年11月10日(木) 13:41 Igor Korot :
> >>
> >> Hi, ALL,
> >> According to
> >> https://chartio.com/resources/tutorials/how-to-list-databases-and-tables-in-po
2022年11月10日(木) 13:41 Igor Korot :
>
> Hi, ALL,
> According to
> https://chartio.com/resources/tutorials/how-to-list-databases-and-tables-in-postgresql-using-psql/,
> there are generally 3 system DBs.
>
> However I'm confused with the word general.
> How many system databases can be made on a PG se
2022年11月5日(土) 10:02 Ian Lawrence Barwick :
>
> 2022年11月5日(土) 7:59 Brad White :
...
> > Interestingly, the recovery file says
> > # Note that recovery.conf must be in $PGDATA directory.
> > # It should NOT be located in the same directory as postgresql.conf
> > Those s
2022年11月5日(土) 7:59 Brad White :
>
> I'm setting up a backup for our primary postgres server using the archived
> WAL files.
> Then I'll try to upgrade it to Streaming Replication.
> Then I'll upgrade the system to v.latest.
> For now, we are on v.9.4.
>
> I do a base backup from the primary to a d
2022年10月27日(木) 11:00 David G. Johnston :
>
> On Wed, Oct 26, 2022 at 6:33 PM Bryn Llewellyn wrote:
>>
>> The descriptive designation "the role that owns the SQL part of the
>> implementation of PostgreSQL" is too much of a mouthful for daily use.
>
>
> Don't think it's documented but I like "boot
2022年10月17日(月) 16:36 Rama Krishnan :
>
> Hi all,
>
> What Is the difference between dblink and foreign data wrapper?
Basically, dblink enables you to execute individual queries on a remote
PostgreSQL server via a function and use the results in a local query e.g.:
SELECT *
FROM dblink('my
2022年9月8日(木) 17:37 BeginnerC :
>
> Hello community,
> I am checking my pg_stat_activity view,but something confused me.
> Just like this:
>
> postgres=# SELECT wait_event_type, wait_event FROM pg_stat_activity;
> wait_event_type | wait_event
> -+-
> Activit
2022年6月9日(木) 14:32 Peter Adlersburg :
>
> Dear fellow DBA's,
>
>
> While troubleshooting one of our production replication clusters (phys.
> streaming replication using the patroni framework)
> I stumbled over a - at least for me - strange phenomenon in the postgres logs
> of the two cluster memb
2022年6月8日(水) 19:51 Jim McNamara :
>
> Hi -
>
> Does anyone use the gawk extension? I think it is the coolest thing.
>
> I see that it installed .so files on my system from the fedora package
> manager but there is no .sql file or control file in the extension directory.
>
> I searched with kfind u
2022年5月18日(水) 23:07 Wiwwo Staff :
>
> Hi!
> i might be doing something wrong, but I cannot see what...
>
> Server is 14.3 (Debian 14.3-1.pgdg110+1)
> (at the time of writing, in Dockerfile FROM postgres:14)
>
> I have a 3 node cluster, starting with pg_red (172.26.0.2) as primary.
> I promote pg_gr
2022年5月10日(火) 13:28 正华吕 :
>
> Hi,
>
> I test the following SQL in pg15dev (seems same behavior as the previous
> version).
>
> select '2020701'::date;
> date
>
> 0202-07-01
>(1 row)
>
>At the first glance, the result seems quite strange.
>
>Go through th
2022年4月26日(火) 23:24 Laurenz Albe :
>
> On Tue, 2022-04-26 at 06:59 -0700, David G. Johnston wrote:
> > On Tue, Apr 26, 2022 at 6:55 AM Robert Lichtenberger
> > wrote:
> > > When executing "SELECT * FROM pg_stat_activity" I get lots of rows that
> > > have an empty "query" column.
> > >
> > > Acco
2022年3月2日(水) 23:49 DAN LU :
>
> Hello,
>
> I am hoping someone can help me regarding upgrading PG to the latest release
> that has replication setup via repmgr.
>
> Here is an example of my current setup:
> Server A: PostgreSQL 12.1 serving as the "primary" role managed by repmgr 5.1
> (https://re
2022年1月12日(水) 20:16 Amine Tengilimoglu :
>
> Hi;
>
> I want to read an external pdf file from postgres. pdf file will exist
> on the disk. postgres only know the disk full path as metadata. Is there any
> software or extension that can be used for this? Or do we have to develop
> software
2021年9月9日(木) 16:53 Tim Uckun :
>
> This seems simple enough but it's not working.
>
> alter database dbname set "blah.blah" = 'test_value' ;
>
> The above statement returns with no errors.
>
> select current_setting('blah.blah')
>
> The above statement returns a record with null
Open a new databa
2021年5月21日(金) 20:42 Vijaykumar Jain :
>
> PostgreSQL: Documentation: 13: 37.17. Packaging Related Objects into an
> Extension
>
> so it works as expected.
> someone would have to point to the reference wrt modification of data in
> objects created via extension.
If you want to be able to dump da
2021年5月5日(水) 10:43 Tiffany Thang :
>
> Hi,
>
> I'm having trouble finding in the documentation the steps to install the
> postgres extensions such as pg_stat_statements and pg_trgm on PG13.1/CentOS7.
> Can someone please assist?
>
>
> postgres=# create extension pg_stat_statements;
>
> ERROR: co
2021年2月22日(月) 8:42 David G. Johnston :
> On Sun, Feb 21, 2021 at 4:38 PM Guyren Howe wrote:
>
>> The documentation says that inet_server_addr() does this, but on our
>> servers it is returning nothing.
>>
>
> "Returns the IP address on which the server accepted the current
> connection, or NULL i
2021年2月18日(木) 20:21 Luca Ferrari :
> Hi all,
> running on 12.5, but I guess this does not mind, I cannot understand
> when the value of pg_stat_archiver.stats_reset field is modified.
> I've executed a pg_stat_reset() but it did not affected the specified
> field.
> I suppose that field is not "re
2021年2月12日(金) 20:01 Luca Ferrari :
> Hi all,
> I'm running 11.5 and I'm monitoring pg_stat_progress_vacuum every 2
> seconds, while doing from another connection per-table VACUUMs. Every
> vacuum last 30 or more seconds, so I was expecting to see a record
> within pg_stat_progress_vacuum, but noth
2021年2月7日(日) 4:07 Gabriel Martin :
> Hello,
>
> I know that since the launch of pgAdmin 4 in 2016, pgAdmin has been using
> a web-based model, as announced as early as 2014. You only need to do a
> little research on the Web to understand all the reasons behind this
> choice, which I do not seek t
2021年2月5日(金) 3:52 Pavan Pusuluri :
> Hi there
>
> We are trying to drop a table space on RDS Postgres . We have removed the
> objects etc, but it still won't drop.
>
> I have checked and there's no reference anywhere to this tablespace but it
> complains it's not empty.
>
> I checked if it is a de
2021年2月2日(火) 12:06 Jain, Ankit :
(...)
> But got the following error –
>
> ERROR: could not load library "/usr/pgsql-13/lib/plugin_debugger.so":
> /usr/pgsql-13/lib/plugin_debugger.so: undefined symbol: LWLockAssign SQL
> state: 58P01
>
>
>
> Can you please help with getting the debugger working ?
2021年1月21日(木) 9:19 Mohamed Wael Khobalatte :
>
>
> On Wed, Jan 20, 2021 at 2:37 PM 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.
>>
>
> I suppose the Atul's issue i
2020年12月26日(土) 20:19 Markur Sens :
>
> Hello,
>
> I'm trying to build a few data pipelines with Unix tools but can't figure out
> how to insert in a slurp mode (e.g. not COPY line by line) content inside a
> variable.
>
> Consider the following script (using a heredoc)
>
> json_url="https://f
2020年10月22日(木) 11:51 Hou, Zhijie :
>
> Hi
>
> My PostgreSQL 10.3 in Centos7.4 exited abnormally and generated core.dump.
>
> I want to analyze the core.dump but I does not find
> postgresql10-debuginfo-10.3 in
> https://download.postgresql.org/pub/repos/yum/debug/10/redhat/rhel-7.4-x86_64/
>
> Can
2020年10月21日(水) 20:54 Matthias Apitz :
>
>
> Hello,
>
> I've found the following problem using psql 11.4 against a server 13.0:
>
> $ export LANG=en_US.UTF-8
> $ psql -Usisis -dsisis
> psql (11.4, server 13.0)
> WARNING: psql major version 11, server major version 13.
> Some psql features m
2020年10月19日(月) 16:22 Atul Kumar :
>
> Hi,
>
> I am configuring repmgr, so in postgresql.conf when i changed the
> parameter share_preload_libraries='repmgr', my database server is not
> starting.
>
> When i comment that parameter, database server started.
>
>
> Please help why that parameter is sto
2020年10月17日(土) 23:25 Atul Kumar :
>
> Hi,
>
> I have 3 different servers, i want to configure streaming replication
> (1 master and 2 slaves) using repmanager.
>
> Please share the installation and configuration steps for the same.
>
> Note: the steps should be organized.
I suggest starting with t
2020年8月16日(日) 15:32 Andrus :
(...)
> PostgreSQL 9.3.5 is used.
Unable to help with the query, but assuming that's not a typo can I be
among the first to urge you to at the very least update to 9.3.25,
which contains almost half-a-decade's worth of fixes, many critical?
See: https://why-upgrade.de
2020年8月4日(火) 14:54 Stelios Sfakianakis :
> On 4 Aug 2020, at 06:25, Ian Lawrence Barwick wrote:
>
> 2020年8月4日(火) 1:24 Stelios Sfakianakis :
>
> Hi,
>
>>> I am trying to implement a FDW in Postgres for accessing a web api and I
>>> would like to keep informati
2020年8月4日(火) 1:24 Stelios Sfakianakis :
>
> Hi,
>
> I am trying to implement a FDW in Postgres for accessing a web api and I
> would like to keep information like for example the total number of requests
> submiited. Ideally these data should be kept “per-user” and of course with
> the proper l
2018年12月20日(木) 21:58 Rijo Roy :
>
> Thanks sk for replying Ian.. I have one inactive replication slot in the
> database. I suspected that could be the cause but was not sure of it. Could
> you please tell me what I should be doing in this case. Can I drop the
> replication slot since it is no mo
2018年12月20日(木) 19:56 Deepti Sharma S :
> Hello Team,
>
>
>
> Can you please let us know which version of PostgreSQL DB is compatible
> with RHEL7.6 and if not available when we can expect the same.
>
Community packages for all community-supported PostgreSQL versions (at the
time of writing: 9.4 ~
2018年12月20日(木) 21:18 Rijo Roy :
>
> Hi All,
>
> I am facing an issue with wal recycling in one of my Postgresql servers
> running ina rhel box and the PG version is 10. The issue is that wal files
> are not recycling at all. Please note that its a qa server and the load is
> quite high on it. It
2018年11月15日(木) 17:19 Andreas Kretschmer :
>
> Am 15.11.2018 um 08:54 schrieb Sathish Kumar:
> > We would like to migrate our Postgresql VM instance on Google Cloud
> > Platform to Google Cloud SQL with a minimal downtime. As I checked, we
> > have to export and import the SQL file and our database
55 matches
Mail list logo
