public inbox for [email protected]
help / color / mirror / Atom feedWAL settings for larger imports
3+ messages / 3 participants
[nested] [flat]
* WAL settings for larger imports
@ 2024-06-17 13:46 Benoit, Eric <[email protected]>
2024-06-17 15:10 ` Re: WAL settings for larger imports Adrian Klaver <[email protected]>
2024-06-17 15:57 ` Re: WAL settings for larger imports Ron Johnson <[email protected]>
0 siblings, 2 replies; 3+ messages in thread
From: Benoit, Eric @ 2024-06-17 13:46 UTC (permalink / raw)
To: [email protected] <[email protected]>
What is a good data import configuration for only one server for WRITE-AHEAD LOG settings postgresql.conf where no one is connecting to the database accept me as a superuser.
Confidentiality Notice: This electronic message and any attachments may contain confidential or privileged information, and is intended only for the individual or entity identified above as the addressee. If you are not the addressee (or the employee or agent responsible to deliver it to the addressee), or if this message has been addressed to you in error, you are hereby notified that you may not copy, forward, disclose or use any part of this message or any attachments. Please notify the sender immediately by return e-mail or telephone and delete this message from your system.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: WAL settings for larger imports
2024-06-17 13:46 WAL settings for larger imports Benoit, Eric <[email protected]>
@ 2024-06-17 15:10 ` Adrian Klaver <[email protected]>
1 sibling, 0 replies; 3+ messages in thread
From: Adrian Klaver @ 2024-06-17 15:10 UTC (permalink / raw)
To: Benoit, Eric <[email protected]>; [email protected] <[email protected]>
On 6/17/24 06:46, Benoit, Eric wrote:
> What is a good data import configuration for only one server for
> WRITE-AHEAD LOG settings postgresql.conf where no one is connecting to
> the database accept me as a superuser.
1) The Confidentiality Notice is longer then the question and is
basically pointless.
2) An answer is going to need more information:
a) Postgres version?
b) What are your current settings?
c) What constitutes a 'larger import'?
d) How often are you doing these imports?
--
Adrian Klaver
[email protected]
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: WAL settings for larger imports
2024-06-17 13:46 WAL settings for larger imports Benoit, Eric <[email protected]>
@ 2024-06-17 15:57 ` Ron Johnson <[email protected]>
1 sibling, 0 replies; 3+ messages in thread
From: Ron Johnson @ 2024-06-17 15:57 UTC (permalink / raw)
To: pgsql-general
On Mon, Jun 17, 2024 at 9:46 AM Benoit, Eric <[email protected]> wrote:
> What is a good data import configuration for only one server for
> WRITE-AHEAD LOG settings postgresql.conf where no one is connecting to the
> database accept me as a superuser.
>
How worried are you about data loss / database corruption?
Is streaming or logical replication enabled?
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-06-17 15:57 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-06-17 13:46 WAL settings for larger imports Benoit, Eric <[email protected]>
2024-06-17 15:10 ` Adrian Klaver <[email protected]>
2024-06-17 15:57 ` Ron Johnson <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox