Re: Issue in PG start

2021-05-09 Thread Laurenz Albe
On Sat, 2021-05-08 at 05:14 +, sivapostg...@yahoo.com wrote: > Yesterday [07th May] morning when we switched on the computer and > subsequently PGAdmin, we got the message following message > FATAL: the database system is starting up You will have to wait until startup is completed. Either y

Re: Postgres upgrade 12 - issues with OIDs

2021-05-09 Thread Venkata B Nagothi
On Sat, 8 May 2021 at 1:47 pm, Laurenz Albe wrote: > On Sat, 2021-05-08 at 13:37 +1000, Venkata B Nagothi wrote: > > We are thinking to upgrade to PG 11 instead so that we can avoid doing > ALTER TABLE.. SET WITHOUT OIDs. > > Does that makes sense ? Please advise if there are any gotchas ! > > I

Re: Setting wal_keep_segments parameter

2021-05-09 Thread Tom Lane
rob stan writes: > I want to set wal_keep_segments parameter to a value but what should be the > process I follow? I have archiving process on all clusters is on but when a > sudden process comes to postgres wal files will be bigger than i assume. I > don't know what I should do. Could you please

Setting wal_keep_segments parameter

2021-05-09 Thread rob stan
Hello , I want to set wal_keep_segments parameter to a value but what should be the process I follow? I have archiving process on all clusters is on but when a sudden process comes to postgres wal files will be bigger than i assume. I don't know what I should do. Could you please help me? Thanks

Re: Issue in PG start

2021-05-09 Thread Adrian Klaver
On 5/8/21 7:32 PM, sivapostg...@yahoo.com wrote: Yesterday's log file.   Till we shut down the windows the message was: 2021-05-08 19:03:32.151 IST [10376] FATAL:  the database system is starting up 2021-05-08 19:03:42.210 IST [7568] FATAL:  the database system is starting up Comments in lin