Re: Database setup for pgarchives

>
> 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'*