Re: Database setup for pgarchives - Mailing list pgsql-www

From Sahil Harpal
Subject Re: Database setup for pgarchives
Date
Msg-id CAKi=nnfENiGVhbM9Arr-xNP6qRTtQ4phgc5HwJ-N-jQhWf6LNA@mail.gmail.com
Whole thread Raw
In response to Re: Database setup for pgarchives  (Sahil Harpal <sahilharpal1234@gmail.com>)
List pgsql-www
Also I created a database in the WSL but I'm not getting how can I add the pgsql-hackers list in the database which is required to load the data using mbox. 
Could you please share the SQL query that I need to use for the list name and listgroup insertion?

This insertion part is done using following queries.
  • INSERT INTO listgroups (groupid, groupname, sortkey) VALUES (1, 'Developer lists', 1);
  • INSERT INTO lists (listid, listname, shortdesc, description, active, groupid, subscriber_access) VALUES (1, 'pgsql-hackers', 'pgsql-hackers', 'The PostgreSQL developers team lives here. Discussion of current development issues, problems and bugs, and proposed new features. If your question cannot be answered by people in the other lists, and it is likely that only a developer will know the answer, you may re-post your question in this list. You must try elsewhere first!', True, 1, True); 
Now the execution of load_message.py gives below error:
Failed to parse mbox:
b'/bin/sh: 1: formail: not found\n'

pgsql-www by date:

Previous
From: Sahil Harpal
Date:
Subject: Re: Database setup for pgarchives
Next
From: Joe Conway
Date:
Subject: Re: Wiki editor request