This is FreeBSD 11.3, with postgres installed from ports as 10.10.
There is included a daily utility doing pg_dump:
: ${daily_pgsql_pgdump_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port} -bF
c"}
pg_dump ${daily_pgsql_pgdump_args} -f ${file} ${db}
Recently I did a restore of some database
Long story short:
pg_dump just forgets to backup the grant on schema public. :(
Long story:
After searching for half an hour to get some comprehensive listing
of permissions (which was in vain) I tried with pgadmin3 (which is
indeed a life-saver and still somehow works on 10.10 - and that's
t
Hi Adrian,
okay, lets check these out:
> What is ${daily_pgsql_user} equal to?
postgres. The owner of the installation.
> I am not seeing -U postgres.
> Are you sure there is not something else specifying the user e.g. env
> PGUSER?
I'm sure. The log shows the nightly backup connections as
po
Hello Tom,
thank You very much.
> We improved that situation in v11, I believe. What I see for this
> case these days is per commit 5955d9341:
> [...]
Ah, well. I don't fully understand that, but as the iessue appears to
be known, then that is fine with me.
This thing is just bad if one neve
Hi folks,
with 12.1, after a couple of queries, at a random place, the clientlib
does produce a failed query without giving reason or error-message [1].
Then when retrying, the clientlib switches off signal handling and
sits inactive in memory (needs kill -9).
The server log shows no error or oth
On Thu, Jan 09, 2020 at 01:48:01PM -0500, Tom Lane wrote:
! Peter writes:
! > with 12.1, after a couple of queries, at a random place, the clientlib
! > does produce a failed query without giving reason or error-message [1].
! > Then when retrying, the clientlib switches off signal han
On Thu, Jan 09, 2020 at 10:47:00AM -0800, Adrian Klaver wrote:
!
! Might want to take at below:
!
! https://github.com/ged/ruby-pg/issues/311
Thanks a lot! That option
> gssencmode: "disable"
seems to solve the issue.
But I think the people there are concerned by a different issue: they
are bot
On Thu, Jan 09, 2020 at 04:31:44PM -0500, Tom Lane wrote:
! Peter writes:
! > flowmdev=> select * from flows;
! > message type 0x44 arrived from server while idle
! > message type 0x44 arrived from server while idle
! > message type 0x44 arrived from server while idle
!
! Oh ...
Hi all,
I have something that looks a bit insane:
# ps axl | grep 6145
UID PID PPID CPU PRI NI VSZRSS MWCHAN STAT TT TIME
COMMAND
770 6145 1 0 20 0 241756868 select SsJ - 0:24.62
/usr/local/bin/postgres -D
770 6147 6145 0 23 0 243804 10
On Mon, May 04, 2020 at 12:55:38PM -0700, Adrian Klaver wrote:
! > The 90206 is continuously growing. It is the unspecific, all-purpose
! > worker for the www.bareos.com backup tool, so it is a bit difficult to
! > figure what precisely it does - but it tends to be rather simple
! > straight-forwa
On Tue, May 05, 2020 at 10:57:04AM +1200, Thomas Munro wrote:
! On Tue, May 5, 2020 at 10:13 AM Peter wrote:
! > BTW, I would greatly appreciate if we would reconsider the need for
! > the server to read the postmaster.pid file every few seconds (probably
! > needed for something, I d
On Tue, May 05, 2020 at 11:59:27AM -0400, Tom Lane wrote:
! Well, the choice we face is preventing somebody's disk from spinning
! down, versus preventing somebody else from completely corrupting their
! database. From where I sit that's not a difficult choice, nor one
! that I feel a need to let
Hi all,
this is a 12.2 Release on FreeBSD 11.3.
I am doing RedoLog Archiving according to Docs Chapter 25.1.
During the last week I have lost 4 distinct Redo Logs; they are
not in the backup.
Loosing a RedoLog is very bad, because there is no redundancy,
loosing a single one of them makes the
On Mon, Jun 08, 2020 at 05:40:20PM -0700, Peter Geoghegan wrote:
!
! I strongly suspect that you were hit by the bug fixed in commit
! 4e87c483. You should upgrade to Postgres 12.3 ASAP, to get that fix:
!
! "Avoid premature recycling of WAL segments during crash recovery
! (Jehan-Guillau
Actually, the affair had some good side: as usual I was checking
my own designs first and looking for flaws, and indeed I found one:
If you do copy out the archive logs not directly to ta
On Mon, Jun 08, 2020 at 09:21:47PM -0700, Adrian Klaver wrote:
!
! On 6/8/20 7:33 PM, Peter wrote:
! >
! > Actually, the affair had some good side: as usual I was checking
! > my own designs first and looking for flaws, and indeed I found one:
! > If you do copy out the archive logs
On Tue, Jun 09, 2020 at 01:27:20AM -0400, Tom Lane wrote:
! Adrian Klaver writes:
! > On 6/8/20 7:33 PM, Peter wrote:
! >> That "cp" is usually not synchronous. So there is the possibility
! >> that this command terminates successfully, and reports exitcode zero
! >
rance shops)
would usually run Informix or Oracle. Postgres is just my own private
fancy.
On Tue, Jun 09, 2020 at 03:42:48PM -0400, Stephen Frost wrote:
! * Peter (p...@citylink.dinoex.sub.org) wrote:
! > This professional backup solution also offers support for postgres.
! > Sadly, it only cove
On Tue, Jun 09, 2020 at 03:42:48PM -0400, Stephen Frost wrote:
! > And then 90% of the things offered here become superfluous, because
! > they are already handled site-wide. And then you will have to
! > consider integration of both pieces - and that will most likely be
! > more work and more erro
On Wed, Jun 10, 2020 at 01:10:36PM +0200, Magnus Hagander wrote:
! > Just having a look at their webpage, something seems to have been updated
! > recently, they now state that they have a new postgres adapter:
! >
! > https://www.bareos.com/en/company_news/postgres-plugin-en1.html
! > Enjoy readi
On Wed, Jun 10, 2020 at 08:32:22AM -0400, Stephen Frost wrote:
! > What repo?? I seem to have missed that at first glance.
!
! Yes, pgbackrest has a repo, like most other tools (though they call them
! different things... pg_basebackup has one though it's not really
! formal).
!
! > Are You inde
On Thu, Jun 11, 2020 at 10:53:15PM +0200, Laurenz Albe wrote:
! On Thu, 2020-06-11 at 22:35 +0200, Magnus Hagander wrote:
! > I believe somebody around that time also wrote a set of bash scripts that
can be used in a pre/post-backup-job combination with the current APIs.
!
! https://github.com/cy
On Sat, Jun 13, 2020 at 01:53:28PM +0200, Laurenz Albe wrote:
! > I've never seen anybody coding bash - it is strongly shunned in the
! > Berkeley community.
!
! Strange, but then I don't move in these circles.
Never mind.
! > Some Questions:
! > 1. There are explicit error messages in loc-82
On Thu, Jun 11, 2020 at 10:35:13PM +0200, Magnus Hagander wrote:
! > Okay. So lets behave like professional people and figure how that
! > can be achieved:
! > At first, we drop that WAL requirement, because with WAL archiving
! > it is already guaranteed that an unbroken chain of WAL is always
! >
On Mon, Jun 15, 2020 at 11:44:33AM +0200, Laurenz Albe wrote:
! On Sat, 2020-06-13 at 19:48 +0200, Peter wrote:
! > ! > 4. If, by misconfiguration and/or operator error, the backup system
! > ! > happens to start a second backup. in parallel to the first,
! > ! > t
On Mon, Jun 15, 2020 at 03:19:29PM +0200, Laurenz Albe wrote:
! On Mon, 2020-06-15 at 14:50 +0200, Peter wrote:
! > ! An example:
! > !
! > ! - Backup #1 calls "pgpre.sh"
! > ! - Backup #1 starts copying files
! > ! - Backup #2 calls "pgpre.sh".
! >
On Sun, Jun 14, 2020 at 03:05:15PM +0200, Magnus Hagander wrote:
! > You can see that all the major attributes (scheduling, error-handling,
! > signalling, ...) of a WAL backup are substantially different to that
! > of any usual backup.
!
! > This is a different *Class* of backup object, therefo
On Mon, Jun 15, 2020 at 09:46:34PM +0200, Laurenz Albe wrote:
! On Mon, 2020-06-15 at 19:00 +0200, Peter wrote:
! > And that is one of a couple of likely pitfalls I perceived when
! > looking at that new API.
!
! That is a property of my scripts, *not* of the non-exclusive
! backup API...
In modern versions of postgres a simple SELECT writes a couple
of millions of individual temp files into a single directory under
pgsql_tmp.
I know of no filesystem that would take such lightly, and even
ZFS gets some problems with such extremely long directories.
What is the rationale in this beh
On Sat, Apr 23, 2022 at 02:11:00PM -0700, Adrian Klaver wrote:
! On 4/23/22 12:50, Peter wrote:
!
!
! > People seem to have been brainwashed by Web-Services and OLTP,
! > and now think the working set must always fit in memory. But this
! > is only one possible usecase, it i
numbers of temp files in hash joins. Whether
| there's more to do, or Peter is running a version that lacks those
| fixes, is impossible to tell with the given info.)
Yes, I was accidentially deleting that info too when I deleted the
more extensive rants from my original posting. See here, above.
Hello,
this is postgres version 12.11_1 on Freebsd 13.1
I have a table "mess", filename "6309215", that behaves strange.
Data is currently only inserted/appended, there is no update and no
(successful) delete done, autovacuum is NOT enabled.
This is the definition:
CREATE TABLE IF NOT EXISTS
I had a look into what actually changed in the table. At the first
write that I grabbed, four rows in that segment had such a change:
117ee000 77 00 00 00 00 df b8 82 8e a4 00 00 64 00 a0 00 |w...d...|
117ee000 77 00 00 00 f0 22 b4 f3 68 d3 00 00 64 00 a0 00 |w"..h...d...|
117
On Wed, Aug 10, 2022 at 09:25:37AM +0200, m...@ft-c.de wrote:
Hi Franz,
You will get much better targeted help with such questions
at https://forums.freebsd.org (if it is FreeBSD you're running) or
in German on https://www.bsdforen.de/ (for all tastes of Berkekey).
Something is apparently wrong
Well, like others mentioned before, it is not getting fully clear
what You are trying to achieve. But, in any case, if this is Your
problem
On Thu, Sep 01, 2022 at 06:01:02PM -0400, Jeffrey Walton wrote:
! Hi Everyone,
!
! We are having a heck of a time getting PostreSQL utilities to honor
Hi,
imagine I have a database containing normalized data: a whole bunch
of tables all related via foreign keys (i.e. the thing one should
usually have ;) ).
So there is a dependency graph: all records relate to others in
some tree-like fashion (has-many, belongs-to, etc.)
Now I want to grab so
TL;DR Version:
==
For a table where all rows have been deleted, under certain conditions
the planner does assume that it contains the values that were
previousely present, and will therefore assume that nothing needs to
be added, while in fact everything needs to be added.
-
This
CREATE DATABASE ttc
WITH
OWNER = admin
ENCODING = 'UTF8'
LC_COLLATE = 'de_DE.UTF-8'
LC_CTYPE = 'de_DE.UTF-8'
TABLESPACE = pg_default
CONNECTION LIMIT = -1
IS_TEMPLATE = False;
select version();
PostgreSQL 12.13 on amd64-portbld-freebsd13.1, compiled by FreeBSD clang
On Mon, Feb 13, 2023 at 12:38:12PM -0500, Tom Lane wrote:
! Peter writes:
! > "rows=1" in the "Hash Anti Join" line is WRONG. It should be
! > 300. Or at least some thousands.
!
! FWIW, this behaves better in v14 and up. In older versions there's
! an ambiguit
On Mon, Feb 13, 2023 at 12:38:12PM -0500, Tom Lane wrote:
! Peter writes:
! > "rows=1" in the "Hash Anti Join" line is WRONG. It should be
! > 300. Or at least some thousands.
!
! FWIW, this behaves better in v14 and up. In older versions there's
! an ambiguit
Good morning,
I just found Autovacuum run for 6 hours on a 8 GB table, VACUUM query
doesnt cancel, cluster doesn't stop, autovacuum worker is not
killable, truss shows no activity, after kill -6 this backtrace:
* thread #1, name = 'postgres', stop reason = signal SIGABRT
* frame #0: 0x
On Mon, May 27, 2024 at 11:25:47AM +0200, Laurenz Albe wrote:
! On Sat, 2024-05-25 at 12:51 +0200, Peter wrote:
! > I just found Autovacuum run for 6 hours on a 8 GB table, VACUUM query
! > doesnt cancel, cluster doesn't stop, autovacuum worker is not
! > killable, truss shows no a
On Mon, May 27, 2024 at 01:51:56PM +0200, Laurenz Albe wrote:
! > ! Apart from hardware problems, one frequent cause is upgrading glibc
! > ! (if the index on a string column or expression).
! >
! > No, this is FreeBSD, we don't normally do such things... ;)
!
! You don't update the C library, o
Hello Folks,
Thanks for Your inspiration; and I made some progress (found
a way to avoid the issue).
The issue is most likely not related to postgres.
Ron Johnson said:
>> A configuration problem on the machine(s) can be ruled out,
> Famous last words.
Trust me. :)
> Is there a way to test
My application is trying to connect the database server, and meanwhile
tries to talk to the KDC server for a service ticket.
Earlier these TCP connections did run like this, and were successful:
13:57:53.788797 IP6 clientIPv6.54143 > serverIPv6.88: Flags [S], seq
4189109662, win 65535, options [
uld write
select query_to_xml('select 42 where false', false, false, '');
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
On 3/13/18 15:21, Thomas Kellerer wrote:
> I still think it's incorrect to return an empty (=invalid) XML instead of a
> NULL value though.
This behavior is specified in the SQL standard. While an empty string
is not a valid XML "document", it is valid as XML "conte
es for most Linux systems). This
can verify that the heap is consistent with indexes.
--
Peter Geoghegan
On Mon, Mar 19, 2018 at 1:01 PM, Jeremy Finzel wrote:
> SELECT heap_page_items(get_raw_page('pg_authid', 7));
Can you post this?
SELECT * FROM page_header(get_raw_page('pg_authid', 7));
--
Peter Geoghegan
On Mon, Mar 19, 2018 at 1:55 PM, Jeremy Finzel wrote:
> @Peter :
>
> staging=# SELECT * FROM page_header(get_raw_page('pg_authid', 7));
> lsn | checksum | flags | lower | upper | special | pagesize |
rows for a target
index (in addition to testing the structure of a target B-Tree index
itself). This is probably the best general test for corruption that is
available. There is a fair chance that this will reveal new
information.
--
Peter Geoghegan
make
time for that. If you can generalize from the example query that calls
the bt_index_check() function, but set
"heapallindexed=>i.indisprimary" and remove "n.nspname =
'pg_catalog'", as well as "LIMIT 10". This will test tables and
indexes from all schemas, which might be interesting.
--
Peter Geoghegan
many LVM + Postgres setups
will involve multiple logical volumes. This makes it possible for a
small inconsistency across logical volumes to corrupt data.
I don't know anything about your SAN snapshotting, but this is at
least something to consider.
--
Peter Geoghegan
t yet have
the necessary debuginfo repos set up. Just a guess. That is sometimes
a required extra step.
[1] https://postgr.es/m/7369.1520528...@sss.pgh.pa.us
--
Peter Geoghegan
t; elsewhere?
I would look into this suspected 9.5 regression, if that's possible:
https://postgr.es/m/CAH2-Wz=sfakvmv1x9jh19ej8am8tzn9f-yecips9hrrrqss...@mail.gmail.com
--
Peter Geoghegan
>
> So a bit confused, is psql ignoring the host parameter
.3 is the host you are connecting to, as seen from the client.
.2 is the host your connection is coming from, as seen from the server.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
purposes. We want to either encrypt it or
> authenticate without binding. Any insights into this is appreciated.
You can use the "simple bind" method that is described in the
documentation. That one doesn't involve a second bind step.
--
Peter Eisentraut http://w
Tim, I'm sorry if I sound like a cheerleader, but boy did you nail this. I
would basically say exactly the same thing, just not as well.
On Sun, Apr 8, 2018 at 9:37 PM, Tim Cross wrote:
>
>
> On 9 April 2018 at 07:39, Guyren Howe wrote:
>
>> I am a Rails developer at a medium-large size compa
re still pieces missing in the standard holding this back?
I think you'll still have the same problems if the same constraint name
appears more than once per schema.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
me = 'mysub');
The key is checking the srsubstate column for 'r' (ready).
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
ug (in which case the checksum will be correct).
You can also run amcheck. Get the version targeting earlier Postgres
releases off Github (there are packages for most Linux systems). This
can verify that the heap is consistent with indexes.
--
Peter Geoghegan
On Mon, Apr 9, 2018 at 5:55 PM, Alexandre Arruda wrote:
> I ran amcheck in all index of a table and I only get empty returns.
Did you try doing so with the "heapallindexed" option? That's what's
really interesting here.
--
Peter Geoghegan
/freezing. The only heap_freeze_tuple() caller is code used by
CLUSTER, so it's not that hard to imagine a MultiXact freezing bug
that is peculiar to CLUSTER. Though I haven't thought about it in much
detail.
--
Peter Geoghegan
7;t think that that's what this is, since this error occurs
within heap_freeze_tuple() -- it's not the over-enforced
HEAP_XMAX_IS_LOCKED_ONLY() error within heap_prepare_freeze_tuple().
And, because this database wasn't pg_upgraded.
I should wait until tomorrow before doing any further analysis, though.
--
Peter Geoghegan
wed this error, though?
Have you noticed any data loss? Things look okay when you do your dump
+ restore, right? The problem, as far as you know, is strictly that
CLUSTER + VACUUM refuse to finish/raise these multixactid errors?
--
Peter Geoghegan
ase? You'll need to be able to
install the pageinspect contrib module.
--
Peter Geoghegan
h is that the git logo
links to https://git.postgresql.org/gitweb/, which has many
non-very-important git repos. Instead, it should point to the main
PostgreSQL repository's gitweb page, which is at
https://git.postgresql.org/gitweb/?p=postgresql.git.
--
Peter Geoghegan
survey.
This sounds pretty far from constructive to me, which automatically
detracts from what you're saying.
--
Peter Geoghegan
generated during the backup and replaying it on the newly created standby.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
er
>> about this one in HeapTupleSatisfiesMVCC:
>
> I suggest raising this on -hackers. I agree that it's unfortunate.
I wonder if BootstrapTransactionId also needs to be considered here.
--
Peter Geoghegan
ovides the fastest possible access to
a crowdsourced answer, without requiring or even encouraging
participation.
--
Peter Geoghegan
sons. You can say the same thing about
any position of leadership or authority within the community, though.
That hasn't really been much of a problem in my experience, and I see
no reason for particular concern about it here.
--
Peter Geoghegan
ast until now. You can make exactly the same slippery
slope argument against that.
--
Peter Geoghegan
nity members who have a strong belief in the CoC (and I don't mean that
> kindly)?
The CoC states that the committee's members cannot come from the core team.
--
Peter Geoghegan
to that.
We have a pretty good track record through totally informal standards
for behavior. Setting a good example is absolutely essential. While
that's still the most important thing, it doesn't seem particularly
scalable on its own.
--
Peter Geoghegan
. Let's try to keep our standards here.
Whose standards are these? By my count, the majority of e-mails you've
ever sent to a PostgreSQL mailing list have been sent in the last 2
days, to this code of conduct thread.
--
Peter Geoghegan
formality, means of enforcement, etc.
Naturally, the rules across disparate groups vary widely for all kinds
of reasons. Formalizing and being more transparent about how this
works seems like the opposite of paternalism to me.
--
Peter Geoghegan
lica has incompatible collation rules, given that it uses a totally
different OS.
--
Peter Geoghegan
error: tlsv1 alert unknown ca
>
> I tried the opposite of moving the .postgresql directory to a different
> name and putting a hard coded certificate path in pg_service, but it
> looks to have its own sets of challenges.
I think that's probably the best way out, though.
--
Pet
+ exceptions end up calling std::abort(). I've seen bugs
in modules like PL/V8 that were caused by this. The symptom was a
mysterious message in the logs about SIGABRT. Perhaps that's what
happened here?
What extensions are installed, if any?
--
Peter Geoghegan
ably unusable.
Do you find that the issue goes away if you set
max_parallel_maintenance_workers=0 on v11/master?
--
Peter Geoghegan
On Thu, Jun 28, 2018 at 8:02 AM, Andres Freund wrote:
> Peter, looks like you might be involved specifically.
Seems that way.
> This however seems wrong. Cleary the relation's index list is out of
> date.
>
> I believe this happens because there's currently n
. ISTM
> there's some risks that it'd cause issues. Will you tackle this?
Okay.
--
Peter Geoghegan
;
> Is there a way to get this to work right ?
If you're using v10 with ICU, then you can create a custom ICU
collation for this, with "natural" sort order. Something like this
should work:
CREATE COLLATION numeric (provider = icu, locale = 'en-u-kn-true');
See the docs -- "23.2.2.3.2. ICU collations".
--
Peter Geoghegan
using jdbc?
That doesn't do what you want. You still need to wait for the snapshot
to be created; there is no way around that. The NOEXPORT_SNAPSHOT
option just means that the snapshot, once created, won't be exported for
use by other sessions.
--
Peter Eisentraut
l against any of the other tool chains that have
been mentioned.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
nking I could use an index, the
> PK for instance, and see if it references these pages.
Ir'a probably not serious, but you may want to try amcheck's
heapallindexed check. You'll have to use the non-contrib packages for
that right now, though, but those are available from the PGDG repos.
--
Peter Geoghegan
On Wed, Jul 25, 2018 at 4:03 PM, Andres Freund wrote:
> Peter, given that your patch made this more likely, and that you're a
> committer these days, I'm opening an open items entry, and assign it to
> you. Does that sound ok?
I intend to follow through on this soon. I have
quietly and painlessly.
> The truth is absolute and cannot be changed.
> Perception is not the truth.
> Flerp!
I cannot imagine what reaction you were expecting to this. In all
sincerity, I suggest reflecting on your words. You don't seem to have
realistic expectations about ho
(), not CacheInvalidateHeapTuple()).
Since nobody seems to be that excited about the
CacheInvalidateHeapTuple() idea, I haven't pursued it.
--
Peter Geoghegan
0001-Add-table-relcache-invalidation-to-index-builds.patch
Description: Binary data
ract
already.
> I wonder if it wouldn't be more appropriately placed closer to the
> UpdateIndexRelation(), given that that's essentially what necessitates
> the relcache flush?
That makes sense. I'll do it that way.
--
Peter Geoghegan
istering invalidations for coherency.
Fair enough. How about the attached revision?
--
Peter Geoghegan
v2-0001-Add-table-relcache-invalidation-to-index-builds.patch
Description: Binary data
The & need to be replaced by &
Peter
On Sat, 4 Aug 2018, 22:47 Dave Cramer, wrote:
> Pretty sure this is a tomcat error .
>
> The connection string looks fine
>
> Dave Cramer
>
> da...@postgresintl.com
> www.postgresintl.com
>
> On 30 July 2018 at 11:
lternative OpenSSL versions out there
that defy any documentation.
Of course, we should also see if this actually fixes the reported problem.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
On Fri, Sep 14, 2018 at 11:51 AM David Gauthier
wrote:
>
> Hi:
>
> In perl/DBI, I have code that's getting me an "age" which returns something
> like... "-17 days -08:29:35". How can I convert that to a number of hours
> (as a float I would presume) ?
>
> Thanks
>
>
>
>
I've done this as
selec
lot
better than either the status quo, or a platitude about inclusivity.
--
Peter Geoghegan
something
> somewhere that some other tweet disagreed with on faceplant"?
>
> Great plan if you do for-pay postgresql support for the living.
You can make your own conclusions about my motivations, just as I'll
make my own conclusions about yours. I'm not going to engage with you
on either, though.
--
Peter Geoghegan
ill respect it.
In all sincerity, if you're compelled to walk away from participating
in mailing list discussions on a point of principle, then I wish you
well. That is your right.
--
Peter Geoghegan
On Fri, Sep 14, 2018 at 2:42 PM Steven Lembark wrote:
>
> On Fri, 14 Sep 2018 12:21:14 -0400
> David Gauthier wrote:
>
> > I'm using postgres v9.5.2 on RH6.
>
> PG can convert the times for you.
> For times (not timestamps) you are always better off dealing with
> either time or integer seconds.
this issue in the working subscription direction.
The problem might be in the dsn that you gave to create_node(). Hard to
tell without a fully reproducible script.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
1 - 100 of 978 matches
Mail list logo
