tats_per_shift_filtered definition is a different object from
utlog.stats_per_shift_filtered_u0206?
I am totally out of clues. Any help would be appreciated. Thanks.
Regards,
Ben
intended to show just a small set of
them.
But you are right, I should be more cautious. Thanks for the headsup.
Regards,
Ben
On 9/16/20 3:35 PM, Magnus Hagander wrote:
On Wed, Sep 16, 2020 at 9:26 AM Ben <mailto:benten...@outlook.com>> wrote:
Dear list,
Recently I am getting
cern is that if there are other views inside that database having similar
integrity issue, how can I find them all (if any).
It's beyond my regular SQL ability. I guess I really need help from people with
maintenance experience.
Any help will be appreciated, thanks in advance.
Ben
On Sep
20-07-01 13:22:58+08 | 2020-07-01 | D | 5 | S00 | F02 | {PDCB}
(5 rows)
)
The result in returned column looks different but
definition of the column in question (wspan::float8) looks identical in
both case.
Regards,
Ben
On 9/17/20 10:41 PM, Jerry Sievers wrote:
Ben writes
Not to come in too late, but have you tried the non-ubuntu:
sudo su
su -m postgres
pg_ctl -D /var/lib/postgresql/9.3/main start
cheers
Ben
On 29 March 2018 at 12:20, Adrian Klaver wrote:
> On 03/28/2018 07:29 PM, Ken Beck wrote:
>
> Comments in line.
>
> The current log i
On May 7, 2018, at 7:46 AM, Ayappan P2 wrote:
>
> Hi All,
>
> We are using Postgresql in AIX. Unlike some other databases, Postgresql has
> lot of other process running in the background along with the main process.
>
> We do "renice" only on the Postgres main process. Is it sufficient to hav
uided assumption is that I am effectively re-using a check
constraint across the schema.
Is this crazy?
Am I missing the point of how Postgres stores TIMEZONE WITH TIME ZONE
internally?
Thanks in advance,
Ben
Sorry about the bug in the subject: the data type is TIMESTAMP WITH TIME ZONE,
not TIMEZONE WITH TIME ZONE
> On 10 May 2018, at 09:03, Ben Hood wrote:
>
> Hi,
>
> I'm using a domain to specialize the built in TIMEZONE WITH TIME ZONE type. I
> want to sanity che
> On 10 May 2018, at 09:59, Francisco Olarte wrote:
>
> On Thu, May 10, 2018 at 10:03 AM, Ben Hood wrote:
> ...
>> Am I missing the point of how Postgres stores TIMEZONE WITH TIME ZONE
>> internally?
>
> After reading in the follow up TIMEZONE is a ty
> On 10 May 2018, at 11:36, Karsten Hilbert wrote:
>
> On Thu, May 10, 2018 at 11:19:36AM +0100, Ben Hood wrote:
>
> I dare say it is one of PG's strengths' to be usable as a
> "linter”.
Interesting that you share this view, because after thinking about
> On 10 May 2018, at 14:41, Adrian Klaver wrote:
>> OK, so by using TIMESTAMP WITH TIME ZONE, you force all apps to submit
>> timezone qualified timestamps in what language they are written in.
>
> Not really:
>
> https://www.postgresql.org/docs/10/static/datatype-datetime.html
>
> "For times
> On 10 May 2018, at 15:12, Vick Khera wrote:
>
> On Thu, May 10, 2018 at 7:31 AM, Ben Hood <mailto:b...@relops.com>> wrote:
> Or are we saying that domains are one way of achieving the timestamp hygiene,
> but equally, you can get the same result as described above
> On 10 May 2018, at 15:17, Karsten Hilbert wrote:
>
>> Not really:
>>
>> https://www.postgresql.org/docs/10/static/datatype-datetime.html
>>
>> "For timestamp with time zone, the internally stored value is always in UTC
>> (Universal Coordinated Time, traditionally known as Greenwich Mean Ti
> On 10 May 2018, at 15:33, Tom Lane wrote:
>
> Ben Hood writes:
>> So the question is not how does the timestamp get stored, rather, is it an
>> anti-pattern to use Postgres as a linter for apps that forget to use UTC
>> exclusively?
>
> Well, usi
> On 10 May 2018, at 18:29, Adrian Klaver wrote:
>
> Per my previous post a timestamp with timezone is going to be stored as UTC,
> so there is no ambiguity there. On reflection I realized your concern maybe
> with determining the original input timezone. That information is not stored
> by
> On 10 May 2018, at 17:35, David G. Johnston
> wrote:
>
> '2018-05-10T15:23:00-07:00'::timestamptz is unambiguous
That is true. Mandating UTC is not the only way to eliminate ambiguity.
Apologies for appearing to suggest that this is case.
>
> Allowing client applications to represent
> On 10 May 2018, at 17:38, Adrian Klaver wrote:
>
> Well if you are using a timestamp with timezone field the value is always
> going to be stored as UTC. The TimeZone setting just determines the rotation
> from the input value to the stored value and the reverse. My previous point
> was j
> On 10 May 2018, at 16:33, Francisco Olarte wrote:
>
> For what you want to do I think you'll have to parse the text value,
> maybe by definig a view with a text columns and using some
> rule/trigger magic for insert / updates.
Sorry for being unclear - the solution I have in production appea
> On 10 May 2018, at 22:17, Peter J. Holzer wrote:
>
> I don't understand how this can work. As Francisco demonstrated,
> EXTRACT(TIMEZONE FROM ts) doesn't extract the time zone from the value
> ts, it reports the offset of the client's time zone.
Yes, you and Francisco are right.
If you do:
> On 10 May 2018, at 23:43, Adrian Klaver wrote:
>
> Trying to tame time and time zones is maybe quixotic, but not weird.
Quixotic is a very good description, I’d happily admit that using the UTC
domain in this way is not as pragmatic as I thought it would when I introduced
it.
> While I was
> On May 7, 2018, at 11:50 PM, Ayappan P2 wrote:
>
> We are doing "renice" on the main Postgresql process to give higher
> scheduling priority because other critical operations depends on the database.
> You are saying that the database processes take longer to relinquish their
> resources an
Hi - this is a spreadsheet model, not a database model, and could be
modelled with three columns.
The aggregate functions are an analytic issue, not a data issue.
cheers
Ben
On 30 August 2018 at 17:13, a <372660...@qq.com> wrote:
> Hi all:
>
> I need to make a table con
Hey everybody, I'm having trouble getting constraint exclusion to work on a
table partitioned with a tsrange type. I've distilled it down to this:
create table t (
id serial primary key,
observed_window tsrange not null
);
create index t_window on t(observed_window);
create table p1 (like t
ms it thusly:
SELECT (((mytable.ajsonbcolumn -> ‘somedata’::text) -> ‘nested’::text) ->>
‘first_name’::text) AS fname FROM mytable
(note the ::text casts).
Why does it do this? It seems unnecessary and pollutes my SQL with a ton of
extra text.
Thanks for your thoughts. -Ben
***
it means I’ll have to manually change an
aggregating “parent” view’s select lists every time I change the “child” views.
Thanks for any info. -Ben
*** PLEASE NOTE *** This E-Mail/telefax message
and any documents accompanying this transmission may contain
r.
To get around it all you have to do is script a drop and replace action.
A last word - if you have nested views, remember that they are essentially
just query aliases that return an unindexed result set...
cheers
Ben
On 16 October 2018 at 03:50, Ben Uphoff wrote:
> Hey team – I’m sure
Do you have adequate disk space left on your array?
cheers
Ben
On 15 October 2018 at 17:46, Joshua White wrote:
> Hi all,
>
> I'm hoping someone can point me in the right direction. I've got a
> PostgreSQL 10 server instance on CentOS 6, which I set up and manage. I
&g
On Sep 5, 2019, at 2:00 PM, Judith Lacoste wrote:
>
> Hi,
>
> I plan to install the database on a server in the office. Me and my four
> colleagues will occasionally connect to this database when we are working in
> other locations (usually hospitals or universities). In such remote
> locatio
s a zero-length record? (this does seem to mitigate the error - see
attached patch)
Thanks,
Ben
0001-Fix-pg_rewind-when-divergence-is-at-end-of-WAL.patch
Description: Binary data
ppened or how I can fix this issue?
I had the issue once on another server and running VACUUM FULL on entire
database fixed the error.
Note: I ran "VACUUM FREEZE ANALYZE" before the upgrade on every database
and there were no errors.
Ben Snaidero
*Geotab*
Senior Database Specialist
On Sep 29, 2019, at 8:44 PM, Ron wrote:
>
> On 9/29/19 8:09 PM, Steve Litt wrote:
>> On Mon, 30 Sep 2019 07:46:14 +1000
>> Nathan Woodrow wrote:
>>
>>> Redis is a in memory database so I would except it to be always much
>>> faster..
>> Is there a way to have Redis periodically update an on-dis
ts ;-)
>
> regards, tom lane
>
>
>
--
[image: Ausvet Logo] <https://www.ausvet.com.au/>
Dr Ben Madin
BVMS MVPHMgmt PhD MANZCVS GAICD
Managing Director
Mobile:
+61 448 887 220 <+61448887220>
E-mail:
b...@ausvet.com.au
Website:
www.ausvet.com.au
Skype: benmadin
Address:
5 Shuffrey Street
Fremantle, WA 6160
Australia
We have a few busy 9.5 dbs, both streaming to a few slaves each. The
master and slaves are identical hardware and are getting no small amount
of load - about 45k transactions/s on the master and ~36k transactions/s
on the slave actively serving clients. During these busy times, queries
are all
Igor Polishchuk wrote on 5/30/20 9:33 PM:
Hello,
I need to replicate Postgresql 9.6 to AWS RDS Postgresql 12.2 with
pg_logical.
AWS RDS Pg 12.2 (target) only supports pg_logical 2.3.0.
Can I use v2.3.1 on the source and v2.3.0 on the target?
We had lots of issues with pglogical when we accid
gt; $BODY$ language sql immutable;
>
> but if string contains % character,
>
> select val('1,2%')
>
> returns 0.
>
> How to force it to return 1.2 ?
>
> It should work starting from Postgres 9.0
>
> Posted also in
>
>
> https://stackoverfl
We have a few hundred postgres servers in AWS EC2, all of which do
streaming replication to at least two replicas. As we've transitioned
our fleet to from 9.5 to 12.3, we've noticed an alarming increase in the
frequency of a streaming replica dying during replay. Postgres will log
something lik
Alvaro Herrera wrote on 8/1/20 9:35 AM:
On 2020-Aug-01, Ben Chobot wrote:
We have a few hundred postgres servers in AWS EC2, all of which do streaming
replication to at least two replicas. As we've transitioned our fleet to
from 9.5 to 12.3, we've noticed an alarming incre
Kyotaro Horiguchi wrote on 8/2/20 9:39 PM:
At Sat, 1 Aug 2020 09:58:05 -0700, Ben Chobot wrote in
All of the cited log lines seem suggesting relation with deleted btree
page items. As a possibility I can guess, that can happen if the pages
were flushed out during a vacuum after the last
Ben Chobot wrote on 8/1/20 9:58 AM:
Alvaro Herrera wrote on 8/1/20 9:35 AM:
On 2020-Aug-01, Ben Chobot wrote:
Can you find out what the index is being modified by those LSNs -- is it
always the same index? Can you have a look at nearby WAL records that
touch the same page of the same index in
Alvaro Herrera wrote on 8/3/20 12:34 PM:
On 2020-Aug-03, Ben Chobot wrote:
Yep. Looking at the ones in block 6501,
rmgr: Btree len (rec/tot): 72/ 72, tx: 76393394, lsn:
A0A/AB2C43D0, prev A0A/AB2C4378, desc: INSERT_LEAF off 41, blkref #0: rel
16605/16613/60529051 blk 6501
rmgr
Peter Geoghegan wrote on 8/3/20 11:25 AM:
On Sun, Aug 2, 2020 at 9:39 PM Kyotaro Horiguchi
wrote:
All of the cited log lines seem suggesting relation with deleted btree
page items. As a possibility I can guess, that can happen if the pages
were flushed out during a vacuum after the last checkpo
Alvaro Herrera wrote on 8/1/20 9:35 AM:
On 2020-Aug-01, Ben Chobot wrote:
Can you find out what the index is being modified by those LSNs --
is it
always the same index? Can you have a look at nearby WAL records that
touch the same page of the same index in each case?
They turn out to be
/page.6501
Ben might find this approach to dumping out a single page image
easier, since it doesn't involve relfilenodes or filesystem files:
https://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD#contrib.2Fpageinspect_page_dump
I don't think th
Alvaro Herrera wrote on 8/3/20 2:34 PM:
On 2020-Aug-03, Ben Chobot wrote:
Alvaro Herrera wrote on 8/3/20 12:34 PM:
On 2020-Aug-03, Ben Chobot wrote:
Yep. Looking at the ones in block 6501,
rmgr: Btree len (rec/tot): 72/ 72, tx: 76393394, lsn:
A0A/AB2C43D0, prev A0A/AB2C4378
pt to grep the lines
we need out of the list of the current dump, not re-use the same list file?
cheers
Ben
--
[image: Ausvet Logo] <https://www.ausvet.com.au/>
Dr Ben Madin
BVMS MVPHMgmt PhD MANZCVS GAICD
Managing Director
Mobile:
+61 448 887 220 <+61448887220>
E-mail:
b...
Thanks Tom and Adrian,
The clarity is helpful - We'll run up a solution to specifically choose the
elements.
cheers
Ben
On Sat, 15 Aug 2020 at 00:45, Tom Lane wrote:
> Ben Madin writes:
> > " Is the index number ( the archive ID) assigned at the time of creation
> &g
Alvaro Herrera wrote on 8/3/20 4:54 PM:
On 2020-Aug-03, Ben Chobot wrote:
Alvaro Herrera wrote on 8/3/20 2:34 PM:
On 2020-Aug-03, Ben Chobot wrote:
dd if=16605/16613/60529051 bs=8192 count=1 seek=6501 of=/tmp/page.6501
If I use skip instead of seek
Argh, yes, I did correct that in my
messages on commit:
https://www.postgresql.org/message-id/3598.1363354686%40sss.pgh.pa.us
If that's the case, the real question is why a small number of those
commits are taking so much longer than expected. Any advice on how to
proceed from here much appreciated.
Cheers
Ben Hoskings
---
The observed outage
unless we can convince Google to run it for
us :)
I wonder if there are any likely candidates that we could look into -
for example, is it possible it could be due a batched index update
that we could alleviate with "fastupdate=off"?
Cheers
Ben
(grasping at straws here...)
> wraparound of the file names back to ?
We don't have filesystem access on Cloud SQL - the downside of the
managed route :)
It sounds like it might be time to bump the pg13 upgrade up the TODO list.
Cheers
Ben
x27;m not sure that rl_set_screen_size is a good replacement for reset, and I
realise that this might be about the apple readline libs... do I need to
install another version of readline, or is there somewhere else I should be
looking? )and can I assume given the proximity of the second error, that it
he build script still failed at
the same point showing the same error citing the readline/history.h from
the apple SDK's... is there something else I have to do to ensure it uses
the ones on the PATH and specified in the configure?
cheers
Ben
On Mon, 1 Mar 2021 at 12:50, Tom Lane wrote:
Sascha Zenglein wrote on 11/2/22 7:56 AM:
Hi all,
I want to use the postgres-native logical replication to have multiple
clients receive and send data to a central database.
Real-time is far less important than network usage, and with my
current test setup it appears both instances communicate
8.325 rows=5 loops=1)
Index Cond: ((id > 193208795) AND (id <= 575187488))
Planning Time: 0.166 ms
Execution Time: 402.376 ms
We have tried leading the planner to water with this view but it did not
change the slow query plan:
create view my_fast_large_table as
select *
from my_large_table
where id is not null;
Any other tricks to try here?
Thank you,
Ben Chrobot
Thank you all for your responses!
I will continue to put pressure on the vendor (Stitch Data, if anyone knows
folks there) to address the issue on their end with the query being issued.
Best,
Ben Chrobot
On Tue, Feb 14, 2023 at 11:11 PM Tom Lane wrote:
> David Rowley writes:
> > O
- DBA Stack Exchange - PostgreSQL equivalent to Oracle's MAX(...) KEEP
(DENSE_RANK FIRST/LAST ORDER BY ...)
<https://dba.stackexchange.com/a/324429/100880>
Thanks,
-Ben
>
(https://dba.stackexchange.com/a/324646/100880)
GitHub: https://github.com/wulczer/first_last_agg
Reason: As a non-dba, I can’t install additional modules like first_last_agg
.
Thanks,
-Ben
thing like
this:
SELECT country
, count(*) AS ct_cities
, max(population) AS highest_population
, last(city ORDER BY population, city) AS biggest_city -- !FROM
citiesGROUP BY countryHAVING count(*) > 1;
-Ben
On Mon, Mar 6, 2023 at 9:51 PM David Rowley wrote:
> On Tue, 7 M
Inzamam Shafiq wrote on 3/24/23 4:07 AM:
Hi Team,
Hope you are doing well.
Can someone please list pros and cons of MariaDB vs PostgreSQL that
actually needs serious consideration while choosing the right database
for large OLTP DBs (Terabytes)?
That's a very broad question, which will take
al
time=0.002..0.004 rows=9 loops=2082)
Index Cond: (inodeid = n1ne_1.iid)
Heap Fetches: 13973
Planning time: 4.860 ms
Execution time: 16442.462 ms
(26 rows)
Thanks in advance
Ben.
On Thu, Jan 17, 2019 at 4:13 PM David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Thu, Jan 17, 2019 at 9:19 AM Ben Snaidero
> wrote:
> > Any ideas as to why this is happening?
>
> Not really, I would expect roughly double execution time, not an
> expon
On Feb 28, 2019, at 8:04 AM, Stephen Frost wrote:
>
> Greetings,
>
> * Julie Nishimura (juliez...@hotmail.com) wrote:
>> Hello everybody, I am new to postgresql environment, but trying to get up to
>> speed.
>> Can you please share your experience on how you can automate refreshment of
>> dev
> On Mar 4, 2019, at 1:59 PM, Julie Nishimura wrote:
>
> Hello,
> Our current master 9.2 has two active standbys. Can you please help me out
> with the right sequence of events if we would like to promote one of current
> standbys to master and convert master to standby?
It depends on how yo
> On Mar 6, 2019, at 5:58 AM, Nanda Kumar
> wrote:
>
> Hello Team,
>
> I would like to know where I can monitor the ddl and dml operations happens
> in the production environment .
The documentation is your friend, particularly
https://www.postgresql.org/docs/9.6/runtime-config-logging.htm
Or you can just use `ilike`:
SELECT * FROM emp WHERE ename ilike 'aaa';
https://www.postgresql.org/docs/10/sql-select.html#SQL-WHERE
cheers
Ben
On Thu, 28 Mar 2019 at 16:24, Sameer Kumar wrote:
>
>
> On Thu, 28 Mar, 2019, 4:20 PM Sridhar N Bamandlapally, <
> sri
where multiple partitions are detached in 1
statement.
This is using version 12 beta 1.
Many thanks,
Ben
PostmasterMain+0x275
postgres.exe!main+0x480
postgres.exe!pgwin32_popen+0x144f
KERNEL32.DLL!BaseThreadInitThunk+0x14
ntdll.dll!RtlUserThreadStart+0x21
Any ideas on changes in Postgres 10 that would cause this? We were
previously running 9.6.7 and didn't encounter this issue on that version
either.
On Thu, Jun 27, 2019 at 2:34 PM Tom Lane wrote:
> Ben Snaidero writes:
> > I am running into a strange issue with Postgres 10 when using pg_dump
> with
> > the directory format and jobs parameter set it intermittently hangs.
> Seems
> > to occur less frequent
On Thu, Jun 27, 2019 at 3:19 PM Tom Lane wrote:
> Ben Snaidero writes:
> > Do these stack traces shed help at all?
>
> None worth mentioning :-(. Can you rebuild with debug symbols?
>
> regards, tom lane
>
So I've rebuilt with debug sym
Mohsin Kazmi wrote on 6/9/23 3:38 AM:
Now in order to deploy PostgreSQL in our production servers, I need to
configure it in Active Active mode. Can anyone help me to do so?
We don't need multi-master postgres very often, but when we do, we find
the open source bucardo project works fairly wel
We certainly have databases where far more than 100 tables are updated
within a 10 second period. Is there a specific concern you have?
Jeremy Schneider wrote on 6/27/23 9:01 AM:
Question for other PostgreSQL users
On your moderately busy DB, how many different tables might receive at
least o
Jeremy Schneider wrote on 6/27/23 11:47 AM:
Thank Ben, not a concern but I'm trying to better understand how common
this might be. And I think sharing general statistics about how people
use PostgreSQL is a great help to the developers who build and maintain it.
One really nice thing
Laurenz Albe wrote on 6/28/23 5:27 AM:
On Wed, 2023-06-28 at 07:19 -0400, Rita wrote:
seems like I may need to deploy pgbouncer for my webapp. should i deploy it on
the db server or on the webserver?
On the database server. You don't want network latency between pgbouncer and
PostgreSQL,
so
Rita wrote on 7/7/23 9:23 AM:
I have an application that does many db calls from a server farm.
I've increased my max connections on postgresql to 1000 and tuned the
server accordingly. However, I still get can't connect to postgresql
some times. I installed pgbouncer on few servers in the fa
Rita wrote on 7/8/23 4:27 AM:
I am not sure if it allows transaction pooling.
Well, take the time to figure it out. With transaction pooling enabled,
you can get away with a much lower number of server connections. For
example, our application regularly has thousands of clients connected to
ser, or is another step required?
Or (quite possibly) have I misunderstood something else?
Many thanks,
Ben Hancock
PostgreSQL 14.3
On Thu, 27 Jul 2023 06:09:28 -0700
"David G. Johnston" wrote:
> On Thursday, July 27, 2023, Ben Hancock wrote:
> >
> >
> > Should the CREATEDB privilege be inherited when granting the 'admins'
> > role to a user, or is another step required?
&
convenient to view the the manual for the version of Postgres that is on
the system, right there. Does one exist?
--
Ben Hancock
ing or fetching the HTML
locally may also work. In terminal environment, I suppose one could use
`lynx` or similar to navigate around.
- Ben
available by
the PostgreSQL project? It appears so, but I'd like ensure my purchase
goes toward supporting the project in some small way.
Also, is anyone aware whether these printed manuals are available from
any other booksellers online?
Thanks,
- Ben
s is useful for someone else. Thanks again for your help
Tom - your advice on listen/notify locking on commit was very useful
despite not being the cause in this case.
Cheers
Ben
On Mon, 1 Feb 2021 at 12:33, Ben Hoskings wrote:
>
> On Mon, 1 Feb 2021 at 10:33, Tom Lane wrote:
> &
Your connection string will work as long as there is a DNS entry for
PGServer.
Your pg_hba.conf will however need to have an IP address/netmask. So if you
are connecting from within your local network, you can put something like:
hostssl all all 192.168.0.0/16 md5
Hth?
On W
Rama Krishnan wrote on 7/3/21 8:35 AM:
Hi Team,
How can I split read and write queries using pgbouncer
You do it with your application. Make a pgbouncer database for
read/write queries and point it at your postgresql primary, and then
make a second pgbouncer database for read-only queries a
I'm really, really liking the multirange types in PG14. Thank you for
making them! Unfortunately I am struggling with how to loop over the
segments of a multirange. There doesn't seem to be a way to convert them
to arrays, and I can't just use plpgsql's FOREACH on one. Am I missing
something ob
hubert depesz lubaczewski wrote on 7/15/21 5:15 AM:
select * from regexp_matches(_YOUR_MULTIRANGE_::text, '[\[(][^\])]+[\])]', 'g');
I wrote more, including explanation, and ready-to-use function, in here:
https://www.depesz.com/2021/07/15/how-to-get-list-of-elements-from-multiranges/
So ugly
27; | psql new_database
this is presuming a space before the schemaname, and a fullstop between
schema and other elements.
cheers
Ben
On Sat, 24 Jul 2021 at 01:38, Mayan wrote:
> Hi,
>
>
>
> I had a general question about a feature that we depended on heavily when
> using other R
Bryan Boone wrote on 8/18/21 11:39 AM:
Can someone tell me if I am able to use PostgreSQL for the small
company I work for?
Yes, you are.
We've noticed that the Ubuntu postgresql-12 package has --with-llvm
enabled on x86_64, but not on aarch64. Does anybody know if this was
intentional, or just an oversight?
For what it's worth, it seems the beta postgresql-14 package for Ubuntu
still doesn't have --with-llvm.
I'm not sure if
Thomas Munro wrote on 9/14/21 5:50 PM:
On Tue, Sep 14, 2021 at 10:11 AM Ben Chobot wrote:
We've noticed that the Ubuntu postgresql-12 package has --with-llvm
enabled on x86_64, but not on aarch64. Does anybody know if this was
intentional, or just an oversight?
For what it's worth
er).
TITLE=WFS
1: BOMEC_15_Class_WFS:BOMEC_15_Class (title: BOMEC_15_Class) (Multi Surface)
not very helpful, but a 400 error might be some kind of encoding problem
with request?
cheers
Ben
On Tue, 5 Oct 2021 at 14:18, Brent Wood wrote:
> Hi,
>
> Apologies, this not strictly a Postgre
Two thoughts:
1. Can the user view the tables when connecting through another database
program (ie psql or PgAdmin)?
2. Does the user have access to the database schema that has the PostGIS
extension (normally public schema)?
cheers
Ben
On Thu, 14 Oct 2021 at 19:00, celati Laurent
wrote
Rita wrote on 11/10/21 1:25 PM:
Hello.
I am testing alerting on my primary and standby setup. I have async
replication working but I would like to temporarily pause it so the
value of 'state' isn't streaming. (select * from pg_stat_replication).
How can I do that?
By reading the fine manua
Rita wrote on 11/10/21 5:36 PM:
Yes, I have read the manual and seen this. It pauses the replication
(select pg_is_wal_replay_paused()). But on the primary, when I look at
pg_stat_replication, it still says 'streaming' in the state column. My
question was how do I get it from 'streaming' to an
Saurav Sarkar wrote on 11/29/21 10:13 PM:
Hi All,
We have some multi-tenant solutions which are separating the tenant
data in Postgresql mainly in the following manner.
1. Using different schemas
2. Using different tables for different tenants.
Without more details it's impossible to give y
Saurav Sarkar wrote on 11/30/21 7:08 PM:
So are all the schemas on one DB or are distributed/sharded across
multiple DBs ?
In our use case, every db entirely homes one or more schemas. Some dbs
host many schemas for small customers, some dbs host a handful of
schemas for medium customers, and s
Mladen Gogala wrote on 11/30/21 7:52 PM:
To my knowledge PostgreSQL doesn't support sharding, which is well and
good because sharding is mostly useless, at least in my opinion.
OK I'll bite.
Not only does PostgreSQL natively support table partitioning (which is
absolutely a form of shardin
Hello pgsql-general,
I've been tasked with scanning our Ubuntu-hosted databases for NIST
800-53v4 compliance. I'm finding a paucity of tools out there that will
do this. I found a few that might work, when pointed at Postgres 9 on
RHEL, but not much else.
Is this a problem anybody else has t
We do a lot of queries per day, over a lot of hosts, all of which are on
12.9. We've recently started doing a better job at analyzing our db logs
and have found that, a few times a day, every day, we see some of our
queries fail with errors like:
could not open relation with OID 201940279
In
Michael Paquier wrote on 1/26/22 9:14 PM:
On Wed, Jan 26, 2022 at 05:30:01PM -0800, Ben Chobot wrote:
Other things we've considered:
- we run pg_repack, which certainly seems like it could make an error
like this, but we see this error in places and times that pg_repack isn't
nnou...@postgresql.org in the
lists the Before email was sent to. Can I assume that that list
continues under the old regime?
Ben
--
Ben Coleman
CTO, Accelerated Design, Inc.
(678) 337-8899
signature.asc
Description: OpenPGP digital signature
1 - 100 of 121 matches
Mail list logo
