On Sun, Apr 4, 2021 at 10:02:20AM -0400, Dave Cramer wrote:
> On Sun, 4 Apr 2021 at 09:12, Bruce Momjian wrote:
> > OK, that makes sense, but I think it is wrong minded to think that this
> > absolves one of taking isolation into account.
> >
> > When
On Mon, Apr 5, 2021 at 02:32:36PM -0400, Dave Cramer wrote:
> On Mon, 5 Apr 2021 at 14:18, Bruce Momjian wrote:
> I think we are in agreement. My point was that WITH queries don't change the
> isolation semantics.
My point is that when you combine individual queries in a sin
odify the same row, the results are unspecified.
and the quoted paragraph suggests that your query should not work.
However, you are not referencing the foo table directly, but via
referential integrity check, which I guess does work.
--
Bruce Momjian https://momjian.us
EDB
is for PG-12, not for HEAD). Will
> update later today.
>
> But yes, putting it into the next commitfest after initial discussion is the
> plan.
Uh, were either of these things done?
--
Bruce Momjian https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.
removed in PG 12.
> - Other upgrade methods (clone/dump) fails with the same errors.
OK, so the problem is really pg_dump.
> Anyone seen similar issue?
Nope, something very odd going on here.
--
Bruce Momjian https://momjian.us
EDB http
> a part of, and then reinstall an updated version after upgrading?
Yeah, Tom, I think you are on to something. I couldn't figure out where
the r.relhasoids was referenced in the rest of the log output, but if it
is on the lines that are part of CREATE VIEW, it certainly could be the
case th
e 3 to physically get rid of the column. We formerly left the
* column in place physically, but this caused subtle problems. See
* http://archives.postgresql.org/pgsql-hackers/2009-02/msg00363.php
*/
--
Bruce Momjian https://momjian.us
EDB
DE;
Great to hear, thanks.
--
Bruce Momjian https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.
t;
>
> Our current application deployments (every 3 weeks) require about 30min
> downtime. We are now tasked of making this 0 downtime.
I suggest you decide how much downtime you can accept or consider
multi-master replication:
https://momjian.us/main/blogs/pgblog/2018.html#December_2
create a function named bidule and not myfunc.
> so I am obviously missing something too obvious.
You can't create functions inside of functions; same for procedures.
--
Bruce Momjian https://momjian.us
EDB https://enterprisedb.com
On Thu, Jun 3, 2021 at 03:21:15PM -0400, Tom Lane wrote:
> Adrian Klaver writes:
> > On 6/3/21 12:01 PM, Bruce Momjian wrote:
> >> On Thu, Jun 3, 2021 at 08:58:03PM +0200, Marc Millas wrote:
> >>> within a function, I want to create another function.
>
> >
https://www.postgresql.org/about/policies/trademarks/
bo...@lists.postgres.ca
--
Bruce Momjian https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.
On Thu, Jun 3, 2021 at 06:08:42PM -0400, Tom Lane wrote:
> Bruce Momjian writes:
> > On Thu, Jun 3, 2021 at 09:31:15PM +, tom.beacon wrote:
> >> What is the best contact with whom to discuss possible violations of the
> >> pgsql
> >> license?
>
>
$LD_LIBRARY_PATH:/usr/lib/9.6/lib
The problem is clearly using the wrong version of the libpq libary.
--
Bruce Momjian https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.
lier email in saying that "don't top-post"
or "bottom-post" is not clear enough in explaining how to properly
"trim-post", as you stated. Some people trim-post automatically, while
others have never thought about it since their communication is al
lso know the answer. I also can't figure out how people can use
streaming chat for complex, multi-day communication since it feels just
like top-posting email.
--
Bruce Momjian https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.
Yeah, everyone at school would smell the stack of papers as they passed
them back. When I realized it was methanol and isopropanol that made me
like the smell, I realied how much chemicals could affect my behavior.
--
Bruce Momjian https://momjian.us
EDB
On Sat, Jul 3, 2021 at 09:05:58PM +0530, Rama Krishnan wrote:
>
> Hi Team,
>
> How can I split read and write queries using pgbouncer
No. I think only PgPool can do that because it parses the SQL.
--
Bruce Momjian https://momj
that are almost insane!
Also, pg_upgrade will throw an error if copying from one version to the
same version if there are tablespaces since the tablespace directory
name is the catalog version name.
--
Bruce Momjian https://momjian.us
EDB https://
es and make
> them perform.
I think you can write a SECURITY DEFINER function that calls SET, call
that function at login.
--
Bruce Momjian https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.
s your best bet for poking local
> exceptions into that policy.
The nice thing about SECURITY DEFINER is that the super user controls
what values it can be set to.
--
Bruce Momjian https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.
_user can't do that for himself, a superuser
> can.
Ah, yes, I hadn't considered that ALTER USER bypasses those user checks.
--
Bruce Momjian https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.
the current config - which I suppose
> will help with the connection pooling etc. But even it lends caution to the
> multi-master route for write heavy applications.
You might want to read this:
https://momjian.us/main/blogs/pgblog/2018.html#December_24_2018
--
Bruce
connection management and load balancing.
> >
> > Regards
> > Vikas S
> >
> >
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
> https://dbwhisperer.wordpress.com
>
>
>
--
Bruce Momjian https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.
On Wed, Aug 18, 2021 at 09:50:32AM +, Pansara, Jiten wrote:
> Hello Team,
>
>
>
> I am executing below command to copy data but it is throwing error. Can anyone
> help please?
I think you want to contact the ora2pg project, not us.
--
Bruce Momjian https:
m pg_settings where name = 'log_statement'
> Does this mean all statements by any user on any database in that server are
> getting logged? This is for auditing purposes.
Yes.
--
Bruce Momjian https://momjian.us
EDB https://enterprise
d/or blogs, you will have to read them to
> figure out which one suits you best.
Yes, I think the reason there are only third-party failover tools is
that failover is very tied to the operating system/network details, and
the database usually doesn't focus on those.
--
Bruce
Budweiser or Miller
> products.
I am a root beer guy! And of course, the beer/root beer angle is just a
joke, Many companies use Postgres for many purposes, resell, modify,
etc, with no payment or requirements.
--
Bruce Momjian https://momjian.us
EDB
l not charge
> a fee to us to distribute it.
You are not the first person to be confused by this; see this email
thread from 2003:
https://www.postgresql.org/message-id/a3c9d941f0a3761cc68adad1b4334...@biglumber.com
--
Bruce Momjian https://m
On Thu, Aug 19, 2021 at 04:07:52PM +0200, Magnus Hagander wrote:
> On Thu, Aug 19, 2021 at 2:34 AM Bruce Momjian wrote:
> >
> > On Wed, Aug 18, 2021 at 12:47:26PM -0700, Bryan Boone wrote:
> > > Ah okay thank you. I think what was confusing me was the “without fee”.
>
er zone, so the easy way of "assume it's all local time" doesn't
> cut it.
I wrote a blog about this:
https://momjian.us/main/blogs/pgblog/2017.html#September_27_2017
--
Bruce Momjian https://momjian.us
EDB https://ent
ecuted ---
log_min_duration_statment prints them after execution. You can verify
this by running:
SET log_statement = 'all';
SELECT pg_sleep(430);
and then looking in the log file.
--
Bruce Momjian https://momjian.us
EDB h
pg_upgrade's check mode checks as much as it reasonable can, but it
doesn't try restoring the database schema, for performance reasons, and
that is where the failure is happening.
--
Bruce Momjian https://momjian.us
EDB https://enterprise
more problems than expected.
>
> Having worked with PostgreSQL on ZFS I wouldn't generally recommend it as a
> general tool.
I know ZFS has a lot of features/options, and some of those can cause
corruption, so if you modify ZFS options, you need to be sure they don't
aff
r.
Once that is done, the changes on the publisher are sent to the subscriber
as they occur in real-time. The subscriber applies the data in the same
order as the publisher so that transactional consistency is guaranteed for
publications within a single subscription. This method of data r
e recreated on the new server. I think we
suggested delete then create so that the functions would not be called
accidentally on the new server before being recreated.
--
Bruce Momjian https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.
nk you for you help.
>
> here is the query the i have wrote so far:
> select team.id, nickname,color
> from team,points,game
> where (team.tid = game.vtid and (vscore - hscore ) < 0) or (game.htid =
> team.tid and (hscore - vscore )< 0 )
> having
--
Bruce Momjian
On Mon, Nov 15, 2021 at 09:30:03AM -0500, Bruce Momjian wrote:
>
> Due to time constraints, I do not directly answer general PostgreSQL
> questions. For assistance, please join the appropriate mailing list and
> post your question:
>
> https://www.postgresql.org/comm
ges per year. I plan to store in
> bytea format in an isolated table. Is this recommended? Is there another
> better
> way?
You might want to read this:
https://momjian.us/main/blogs/pgblog/2020.html#June_19_2020
--
Bruce Momjian https://momjian.us
EDB
me around $800 monthly.
>
> Do you guys know by any chance a similar solution cheaper or even open source?
Uh, this should help:
https://wiki.postgresql.org/wiki/Monitoring
--
Bruce Momjian https://momjian.us
EDB https://enterprise
2012.html#July_9_2012
https://momjian.us/main/presentations/performance.html#optimizer
--
Bruce Momjian https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.
_id FROM ...
> and
> SELECT *, - b.a_id FROM ...
>
> Maybe
> SELECT * EXCEPT b.a_id FROM ...
Yes, this was proposed on hackers a few months ago and a patch was
proposed:
https://www.postgresql.org/message-id/flat/892708.1634233481%40sss.pgh.pa.us#1f17923ad50a1442
7;d be practical or useful to emit a warning when
> granting permissions on an object that already has a grant of
> the same permissions to PUBLIC. That would at least cue people
> who don't understand about this behavior that they ought to look
> more closely.)
Agreed.
--
Br
t; concurrency models are another factor.
What I found with QUEL was that simple things were easier than SQL, but
things like aggregates and subqueries were harder, confusing. or
impossible.
--
Bruce Momjian https://momjian.us
EDB https://ente
lso processed 282 unsubscriptions from
> people who managed to read and work with the instructions.
Maybe we need an "unsubscribe" email list. ;-)
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
pgrade_utility.log"
> 2>&
> 1
>
> *failure*
> "c:\EMC\AppSync\jboss\datastore_96\engine\bin/pg_ctl" -w -D
> "c:\EMC\AppSync
> \jboss\datastore_96\data" -o "" -m fast stop >> "pg_upgrade_utility.log"
&g
of digging in the git history says that the check was added here:
> >
> > commit 453d74b99c9ba6e5e75d214b0d7bec13553ded89
> > Author: Bruce Momjian
> > Date: Fri Jun 10 03:02:30 2005 +
> >
> > Add the "PGPASSFILE" environment variable to s
pletes, rather than when it starts, which is what
log_statement does.
And, yes, using %c to match up lines will work too.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+
What's wrong with PGPASSWORD?
> > https://www.postgresql.org/docs/current/libpq-envars.html
>
> `ps auxe` shows all processes with their environments, no?
I think that only shows for super-user.
--
Bruce Momjian https://momjian.us
EDB h
issive. I don't know what camp MacOS falls into.
Yes, I thought this was fixed long ago.
--
Bruce Momjian https://momjian.us
EDB https://enterprisedb.com
When a patient asks the doctor, "Am I going to die?", he means
"Am I going to die soon?"
t Postgres version, so 16.x.
> >
> > 2) OS and version.
>
> Also good to know if this is running in a virtualized environment that
> does not allow or support SysV IPC.
>
> > 3) Where did you get the Postgres package from?
>
> --
> Erik
--
Bruce Momjian https://momjian.us
EDB https://enterprisedb.com
When a patient asks the doctor, "Am I going to die?", he means
"Am I going to die soon?"
t; server itself from psql?
>
> regards,
>
> Alexander Al
>
>
>
>
>
>
>
> --
> Death to , and butter sauce.
> Don't boil me, I'm still alive.
> crustacean!
--
Bruce Momjian https://momjian.us
EDB
On Sat, Nov 23, 2024 at 03:24:47PM -0500, Ron Johnson wrote:
> On Sat, Nov 23, 2024 at 1:10 PM Bruce Momjian wrote:
> [snip]
>
> I have to admit, for this question, we just point people to:
>
> https://www.postgresql.org/support/versioning/
>
> and
ments are.
I have blogged about this confusion:
https://momjian.us/main/blogs/pgblog/2023.html#September_1_2023
--
Bruce Momjian https://momjian.us
EDB https://enterprisedb.com
When a patient asks the doctor, "Am I going to die?", he means
"Am I going to die soon?"
On Sat, Nov 23, 2024 at 01:30:13PM -0500, Greg Sabino Mullane wrote:
> On Sat, Nov 23, 2024 at 1:10 PM Bruce Momjian wrote:
>
> and say bounce the database server and install the binaries. What I
> have never considered before, and I should have, is the complexity of
>
ribed land
> not easy to do. For the two released versions of our software (V7.2 and
> V7.3) and the current version in development (V7.3-SP1) we plan the
> following migrations of the server and client side of PostgreSQL:
I have to admit, for this question, we just point people to:
s already possible to configure libpq to refuse such requests
> (see require_auth parameter), although that hasn't been made the
> default.
Agreed. I think weakening the MD5 handshake to switch to a more secure
hash algorithm is unwise.
--
Bruce Momjian https://momjian.us
ED
The email said:
The survey takes only about 5-10 minutes and is completely
anonymous.
and it clearly is not "completely anonymous". You can say you are not
collecting email addresses, but they certainly are being collected as
part of this process.
--
Bruce Mom
ommit messages
> https://wiki.postgresql.org/wiki/Commit_Message_Guidance
>
> I also find it useful for mailing list messages
I just take https://postgr.es/m/ and append the Message-id header from
the email, and have never seen it fail.
--
Bruce Momjian https://momjian.us
EDB
the /var/lib/postgresql/10/
> main you created out of the way and then move the contents back in to
> the installed version.
>
>
> Forgot to say, be sure and retain a copy of the original 10 $DATADIR
> somewhere where you can fetch it should the
On Wed, Jun 11, 2025 at 01:07:11PM -0700, David G. Johnston wrote:
> On Wednesday, June 11, 2025, Bruce Momjian wrote:
>
> On Wed, Jun 11, 2025 at 11:59:24AM -0700, Jim Cunning wrote:
> > I configured the PGDG repository and tried to install postgresql-10 on
> my
>
201 - 261 of 261 matches
Mail list logo
