:13, Johnathan Tiamoh wrote:
> > Hello,
> >
> >
> > I performed an upgrade from postgresql-9.5 to postgresql-14 and the
> > performance has degraded drastically.
> >
> > Please, is they any advice on getting performance back ?
> >
>
>
Hello,
I performed an upgrade from postgresql-9.5 to postgresql-14 and the
performance has degraded drastically.
Please, is they any advice on getting performance back ?
King Regards
Johnathan T.
Hello,
Good morning. Please I wish to find out the best way of encrypting a
Postgres database.
This could either be encrypting a whole database ( I don’t if this is
possible), a specific table and a specific tablespace.
King regards
Johnathan T.
Thank you very much !
On Tue, Feb 20, 2024 at 9:50 AM Greg Sabino Mullane
wrote:
> Add this to your pgbouncer config file:
>
> ignore_startup_parameters = extra_float_digits
>
> A web search of your subject line finds this solution quite easily.
> Providing more details would also be a good
Hello,
Please, I need help to fix this issue. I have increase client
_idle_timeout from 15 minutes to 30 minutes and still facing the
same problem.
Kind regards
Johnathan T.
Hello,
I need help to resolve the above issue.
Kind regards
Johnathan T.
Thank you very much @Adrian Klaver .
On Mon, Feb 19, 2024 at 2:45 PM Adrian Klaver
wrote:
> On 2/19/24 11:36, Johnathan Tiamoh wrote:
>
> Reply to list also.
> Cc'ing list.
>
> > Sorry Adrian,
> >
> > This is occurring at every checkpoint. This actually
Hello,
Please, I need help in resolving this issue. I recently upgraded to
postgresql and have experienced the above error with 2 clusters already.
I keep losing data in the pg_exact directory.
Kind regards
Johnathan T
I have upgraded from 9.5 to 14 using the -link option. It works fine.
I equally had streaming replication running on it.
I break(split brain) replication and upgrade the standby, once it done and
everything is running smoothly, I then install version 14 to the old
primary and just configure
I haven't had difficulties in this cluster recently.
However I upgraded it from version 9.5 to 14.10 about 3 weeks ago.
On Thu, Feb 1, 2024 at 9:06 AM Jehan-Guillaume de Rorthais
wrote:
> On Thu, 1 Feb 2024 08:28:45 -0500
> Johnathan Tiamoh wrote:
>
> > Th
Thank you Laurenz!
Is there a way of preventing this from happening ?
On Thu, Feb 1, 2024 at 2:36 AM Laurenz Albe
wrote:
> On Thu, 2024-02-01 at 00:48 -0500, Johnathan Tiamoh wrote:
> > I am having the following issue below. Please, I need help to fix it.
> >
> > ERR
Hello,
I am having the following issue below. Please, I need help to fix it.
[image: User]
*ERROR: could not access status of transaction 756525298*
*Could not open file "pg_xact/02C8": No such file or directory.*
Thank You
Johnathan T
Thank You very much for your time.
On Wed, Jan 17, 2024 at 4:51 PM Ron Johnson wrote:
> Perfectly understandable, but tar *did* fail. Time to start debugging
> your shell script.
>
> On Wed, Jan 17, 2024 at 4:26 PM Johnathan Tiamoh <
> johnathantia...@gmail.com> wrot
Ok.
I'm a little confused because has always work
On Wed, Jan 17, 2024 at 4:11 PM Ron Johnson wrote:
> Then you've got a bug somewhere in:
> tar -h -zxvf $PATH_FOLDER/* .tar.gz
> ls $PATH_FOLDER/*.tar.gz | xargs -I {} tar -h -zxvf {}
>
> On Wed, Jan 17, 2024 at 4:07 PM J
Yes.
I am trying to restore the backups on a standby
On Wed, Jan 17, 2024 at 4:04 PM Ron Johnson wrote:
> Wait a minute... *tar* is throwing the errors, not pg_basebackup, no?
>
> On Wed, Jan 17, 2024 at 3:27 PM Johnathan Tiamoh <
> johnathantia...@gmail.com> wro
ou use?
> 3. Why aren't you letting pg_basebackup maintain the WAL files it needs?
>
> On Wed, Jan 17, 2024 at 11:27 AM Johnathan Tiamoh <
> johnathantia...@gmail.com> wrote:
>
>> You need to tell us the PG version number *and* show us the full command
>> you ran. ?
as postgres
/tnt??? Or /mnt?
/tnt/backup/current
This is where the backup files are.
On Wed, Jan 17, 2024 at 11:15 AM Ron Johnson
wrote:
> On Wed, Jan 17, 2024 at 11:11 AM Johnathan Tiamoh <
> johnathantia...@gmail.com> wrote:
>
>> Hello,
>>
>> I am
Hello,
I am trying to restore a pg_basebackup and have the following errors.
nohup: ignoring input
tar: /tnt/backup/current/7400.tar.gz: Not found in archive
tar: /tnt/backup/current/7401.tar.gz: Not found in archive
tar: /tnt/backup/current/7402.tar.gz: Not found in archive
tar:
Hello,
Please, I need help to fix this. Can't do anything in the database. This
error keeps popping up.
I have tried to do a pg_dump and the same error keeps coming up.
Thank you
Johnathan Tiamoh
some source and
then ran pg_resetwal?
I recreated it from the backup
Do you mean you did a pg_dumpall from the Postgres instance running on
the restored data directory?
Yes. And it failed
On Sat, Dec 23, 2023 at 5:35 PM Adrian Klaver
wrote:
> On 12/23/23 10:05, Johnathan Tiamoh wrote:
>
equally
failed.
On Sat, Dec 23, 2023 at 11:35 AM Adrian Klaver
wrote:
> On 12/22/23 22:48, Johnathan Tiamoh wrote:
> > Hello,
> >
> > I am able to start postgresql because of the below error. Please is
> > there any help
> >
> > User
> > You
Hello,
I am able to start postgresql because of the below error. Please is there
any help
[image: User]
You
FATAL: xlog flush request 4392/164662F8 is not satisfied --- flushed only
to 4392/F58
[image: User]YouFATAL: xlog flush request 4392/164662F8 is not satisfied
--- flushed only to
Hello Laurenz,
Thank you very much for your reply.
On Fri, Dec 22, 2023 at 7:10 AM Laurenz Albe
wrote:
> On Thu, 2023-12-21 at 18:53 -0500, Johnathan Tiamoh wrote:
> > Please I wish to find out what you do after running pg_walreset.
>
> You mean pg_resetwal.
>
> > I ma
Hello,
Please I wish to find out what you do after running pg_walreset.
I made a mistake and deleted my data directory with all its content. I then
restore with 1 day old backups, after that i could start unless i did
pg_walreset.
1, I wish to find out what to do after i have started
Hello
How can this error be resolved?
PGE-XX000: ERROR: Problem with the SSL CA cert (path? access rights?)
Is there any postgresql documentation on this ?
Kind regards
Johnathan T.
I used pg_ctl to stop the cluster.
When I used the same pg_ctl to check status, it says no server is running
On Tue, Jul 18, 2023 at 6:14 AM Daniel Gustafsson wrote:
> > On 18 Jul 2023, at 12:02, Johnathan Tiamoh
> wrote:
>
> > The source cluster was not shut down cl
Thank You Laurenz.
On Tue, Jul 18, 2023 at 6:12 AM Laurenz Albe
wrote:
> On Tue, 2023-07-18 at 06:02 -0400, Johnathan Tiamoh wrote:
> > I was running an upgrade from 9.5 to 14.8 and encountered the below
> error.
> >
> > Running in verbose mode
> >
Hello,
I was running an upgrade from 9.5 to 14.8 and encountered the below error.
Running in verbose mode
Performing Consistency Checks
-
Checking cluster versions ok
The source cluster was not shut down cleanly.
Failure, exiting
Thank you all very much.
I really appreciate !!
On Wed, Jul 12, 2023 at 4:17 PM Gurjeet Singh wrote:
> On Wed, Jul 12, 2023 at 12:42 PM Mateusz Henicz
> wrote:
> >
> > You can also just write an sql and execute it, like:
> >
> > select 'alter user '|| usename ||' with password
Hello,
I wish to find out if there is a way to reset all users in Postgresql
password to the same password at once.
Thank you
Tiamoh J
Thank you very much @Adrian Klaver .
On Tue, Jul 11, 2023 at 7:32 PM Adrian Klaver
wrote:
> On 7/11/23 14:45, Johnathan Tiamoh wrote:
> > Hello Adrian
> >
> > 1) PgBouncer version.
> >
> > pgbouncer.1.7.2
>
> PgBouncer most recent version is
...' mean there is more then one
PgBouncer instance in use?
Yes, I have more than 3 pgbouncers for different connections.
On Tue, Jul 11, 2023 at 12:19 PM Adrian Klaver
wrote:
> On 7/11/23 08:53, Johnathan Tiamoh wrote:
> > I can connect.
> >
> > All applications and other us
I can connect.
All applications and other users that connect from to the databases through
the pgbouncers can't connect.
On Tue, Jul 11, 2023 at 11:46 AM Adrian Klaver
wrote:
> On 7/10/23 20:45, Laurenz Albe wrote:
> > On Mon, 2023-07-10 at 20:38 -0400, Johnathan Tiamoh wrote:
&
know
> the manual works needed to perform while migration from 9.8 to 14.8)
>
> 3. Which documentation needs to be followed to perform this upgrade ??
>
> Any hints much appreciated..
> Krishane
>
> On Mon, Jul 10, 2023 at 11:46 PM Johnathan Tiamoh <
> johnathantia.
27.385 CDT| XXX (60930)|
APPNAME=[unknown]| DB=postgres| USER=grafana| PID=9061| 2| authentication|
PGE-28P01: DETAIL: Connection matched pg_hba.conf line 113: "host
all all 0.0.0.0/0 md5"
On Mon, Jul 10, 2023 at 6:36 PM Adrian Klaver
wrote:
> On 7
proftpd| USER=proftpd|
PID=9053| 2| authentication| PGE-28P01: DETAIL: Connection matched
pg_hba.conf line 113: "hostall all 0.0.0.0/0
md5"
On Mon, Jul 10, 2023 at 4:00 PM Adrian Klaver
wrote:
> On 7/10/23 12:55, Johnathan Tiamoh wrote:
>
> Please reply to li
> wish is the default
for 14.8
pg_hba.conf md5
Thank you.
On Mon, Jul 10, 2023 at 3:38 PM Adrian Klaver
wrote:
> On 7/10/23 11:15, Johnathan Tiamoh wrote:
> > Hello,
> >
> > I upgraded from postgresql 9.5 to 14.8. After the upgrade users were not
> >
because as per postgresql documentation, that
should work.
I have previously done a similar upgrade and did not face similar issues.
Kind regards
Johnathan Tiamoh
38 matches
Mail list logo
