Hi Andrus,
On Thu, Mar 11, 2021 at 2:21 AM Andrus wrote:
> Windows Resource manger shows that wal files are used by large number of
> postgres processes:
>
> postgres.exe22656FileC:\Program
> Files\PostgreSQL\13\data\pg_wal\0001000A0075
> postgres.exe30788File
Thank you, Valeria. I have forwarded your comments to Anastasia and Alexander.
Regards,
Stacey
Stacey Haysler
Chair
PostgreSQL Community Code of Conduct Committee
On Mar 11, 2021, at 2:03 AM, Valeria Kaplan wrote:
Looks good.
1. Just to note that the word "here" ("здесь") on page 2 isn't a hyp
Niko Ware writes:
> I modified the code to include the "extra" member in the following
> statement:
> fprintf(stderr,
> "ASYNC NOTIFY of '%s' received from backend PID %d: %s\n",
> notify->relname, notify->be_pid, *notify->extra*);
> Both the e
Sent from my iPhone
> On Mar 10, 2021, at 15:03, Ron wrote:
> On 3/10/21 11:56 AM, Martín Fernández wrote:
>>
>>
>>> On 10 Mar 2021, at 11:25, Ron wrote:
>>>
On 3/10/21 2:10 AM, Radoslav Nedyalkov wrote:
On Wed, Mar 10, 2021 at 3:56 AM Martín Fernández
wrote:
>
Markus, you should know about not top-posting on these lists.
On Thu, 2021-03-11 at 10:52 +, Zwettler Markus (OIZ) wrote:
> > On Mon, 2021-03-08 at 22:30 +0900, Daisuke Ikeda wrote:
> > > I'm running PostgreSQL (enabled timescaledb extension) in the following
> > > environment.
> > > And I ha
> Never, ever, remove WAL files manually.
> A crash might render your database unrecoverable.
You're right, it's not a good idea.
> You'll have to figure out what is blocking WAL removal.
This is my favorite dream!
> Are there archive failures reported in "pg_stat_archiver" and the log?
master=#
Hi Laurenz,
You said use your backup.
Wouldn't it be enough to start instance crash recovery just before the
corrupted wal in that case?
recovery_target_lsn = <>
recovery_target_inclusive = off
No need for a backup. Correct?
Cheers, Markus
> -Ursprüngliche Nachricht-
> Von: Lauren
Looks good.
1. Just to note that the word "here" ("здесь") on page 2 isn't a hyperlink
(it is supposed to link to the Code of Conduct page).
2. Spelling of PostgresQL > PostgreSQL on page 7 should be corrected
Thank you for all your work.
Valeria
On Thu, Mar 11, 2021 at 3:49 AM Stacey Haysler
On Thu, 2021-03-11 at 09:43 +0200, Andrew Anderson wrote:
> > Never, ever, remove WAL files manually.
> > A crash might render your database unrecoverable.
> You're right, it's not a good idea.
>
> > You'll have to figure out what is blocking WAL removal.
> This is my favorite dream!
>
> > Are th
Hi Adam ,
Thank you for the such a good explaination , actually in same instance
dba's are looking to create multiple QA databases and we had jobs in oracle
for archiving and some business functionality so I created pgagent
extension in multiple databases ,in our application end users can submit
j
10 matches
Mail list logo
