Hi,
I have a postgresql server version 12.9 and trying to upgrade it to 14.5.
My OS is Centos 8 Stream and I already managed to install postgresql14.5
but when I'm trying to upgrade, I am encountering this error
bash-4.4$ /usr/pgsql-14/bin/pg_upgrade
--old-datadir=/home/dmartuser/pgdata/data/
--n
sses=''
-c unix_socket_permissions=0700 -c unix_socket_directories='/tmp'" start
Failure, exiting
Thanks,
Chris Albert Navarroza
Information Technology Officer I
CTCO - ITDS - RDMD
On Fri, Oct 21, 2022 at 10:08 PM Tom Lane wrote:
> chris navarroza writes:
>
g".
stopped waiting
pg_ctl: could not start server
Examine the log output.
Thanks,
Chris Albert Navarroza
Information Technology Officer I
CTCO - ITDS - RDMD
On Mon, Oct 24, 2022 at 8:12 AM Tom Lane wrote:
> chris navarroza writes:
> > could not connect to source postmaster star
Hi,
I install postgresql14.5 with the following commands
sudo yum install postgresql14-server postgresql14-contrib
sudo su postgres
cd /tmp
/usr/pgsql-14/bin/initdb -D /home/dmartuser/pgsql/14/data
and update the postgresql.conf to the new path, now when I start the
service, it has an error
oza
Information Technology Officer I
CTCO - ITDS - RDMD
On Mon, Oct 24, 2022 at 6:57 PM Jeffrey Walton wrote:
> On Mon, Oct 24, 2022 at 6:38 AM chris navarroza
> wrote:
> >
> > I install postgresql14.5 with the following commands
> >
> > sudo yum install postgresql14-se
I fixed it by editing the postgresql-14.service PGDATA path to the new
directory
Thanks,
butching
On Mon, Oct 24, 2022 at 7:25 PM chris navarroza
wrote:
> But I'm using a different path when I initdb /usr/pgsql-14/bin/initdb -D
> */home/dmartuser/pgsql/14/data
> *so "/va
Hi,
Ive created a read only user (SELECT PRIVILEGE) but it turns out that this
user can do this queries: SHOW work_mem; SET work_mem='40MB'; How do I
limit him?
Thanks,
Butching
