Eric Mamet's questions

Two weeks ago, I installed Ubuntu 18.04 in the Windows Subsystem for Linux.

In there, I installed PostgreSQL 11 using:

sudo apt-get install postgresql-11

At the time, I could start my PostgreSQL using this command:

sudo -u postgres /usr/lib/postgresql/11/bin/pg_ctl -D /etc/postgresql/11/main -l /var/log/postgresql/postgresql-11-main.log start

So far so good.

Two weeks later, I try to start this PostgreSQL engine using the same command and I get this error:

"FATAL:  could not create lock file "/var/run/postgresql/.s.PGSQL.5432.lock": No such file or directory"

I created that folder and gave it chmod 777 to avoid permission problems.

Then I get:

LOG:  database system was interrupted; last known up at 2019-02-16 17:57:02 STD
PANIC:  could not flush dirty data: Function not implemented
LOG:  startup process (PID 94) was terminated by signal 6: Aborted

Any idea what might be wrong?

I installed Ubuntu 18.04 within the "Windows Subsystem for Linux"

Within Ubuntu itself, I installed Postgresql 11 and I can connect to it using psql.

Now, what is the address of my postgres server from Windows?

I would like to access it using DBeaver.

In the windows Linux Subsystem, I installed ubuntu 18.04

In there, I installed postgresql 11 using sudo apt-get install postgresql-11

I got this back

Ver Cluster Port Status Owner Data directory Log file 11 main 5432 down postgres /var/lib/postgresql/11/main /var/log/postgresql/postgresql-11-main.log

When I run "psql", I get the error

psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

Then I tried to specify a folder, like this

psql -h /var/lib/postgresql/11/main

and I get this error...

psql: could not connect to server: Permission denied Is the server running locally and accepting connections on Unix domain socket "/var/lib/postgresql/11/main/.s.PGSQL.5432"?

Any hint?

Thanks

When I download ubuntu, it always gives me an image for amd...

Like ubuntu-18.04-desktop-amd64.iso

Where can I find an download for Intel?

I try to install that through Oracle VirtualBox so maybe I am doing something wrong in the virtual machine I create...

I installed ubuntu on a Hyper-V virtual machine. I allocated a minimum of 2Gbs mem and initially I had not specified a maximum. My desktop (host) has 16Gbs memory and loads available.

Yesterday, everything was working fine and I saved my ubuntu virtual machine state. When I tried to start the virtual machine, it kept failing on memory allocation... According to Hyper-V, it was asking for 13Gbs while I only had 12Gbs available.

I finally managed to start the virtual machine by deleting the saved state and capping the memory to 4Gbs (although it seems to still use 5Gbs)

What might be the reason for using so much memory?

PS: I have not installed anything beyond the base ubuntu installation because I could not get networking to work anyway...

ps returns bash as the name of the process... I would like the name of the shell script instead.

For instance, if my script is TestEric.sh, I would like to list the number of instances of that script currently running.