Rocksolid Light

Welcome to Rocksolid Light

mail  files  register  newsreader  groups  login

Message-ID:  

"Don't fear the pen. When in doubt, draw a pretty picture." -- Baker's Third Law of Design.


computers / Helpdesk / Re: Postgresql install fuckup

SubjectAuthor
* Postgresql install fuckuptrw
+* Postgresql install fuckupRetro Guy
|`* Postgresql install fuckupanonymous
| `* Postgresql install fuckupanonymous
|  `* Postgresql install fuckupRetro Guy
|   `* Postgresql install fuckupanonymous
|    `- Postgresql install fuckuptrw
+* Postgresql install fuckuptrw
|+- Postgresql install fuckupRetro Guy
|`* Postgresql install fuckupRetro Guy
| `- Postgresql install fuckupRetro Guy
`- Postgresql install fuckuptrw

1
Re: Postgresql install fuckup

<20190810154752.21d42ca7@desktop14.dt>

 copy mid

https://news.novabbs.org/computers/article-flat.php?id=15&group=rocksolid.shared.helpdesk#15

 copy link   Newsgroups: rocksolid.shared.helpdesk
Path: i2pn2.org!i2pn.org!rocksolid2!.POSTED.ip68-2-45-86.ph.ph.cox.net!not-for-mail
From: retro_guy@retrobbs.rocksolidbbs.com (Retro Guy)
Newsgroups: rocksolid.shared.helpdesk
Subject: Re: Postgresql install fuckup
Date: Sat, 10 Aug 2019 15:47:52 -0700
Organization: novabbs
Message-ID: <20190810154752.21d42ca7@desktop14.dt>
References: <acb381e4401fc23c2bc55efcd63f9f86@def4>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Injection-Info: novabbs.com; posting-account="retro2"; posting-host="ip68-2-45-86.ph.ph.cox.net:68.2.45.86";
logging-data="7280"; mail-complaints-to="usenet@novabbs.com"
X-Newsreader: Claws Mail 3.11.1 (GTK+ 2.24.25; x86_64-pc-linux-gnu)
 by: Retro Guy - Sat, 10 Aug 2019 22:47 UTC

On Sat, 10 Aug 2019 20:40:16+0000
trw <trw@anon.com> wrote:

> I cannot install postgresql-9.6 on a vm with debian stretch (see
> atteched screenshot). Seems like postgresql-common cannot be
> configured, and as a consequence the rest of the packets neither.
>
> Tried all kinds of repairs with dkpg, apt and aptitude, but nothing
> makes any difference. There are two or three posts I can find, but no
> solution that helps me.
>
> Thoughts, anyone ?
>
Have you done apt update first?

I just installed postgresql as a test on stretch and it worked fine.

Does postgresql-common possibly require a real (or appearing to be
real) hostname setup on the server?

Retro Guy

--
Posted via novabbs

Re: Postgresql install fuckup

<6dd20754fb3db0865cb0d37bc7ee5bf0$1@z5bqfv5v75kxy7pj.onion>

 copy mid

https://news.novabbs.org/computers/article-flat.php?id=16&group=rocksolid.shared.helpdesk#16

 copy link   Newsgroups: rocksolid.shared.helpdesk
Path: i2pn2.org!i2pn.org!rocksolid2!def2!.POSTED.localhost!not-for-mail
From: anonymous@def2.anon (anonymous)
Newsgroups: rocksolid.shared.helpdesk
Subject: Re: Postgresql install fuckup
Date: Sun, 11 Aug 2019 11:20:12 -0000 (UTC)
Organization: def2org
Message-ID: <6dd20754fb3db0865cb0d37bc7ee5bf0$1@z5bqfv5v75kxy7pj.onion>
References: <acb381e4401fc23c2bc55efcd63f9f86@def4> <20190810154752.21d42ca7@desktop14.dt>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Date: Sun, 11 Aug 2019 11:20:12 -0000 (UTC)
Injection-Info: def2.org; posting-host="localhost:127.0.0.1";
logging-data="12304"; mail-complaints-to="usenet@def2.org"
 by: anonymous - Sun, 11 Aug 2019 11:20 UTC

>Have you done apt update first?

Yes, I did apt update && apt upgrade before.

>I just installed postgresql as a test on stretch and it worked fine.

Was it a vm ? If yes, could you put the image somewhere to download ?

>Does postgresql-common possibly require a real (or appearing to be
real) hostname setup on the server?

I wouldn't know why, but even so, the vm had a real looking hostname.

cheers

trw
Posted on def2

Re: Postgresql install fuckup

<4b6de78fb0ae49d311c3bf3533d7c5f5$1@z5bqfv5v75kxy7pj.onion>

 copy mid

https://news.novabbs.org/computers/article-flat.php?id=17&group=rocksolid.shared.helpdesk#17

 copy link   Newsgroups: rocksolid.shared.helpdesk
Path: i2pn2.org!i2pn.org!rocksolid2!def2!.POSTED.localhost!not-for-mail
From: anonymous@def2.anon (anonymous)
Newsgroups: rocksolid.shared.helpdesk
Subject: Re: Postgresql install fuckup
Date: Sun, 11 Aug 2019 11:31:14 -0000 (UTC)
Organization: def2org
Message-ID: <4b6de78fb0ae49d311c3bf3533d7c5f5$1@z5bqfv5v75kxy7pj.onion>
References: <acb381e4401fc23c2bc55efcd63f9f86@def4> <20190810154752.21d42ca7@desktop14.dt> <6dd20754fb3db0865cb0d37bc7ee5bf0$1@z5bqfv5v75kxy7pj.onion>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Date: Sun, 11 Aug 2019 11:31:14 -0000 (UTC)
Injection-Info: def2.org; posting-host="localhost:127.0.0.1";
logging-data="12895"; mail-complaints-to="usenet@def2.org"
 by: anonymous - Sun, 11 Aug 2019 11:31 UTC

btw, I was using the vm image that runs def2. so it is really unclear to
me what is going on (had no problems with that one before).
Posted on def2

Re: Postgresql install fuckup

<20190814013922.74d263c1@desktop14.dt>

 copy mid

https://news.novabbs.org/computers/article-flat.php?id=18&group=rocksolid.shared.helpdesk#18

 copy link   Newsgroups: rocksolid.shared.helpdesk
Path: i2pn2.org!i2pn.org!rocksolid2!.POSTED.ip68-2-45-86.ph.ph.cox.net!not-for-mail
From: retro_guy@retrobbs.rocksolidbbs.com (Retro Guy)
Newsgroups: rocksolid.shared.helpdesk
Subject: Re: Postgresql install fuckup
Date: Wed, 14 Aug 2019 01:39:22 -0700
Organization: novabbs
Message-ID: <20190814013922.74d263c1@desktop14.dt>
References: <acb381e4401fc23c2bc55efcd63f9f86@def4>
<20190810154752.21d42ca7@desktop14.dt>
<6dd20754fb3db0865cb0d37bc7ee5bf0$1@z5bqfv5v75kxy7pj.onion>
<4b6de78fb0ae49d311c3bf3533d7c5f5$1@z5bqfv5v75kxy7pj.onion>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Injection-Info: novabbs.com; posting-account="retro2"; posting-host="ip68-2-45-86.ph.ph.cox.net:68.2.45.86";
logging-data="7280"; mail-complaints-to="usenet@novabbs.com"
X-Newsreader: Claws Mail 3.11.1 (GTK+ 2.24.25; x86_64-pc-linux-gnu)
 by: Retro Guy - Wed, 14 Aug 2019 08:39 UTC

On Sun, 11 Aug 2019 11:31:14 -0000 (UTC)
anonymous@def2.anon (anonymous) wrote:

> btw, I was using the vm image that runs def2. so it is really unclear
> to me what is going on (had no problems with that one before).
> Posted on def2
>
>

I just installed on the vm that I have (which I believe is the same
images running def2). This is the vm I made available for download a
while back.

It seems to have worked fine:

apt update
apt install postgresql
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following additional packages will be installed:
libpq5 libsensors4 libxslt1.1 postgresql-9.6 postgresql-client-9.6
postgresql-client-common postgresql-common
postgresql-contrib-9.6 ssl-cert sysstat
Suggested packages:
lm-sensors postgresql-doc locales-all postgresql-doc-9.6
libdbd-pg-perl openssl-blacklist isag
The following NEW packages will be installed:
libpq5 libsensors4 libxslt1.1 postgresql postgresql-9.6
postgresql-client-9.6 postgresql-client-common
postgresql-common postgresql-contrib-9.6 ssl-cert sysstat
0 upgraded, 11 newly installed, 0 to remove and 17 not upgraded.
Need to get 7,206 kB/7,227 kB of archives.
After this operation, 33.2 MB of additional disk space will be used.
Do you want to continue? [Y/n] Y

....

Creating config file /etc/postgresql-common/createcluster.conf with new
version

Creating config file /etc/logrotate.d/postgresql-common with new version
Building PostgreSQL dictionaries from installed myspell/hunspell
packages... Removing obsolete dictionary files:
Created
symlink /etc/systemd/system/multi-user.target.wants/postgresql.service
→ /lib/systemd/system/postgresql.service. Setting up libsensors4:amd64
(1:3.4.0-4) ... Processing triggers for man-db (2.7.6.1-2) ... Setting
up sysstat (11.4.3-2) ...

Creating config file /etc/default/sysstat with new version
update-alternatives: using /usr/bin/sar.sysstat to provide /usr/bin/sar
(sar) in auto mode Setting up postgresql-client-9.6
(9.6.15-0+deb9u1) ... update-alternatives:
using /usr/share/postgresql/9.6/man/man1/psql.1.gz to
provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode Setting
up postgresql-9.6 (9.6.15-0+deb9u1) ... Creating new cluster
9.6/main ... config /etc/postgresql/9.6/main
data /var/lib/postgresql/9.6/main locale en_US.UTF-8
socket /var/run/postgresql
port 5432
update-alternatives:
using /usr/share/postgresql/9.6/man/man1/postmaster.1.gz to
provide /usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto
mode Setting up postgresql (9.6+181+deb9u2) ... Setting up
postgresql-contrib-9.6 (9.6.15-0+deb9u1) ... Processing triggers for
systemd (232-25+deb9u11) ... Processing triggers for libc-bin
(2.24-11+deb9u4) ...

--
Posted via novabbs

Re: Postgresql install fuckup

<f010694c6c57c459be1a21021fe7da39$1@def2.i2p>

 copy mid

https://news.novabbs.org/computers/article-flat.php?id=19&group=rocksolid.shared.helpdesk#19

 copy link   Newsgroups: rocksolid.shared.helpdesk
Path: i2pn2.org!i2pn.org!rocksolid2!def2!.POSTED.localhost!not-for-mail
From: anonymous@def2.anon (anonymous)
Newsgroups: rocksolid.shared.helpdesk
Subject: Re: Postgresql install fuckup
Date: Wed, 14 Aug 2019 17:36:04 -0000 (UTC)
Organization: def2org
Message-ID: <f010694c6c57c459be1a21021fe7da39$1@def2.i2p>
References: <acb381e4401fc23c2bc55efcd63f9f86@def4> <20190810154752.21d42ca7@desktop14.dt> <6dd20754fb3db0865cb0d37bc7ee5bf0$1@z5bqfv5v75kxy7pj.onion> <4b6de78fb0ae49d311c3bf3533d7c5f5$1@z5bqfv5v75kxy7pj.onion> <20190814013922.74d263c1@desktop14.dt>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Date: Wed, 14 Aug 2019 17:36:04 -0000 (UTC)
Injection-Info: def2.org; posting-host="localhost:127.0.0.1";
logging-data="14360"; mail-complaints-to="usenet@def2.org"
 by: anonymous - Wed, 14 Aug 2019 17:36 UTC

thanks for trying, i will try again with an older version of the image. i
really want to see that running....

cheers

trw
Posted on def2

Re: Postgresql install fuckup

<9b0e7c90eb4f4c6b64307c79216ce04a@def4>

 copy mid

https://news.novabbs.org/computers/article-flat.php?id=20&group=rocksolid.shared.helpdesk#20

 copy link   Newsgroups: rocksolid.shared.helpdesk
Path: i2pn2.org!i2pn.org!rocksolid2!def5!POSTED.localhost!not-for-mail
From: trw@anon.com (trw)
Newsgroups: rocksolid.shared.helpdesk
Message-ID: <9b0e7c90eb4f4c6b64307c79216ce04a@def4>
Subject: Re: Postgresql install fuckup
Date: Wed, 14 Aug 2019 18:16:01+0000
Organization: def5
In-Reply-To: <f010694c6c57c459be1a21021fe7da39$1@def2.i2p>
References: <f010694c6c57c459be1a21021fe7da39$1@def2.i2p>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
 by: trw - Wed, 14 Aug 2019 18:16 UTC

btw, strange thing that it runs on your vm but not on mine. either i do something wrong to the system, or somebody is on my box. hmmmm...

Posted on def4

Re: Postgresql install fuckup

<835b2620ac015cdf309c42448d71e2b2@def4>

 copy mid

https://news.novabbs.org/computers/article-flat.php?id=21&group=rocksolid.shared.helpdesk#21

 copy link   Newsgroups: rocksolid.shared.helpdesk
Path: i2pn2.org!i2pn.org!rocksolid2!def5!POSTED.localhost!not-for-mail
From: trw@anon.com (trw)
Newsgroups: rocksolid.shared.helpdesk
Message-ID: <835b2620ac015cdf309c42448d71e2b2@def4>
Subject: Re: Postgresql install fuckup
Date: Sat, 17 Aug 2019 22:42:23+0000
Organization: def5
In-Reply-To: <acb381e4401fc23c2bc55efcd63f9f86@def4>
References: <acb381e4401fc23c2bc55efcd63f9f86@def4>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
 by: trw - Sat, 17 Aug 2019 22:42 UTC

i have tried a lot of things now, including a dist upgrade to buster, but the error remains.
guess it must have something to do with services not restarting due insufficient space on a tmpfs. do you have the same error messages during updates, and if not, could you post the output of df .-h (the tmpfs /run/user/1000 part) ?
For my vm, this is 12M. I would guess that this is to low, I just don't know where to change this setting.

cheers

trw

Posted on def4

Re: Postgresql install fuckup

<2545e7f0632970754d3835ff76ab34a4$1@news.novabbs.com>

 copy mid

https://news.novabbs.org/computers/article-flat.php?id=22&group=rocksolid.shared.helpdesk#22

 copy link   Newsgroups: rocksolid.shared.helpdesk
Path: i2pn2.org!i2pn.org!rocksolid2!.POSTED.localhost!not-for-mail
From: Retro Guy@rslight.i2p (Retro Guy)
Newsgroups: rocksolid.shared.helpdesk
Subject: Re: Postgresql install fuckup
Date: Sat, 17 Aug 2019 23:03:56 -0000 (UTC)
Organization: Rocksolid Light
Message-ID: <2545e7f0632970754d3835ff76ab34a4$1@news.novabbs.com>
References: <acb381e4401fc23c2bc55efcd63f9f86@def4> <835b2620ac015cdf309c42448d71e2b2@def4>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Date: Sat, 17 Aug 2019 23:03:56 -0000 (UTC)
Injection-Info: novabbs.com; posting-account="retrobbs1"; posting-host="localhost:127.0.0.1";
logging-data="15794"; mail-complaints-to="usenet@novabbs.com"
User-Agent: rslight (http://news.novabbs.com)
X-Spam-Checker-Version: SpamAssassin 3.4.2 (2018-09-13) on novabbs.com
X-Spam-Level: ***
X-Rslight-Site: $2y$10$wpSBiv7.YztXFfitYB51Ye2tiDXlPOJ0IDqGwhrcdN6dZMgxiv3Si
 by: Retro Guy - Sat, 17 Aug 2019 23:03 UTC

trw wrote:

> i have tried a lot of things now, including a dist upgrade to buster, but
the error remains.
> guess it must have something to do with services not restarting due
insufficient space on a tmpfs. do you have the same error messages during
updates, and if not, could you post the output of df .-h (the tmpfs
/run/user/1000 part) ?
> For my vm, this is 12M. I would guess that this is to low, I just don't know
where to change this setting.

On the vm here I get:

df . -h
Filesystem Size Used Avail Use% Mounted on
tmpfs 100M 0 100M 0% /run/user/1000

Retro Guy
--
Posted on Rocksolid Light

Re: Postgresql install fuckup

<4db3682a43f072938e216965df16f17c$1@news.novabbs.com>

 copy mid

https://news.novabbs.org/computers/article-flat.php?id=23&group=rocksolid.shared.helpdesk#23

 copy link   Newsgroups: rocksolid.shared.helpdesk
Path: i2pn2.org!i2pn.org!rocksolid2!.POSTED.localhost!not-for-mail
From: Retro Guy@rslight.i2p (Retro Guy)
Newsgroups: rocksolid.shared.helpdesk
Subject: Re: Postgresql install fuckup
Date: Sat, 17 Aug 2019 23:10:19 -0000 (UTC)
Organization: Rocksolid Light
Message-ID: <4db3682a43f072938e216965df16f17c$1@news.novabbs.com>
References: <acb381e4401fc23c2bc55efcd63f9f86@def4> <835b2620ac015cdf309c42448d71e2b2@def4>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Date: Sat, 17 Aug 2019 23:10:19 -0000 (UTC)
Injection-Info: novabbs.com; posting-account="retrobbs1"; posting-host="localhost:127.0.0.1";
logging-data="18041"; mail-complaints-to="usenet@novabbs.com"
User-Agent: rslight (http://news.novabbs.com)
X-Spam-Checker-Version: SpamAssassin 3.4.2 (2018-09-13) on novabbs.com
X-Spam-Level: *
X-Rslight-Site: $2y$10$953DXs39VZxBTS53hjUZwOC27QLKhxp56/fiLvnGcj8t1F8wFOEeq
 by: Retro Guy - Sat, 17 Aug 2019 23:10 UTC

trw wrote:

> For my vm, this is 12M. I would guess that this is to low, I just don't know
where to change this setting.

I'm not sure, I'm guessing systemd took control of that (no, I'm not a
systemd hater, just realize a lot of things moved that direction).

Anyway, maybe an fstab entry would override?

--
Posted on Rocksolid Light

Re: Postgresql install fuckup

<13bd3753537a1de9274308e1b652e36e$1@news.novabbs.com>

 copy mid

https://news.novabbs.org/computers/article-flat.php?id=24&group=rocksolid.shared.helpdesk#24

 copy link   Newsgroups: rocksolid.shared.helpdesk
Path: i2pn2.org!i2pn.org!rocksolid2!.POSTED.localhost!not-for-mail
From: Retro Guy@rslight.i2p (Retro Guy)
Newsgroups: rocksolid.shared.helpdesk
Subject: Re: Postgresql install fuckup
Date: Sun, 18 Aug 2019 08:11:22 -0000 (UTC)
Organization: Rocksolid Light
Message-ID: <13bd3753537a1de9274308e1b652e36e$1@news.novabbs.com>
References: <acb381e4401fc23c2bc55efcd63f9f86@def4> <835b2620ac015cdf309c42448d71e2b2@def4> <4db3682a43f072938e216965df16f17c$1@news.novabbs.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Date: Sun, 18 Aug 2019 08:11:22 -0000 (UTC)
Injection-Info: novabbs.com; posting-account="retrobbs1"; posting-host="localhost:127.0.0.1";
logging-data="19218"; mail-complaints-to="usenet@novabbs.com"
User-Agent: rslight (http://news.novabbs.com)
X-Spam-Checker-Version: SpamAssassin 3.4.2 (2018-09-13) on novabbs.com
X-Spam-Level: *
X-Rslight-Site: $2y$10$deEbbHldKERsVGTw9ZLVdOBnMH3V.211iYpY88LbUIgJUqAQNELxO
 by: Retro Guy - Sun, 18 Aug 2019 08:11 UTC

Retro Guy wrote:

> trw wrote:

>> For my vm, this is 12M. I would guess that this is to low, I just don't
know
> where to change this setting.

> I'm not sure, I'm guessing systemd took control of that (no, I'm not a
> systemd hater, just realize a lot of things moved that direction).

> Anyway, maybe an fstab entry would override?

Take a look in /etc/systemd/logind.conf:

RuntimeDirectorySize=

--
Posted on Rocksolid Light

Re: Postgresql install fuckup

<a41f8800ac501fb5ff59f422f054a9af@def4>

 copy mid

https://news.novabbs.org/computers/article-flat.php?id=25&group=rocksolid.shared.helpdesk#25

 copy link   Newsgroups: rocksolid.shared.helpdesk
Path: i2pn2.org!i2pn.org!rocksolid2!def5!POSTED.localhost!not-for-mail
From: trw@anon.com (trw)
Newsgroups: rocksolid.shared.helpdesk
Message-ID: <a41f8800ac501fb5ff59f422f054a9af@def4>
Subject: Re: Postgresql install fuckup
Date: Sun, 18 Aug 2019 10:50:54+0000
Organization: def5
In-Reply-To: <acb381e4401fc23c2bc55efcd63f9f86@def4>
References: <acb381e4401fc23c2bc55efcd63f9f86@def4>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
 by: trw - Sun, 18 Aug 2019 10:50 UTC

alright, i increased
RuntimeDirectorySize=
in /etc/systemd/logind.conf to 100M, which reduced the number of error messages, and then did
mount -o remount,size=100M /run
to increase also the size of /run, and that took care of the rest, postgresql is installed.
That was a long way for a small step...thanks for your help.

cheers

trw

Posted on def4

Postgresql install fuckup

<acb381e4401fc23c2bc55efcd63f9f86@def4>

 copy mid

https://news.novabbs.org/computers/article-flat.php?id=339&group=rocksolid.shared.helpdesk#339

 copy link   Newsgroups: rocksolid.shared.helpdesk
Path: rocksolid2!def5!POSTED.localhost!not-for-mail
From: trw@anon.com (trw)
Newsgroups: rocksolid.shared.helpdesk
Message-ID: <acb381e4401fc23c2bc55efcd63f9f86@def4>
Subject: Postgresql install fuckup
Date: Sat, 10 Aug 2019 20:40:16+0000
Organization: def5
MIME-Version: 1.0
Content-Type: multipart/mixed;boundary="------------2D7B91D89218F6D0182BBE7B"
 by: trw - Sat, 10 Aug 2019 20:40 UTC
Attachments: "postgresql_fuckup.jp" (image/jpeg)

I cannot install postgresql-9.6 on a vm with debian stretch (see atteched screenshot).
Seems like postgresql-common cannot be configured, and as a consequence the rest of the packets neither.

Tried all kinds of repairs with dkpg, apt and aptitude, but nothing makes any difference. There are two or three posts I can find, but no solution that helps me.

Thoughts, anyone ?

cheers

trw

Posted on def4

Attachments:  
1
server_pubkey.txt

rocksolid light 0.9.7
clearnet tor