On Thu, Jul 25, 2024 at 7:42 AM veem v wrote:
> I was thinking the individual statement will work fine if I pull out those
> from the begin..end block, as those will then be not bounded by any outer
> transaction.
> However, When I was trying it from dbeaver by extracting individual index
> cr
Hi all,
I started this discussion in May and was then dragged into other topics, so I
could never follow up. Sorry for that!
Since then, the problem has resurfaced from time to time. Right now, we seem to
have issues again, which gives me the opportunity to follow up on your various
suggestions.
On Thu, 2024-07-25 at 10:58 +, Christian Schröder wrote:
> The current error messages are similar to what we have seen before:
>
> <2024-07-25 12:27:38 CEST - > LOG: could not fork autovacuum worker process:
> Cannot allocate memory
> <2024-07-25 12:27:38 CEST - mailprocessor> ERROR: could
> On 25 Jul 2024, at 12:58, Christian Schröder
> wrote:
>
> Hi all,
> I started this discussion in May and was then dragged into other topics, so I
> could never follow up. Sorry for that!
> Since then, the problem has resurfaced from time to time. Right now, we seem
> to have issues again,
On Thu, Jul 25, 2024 at 6:59 AM Christian Schröder <
christian.schroe...@wsd.com> wrote:
> Hi all,
> I started this discussion in May and was then dragged into other topics,
> so I could never follow up. Sorry for that!
> Since then, the problem has resurfaced from time to time. Right now, we
> se
List,
Reference: https://pgbackrest.org/user-guide-rhel.html#pitr
I am following the PTR on RHEL9 EPAS16.
I am able to do a backup(Full, diff and incr) and restore from a full
backup and restart of EPAS16 works fine.
But when I do an incremental backup after doing the procedures mentio
Hi KK CHN
Could you check server logs ?
Your service trace suggests that it started server and then failure happened
ul 26 09:48:49 service01 systemd[1]: Started EDB Postgres Advanced Server
16.
Jul 26 09:48:50 service01 systemd[1]: edb-as-16.service: Main process
exited, code=exited, status=1/FA
Hello,Using PG 11.11, One PG Cluster, Windows 2019 Server Standard, Two
databases with identical data.
1. First DB: client_db
2. Second DB: client_test
Took backup (pg_dump) of first database (client_db) and restored the database
as second database (client_test).
Query:
Select a.examname, a.r
Hi,
Could you perform diff on postgresql.conf file to see whether values are
same for work_mem, shared_buffers, maintenance_work_mem and other related
parameters?
Regards,
Ikram
On Fri, Jul 26, 2024 at 10:31 AM sivapostg...@yahoo.com <
sivapostg...@yahoo.com> wrote:
> Hello,
> Using PG 11.11,
On Fri, Jul 19, 2024 at 5:59 PM KK CHN wrote:
> Hi list,
>
> Thank you all for the great help and guidance, I am able to configure
> pgbackrest with EPAS-16 and a Repo server both separate machines..
> Password less auth also worked well. Backup and restore all fine.
>
> Query
> How can I ma
I've only one instance of PG in that server. Means only one postgresql.conf
for both databases.
On Friday, 26 July, 2024 at 11:12:34 am IST, Muhammad Ikram
wrote:
Hi,
Could you perform diff on postgresql.conf file to see whether values are same
for work_mem, shared_buffers, maintena
Hi Again,
I have not gone through your explain plans for both, will it be possible
for you to take diff of the both plans. It will give some insight about how
things are going and where the problem is.
Alternatively
I will suggest Reindex and execute ANALYZE command to regenerate stats .
Regar
here the log outputs
When I ran
$sudo -u enterprisedb pgbackrest --stanza=Demo_Repo --delta
--set=20240719-122703F_20240724-094727I --target-timeline=current
--type=time "--target=2024-07-24 09:44:01.3255+05:30"
--target-action=promote restore
The Edb server log out put shows
.
I don't think it has anything to do with the pg_hba.conf file. Archive
seems missing. I will suggest taking a full backup, as you have mentioned
that you are able to take full backup.
Regards,
Ikram
On Fri, Jul 26, 2024 at 11:24 AM KK CHN wrote:
> here the log outputs
>
> When I ran
>
> $
14 matches
Mail list logo
