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 (mailto:Sks-devel@nongnu.org) > > > > > > > https://lists.nongnu.org/mailman/listinfo/sks-devel > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > _______________________________________________ Sks-devel mailing > > > > > list Sks-devel@nongnu.org (mailto: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