On Tue, Mar 5, 2024 at 3:14 AM Frank Lanitz wrote:
> $ pgbadger --journalctl "journalctl -u postgresql.service"
>
You could try adding --verbose to see if it gives more clues.
> Having a look into the journal there is a lot of
>
None of the snippets from journald you showed were actually thin
On Fri, Jan 26, 2024 at 1:44 AM Jawala wrote:
> Looking for an escape sequence for log_line_prefix for the IP address that
> traffic was destined to, i.e., the *local* address of the TCP connection,
> natural counterpart to "remote IP address".
>
I made a quick proof of concept of this, will pos
Actually, will just post it here in case someone finds this thread and
wants to follow along:
https://www.postgresql.org/message-id/flat/CAKAnmmK-U%2BUicE-qbNU23K--Q5XTLdM6bj%2BgbkZBZkjyjrd3Ow%40mail.gmail.com
Greetings,
* Guyren Howe (guy...@gmail.com) wrote:
> But what *really* sets Postgres apart from comparable systems is user defined
> types. I would like to carefully lay out how to define and use a user-defined
> type (I don’t think I have time to dig into doing fancy stuff with C
> functions,
Thanks for that!
It seems as though a Composite Type having only fixed-length fields should be
able to be regarded as a fixed-length value.
On 6 Mar 2024 at 09:45 -0800, Stephen Frost , wrote:
> Greetings,
>
> * Guyren Howe (guy...@gmail.com) wrote:
> > But what *really* sets Postgres apart from
Hello guys,
I need to export the DDL (tables, funcitons views) of some schemas (with
cross references) to load them in a pipeline like DevOps ready.
Problem: export/backup doesn't care about the appropriate sequence of objet
because these stuff will be solved by import phase.
So there is a way to
> On Mar 6, 2024, at 13:18, Lorusso Domenico wrote:
> So there is a way to automatically generate DDL in the right order?
Standard pg_dump creates files that are in the proper order, although if you
exclusive some tables or schemas from the backup, those might cause errors if
references from
Hi:
I'm a PG user in a big corp with an IT dept that administers a PG
server/instance that I use. It's an old install, v11.5, and we need to
upgrade to v15.3. They want to bring the upgraded DB up on a new linux vm
which has OS upgrades of its own. So it's a move AND an upgrade. There are
2 conc
On 3/6/24 13:18, Lorusso Domenico wrote:
Hello guys,
I need to export the DDL (tables, funcitons views) of some schemas (with
cross references) to load them in a pipeline like DevOps ready.
Problem: export/backup doesn't care about the appropriate sequence of
objet because these stuff will be
On 3/6/24 16:19, David Gauthier wrote:
Hi:
I'm a PG user in a big corp with an IT dept that administers a PG
server/instance that I use. It's an old install, v11.5, and we need to
upgrade to v15.3. They want to bring the upgraded DB up on a new linux
vm which has OS upgrades of its own. So
On Wed, Mar 6, 2024 at 07:19:20PM -0500, David Gauthier wrote:
> Hi:
> I'm a PG user in a big corp with an IT dept that administers a PG server/
> instance that I use. It's an old install, v11.5, and we need to upgrade to
> v15.3. They want to bring the upgraded DB up on a new linux vm which h
On Wed, Mar 6, 2024 at 7:19 PM David Gauthier wrote:
> Hi:
> I'm a PG user in a big corp with an IT dept that administers a PG
> server/instance that I use. It's an old install, v11.5, and we need to
> upgrade to v15.3. They want to bring the upgraded DB up on a new linux vm
> which has OS upgr
Greetings,
* Guyren Howe (guy...@gmail.com) wrote:
> Thanks for that!
We'd generally prefer that responses are in-line (such as I'm doing
here) and not top-posted (as you did on your response). This helps
others reading the lists follow the discussion.
> It seems as though a Composite Type havi
Stephen Frost writes:
> * Guyren Howe (guy...@gmail.com) wrote:
>> It seems as though a Composite Type having only fixed-length fields should
>> be able to be regarded as a fixed-length value.
> While I can understand where you're coming from with that, it's
> certainly not something the system
14 matches
Mail list logo
