Looks like PostgreSQL is not running or you got the wrong path to the unix socket.
Am 03.09.18 um 01:15 schrieb Fabian A. Santiago: > I should add that it worked fine using Mongodb but was so slow. If I > hadn't made that clear prior. > > -- > > On Sunday, Sep 02, 2018 at 7:08 PM, Fabian A. Santiago > <fsanti...@garbage-juice.com <mailto:fsanti...@garbage-juice.com>> > wrote: > Ok, > > So trying to run in user space produces: > > > [{/build/hockeypuck-lsqW7K/hockeypuck-2.0~rc2~1437340214+54df397~trusty/src/gopkg.in/hockeypuck/pghkp.v1/storage.go:112: > } > > {/build/hockeypuck-lsqW7K/hockeypuck-2.0~rc2~1437340214+54df397~trusty/src/gopkg.in/hockeypuck/pghkp.v1/storage.go:122: > } {dial unix /var/run/postgresql/.s.PGSQL.5432: no such file or > directory}] > > I have postgresql version 10.5 installed on Ubuntu 14.04.5. Thanks > in advance for any help you can offer. > > -- > > On Sunday, Sep 02, 2018 at 6:54 PM, Fabian A. Santiago > <fsanti...@garbage-juice.com > <mailto:fsanti...@garbage-juice.com>> wrote: > Alright....import was much quicker. But now the service won't > start. Triaging now. > > -- > > On Saturday, Sep 01, 2018 at 9:42 PM, Fabian A. Santiago > <fsanti...@garbage-juice.com > <mailto:fsanti...@garbage-juice.com>> wrote: > Close, > > Command needs to be run as hockeypuck user. > > You need to create an hkp dB and hockeypuck role and grant > ownership over the dB (at least that worked for me). > > Otherwise, it’s working and importing now. Thanks for your > help. I’ll advise when it’s done and I can see whether or > not I have good recon. > > -- > > On Saturday, Sep 01, 2018 at 7:14 PM, Moritz Wirth > <m...@flanga.io <mailto:m...@flanga.io>> wrote: > > You have to set the filters to get the reconciliation > working with SKS: > > [hockeypuck.conflux.recon] > reconAddr=":11370" > version="1.1.6" > filters=["yminsky.dedup", "yminsky.merge"] > > For Postgresql: > > [hockeypuck.openpgp.db] driver="postgres-jsonb" > dsn="database=hkp host=/var/run/postgresql port=5432 sslmode=disable" Create > the database and run hockeypuck-load as postgre user - that should be enough > to start with a clean installation (you must use postgresql > 9.4) - the > tables are created by hockeypuck-load - 100k keys take about 3-5 minutes to > be imported so the whole process should be done in 3-4 hours. In case your > import fails, I can provide a database dump of my MongoDB/PostgreSQL > databases. Regards, Moritz > > > Am 02.09.18 um 01:10 schrieb Fabian A. Santiago: >> Could definitely use help on the parameters. And yes >> it was erorring on recon. So that explains why it >> never caught up. I’d appreciate the config help if >> you could. Thanks. >> >> -- >> >> On Saturday, Sep 01, 2018 at 2:14 AM, dirk >> astrath <dastr...@gmx.de >> <mailto:dastr...@gmx.de>> wrote: >> Hello, >> >> Postgres ist way faster and sustainable compared >> to mongodb (tested both >> on different machines). >> >> The recon-parameters on hockeypuck-site needs to >> be modified so it can >> synchronize to the network (check the logfiles on >> sks and hockeypuck size). >> >> Unfortunately I don't run any keyserver currently >> due to several issues, >> so i need to pull these settings out of a backup >> ... but can do it if >> neccessary ... >> >> Kind regards, >> >> dirk >> >> On 31.08.2018 21:06, Fabian A. Santiago wrote: >>> can anyone on here assist with setting up >>> hockeypuck? >>> >>> I've received help prior from a friendly user >>> who got me up & running >>> with mongodb. but it was SLOW to import a dump >>> (days) and never caught >>> up with my sks keyserver (maybe erroring out on >>> gossip). >>> >>> would it be faster using postgresql? >>> >>> is there something special to configure in order >>> to get it to gossip >>> properly with sks servers as well as other >>> hockeypucks? >>> >>> are there any instructions out there for setting >>> up postgresql properly >>> to be used with it? >>> >>> anything anyone can provide would be great as >>> the hockeypuck docs site >>> https://hockeypuck.github.io doesn't contain >>> much in the way of finer >>> details. >>> >>> thanks. >>> >>> >>> >>> _______________________________________________ >>> Sks-devel mailing list >>> Sks-devel@nongnu.org >>> https://lists.nongnu.org/mailman/listinfo/sks-devel >>> >> >> >> >> >> _______________________________________________ Sks-devel >> mailing list Sks-devel@nongnu.org >> https://lists.nongnu.org/mailman/listinfo/sks-devel > > > > _______________________________________________ > Sks-devel mailing list > Sks-devel@nongnu.org > https://lists.nongnu.org/mailman/listinfo/sks-devel
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Sks-devel mailing list Sks-devel@nongnu.org https://lists.nongnu.org/mailman/listinfo/sks-devel
