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
>
> $
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
.
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
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
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
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,
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 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
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
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
> 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, 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
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, 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
14 matches
Mail list logo
