Hi Christian
After
$ sudo chown -R postgres:postgres /dbERP
You need to create

/dbData/var/lib/postgresql/<version>/data

for both version = 9.6 and version=11
Then you need to run pg_createcluster to create a PostgreSQL cluster with:

|$||||/usr/bin/pg_createcluster -u postgres -d
/dbData/var/lib/postgresql/9.6/data -s /dbData/var/run/postgresql -l
/dbData/var/log/postgresql/postgresql-9.6-data.log 9.6 data|


and then

|$||||/usr/bin/pg_createcluster -u postgres -d
/dbData/var/lib/postgresql/11/data -s /dbData/var/run/postgresql -l
/dbData/var/log/postgresql/postgresql-11-data.log 11 data|


In short I will follow your suggestion to make a list of commands trying
to recreate the problem in a virtual machine.

By the way Christian, your mkdir statements are very clever. I did not
know one can create several directories at once.

Regards
Ramiro

On 4/1/19 5:41 AM, Christian Ehrhardt  wrote:
> Hi Ramiro, that would be a very severe bug.
> But let us find what actually happened in your case as I can not reproduce.
>
> $ apt install postgresql
> $ mkdir -p /dbERP/var/{lib,log,run}
> $ mkdir -p /dbERP/var/lib/postgresql/{11,9.6}
> $ sudo chown -R postgres:postgres /dbERP
>
> This shows all as expected:
> $ ls -laF /dbERP/{,*,var/lib/postgresql,var/lib/postgresql/*}
>
> After install of clamav nothing changed:
> $ apt install clamav
> $ ls -laF /dbERP/{,*,var/lib/postgresql,var/lib/postgresql/*}
>
> So I can't see what/why happened to you.
>
> Are by any chance the directories bind mounted to other places?
> What is the output of "mount"?
>
> Since you say it reproduces for you - could you create a list of
> steps/commands to run in a fresh VM or LXD container that will recreate
> the issue?
>

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1822217

Title:
  Clamav, netdev and others changing owner, group

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/clamav/+bug/1822217/+subscriptions

-- 
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to