;.. but didn't want to make it seem like I was suggesting
Paul do that)
On Thu, Jan 23, 2025, 11:07 a.m. Adrian Klaver
wrote:
> On 1/23/25 06:51, Saul Perdomo wrote:
>
> > This is why everybody will tell you "don't just delete these files,
> > archive them properly!&q
Genuine question: Why are you looking to recover from this half-cooked
state instead of restarting the restore process from the beginning?
On Tue, Dec 17, 2024, 1:10 a.m. Ivan Kurnosov wrote:
> The scenario:
>
> 1. There is a postgresql 17 server running
> 2. Restore dump with `--single-transact
On Wed, Dec 18, 2024, 5:01 a.m. Rama Krishnan wrote:
>
> Hi Team,
>
> One of our clients recently migrated from Oracle to PostgreSQL and is
> conducting multiple scenarios to understand PostgreSQL behavior.
>
> One of their main concerns is whether the database will allow `INSERT`
> queries when
Agreed - it sounds like OP found a *client *process and mistook it for a
server process, which is why I wanted to know where exactly he saw this.
On Tue, Nov 5, 2024 at 9:41 AM Ron Johnson wrote:
> On Tue, Nov 5, 2024 at 9:22 AM Kal wrote:
>
>>
>> On Tue, 5 Nov 2024 at 7:42 PM, Greg Sabino Mull
" But the database actually listens on some random port like 20011"
How exactly did you determine this?
(If you used, say, netstat, can you share its output with us?)
On Tue, Nov 5, 2024 at 8:46 AM Kal wrote:
> Hi
>
> I have a scenario in which postgres listens on a random port different
> fro
What Rob said... plus, I would urge you to give some more thought to "for
audit purposes the data is append only". If your application is ever
successful, non-insignificant storage costs are something you'll need to
deal with sooner or later.
Anyway, what you ask is certainly achievable, but not w
hey Karthick, if you've made triple sure that it's not a permissions issue,
take a look at some of the suggestions in this old thread:
https://dba.stackexchange.com/questions/17546/why-is-pg-dumpall-throwing-an-oid-does-not-exist-error
On Mon, Aug 8, 2022 at 5:30 AM Techsupport wrote:
> *Hi to a
own challenges - but based on this info, it's
where I would probably start..
On Wed., Nov. 17, 2021, 12:28 a.m. Tiffany Thang,
wrote:
> On Mon, Nov 15, 2021 at 8:48 PM Saul Perdomo
> wrote:
>
>> Hey Tiff,
>>
>> We're in a similar boat. We currently lean on (m
Hey Tiff,
We're in a similar boat. We currently lean on (mostly custom) ansible
scripting to automate all the repeatable tasks we can, but automation of
major PG version upgrades is something we are yet to tackle -- although we
plan to start this effort in the short term.
Would you mind sharing a
ver_target_timeline to latest in that file
> 4) Start the stopped master database; it will automatically come up as a
> slave
> 5) Check status of the database.
>
> Additionally, entries in pg_hba.conf is required.
>
> Hope this helps.
>
>
> Regards,
> Ninad Shah
>
37 PM Saul Perdomo wrote:
> Hi Moishe,
>
> Since we use pgbackrest ourselves, this is the process I followed to set
> up something similar on PG 10:
>
>
> https://pgstef.github.io/2018/11/28/combining_pgbackrest_and_streaming_replication.html
>
> (Not knowing much [if a
Hi Moishe,
Since we use pgbackrest ourselves, this is the process I followed to set up
something similar on PG 10:
https://pgstef.github.io/2018/11/28/combining_pgbackrest_and_streaming_replication.html
(Not knowing much [if at all] about the reason for your requirements, I
would recommend looki
12 matches
Mail list logo
