How do I install PostgreSQL and import user data?

[drmason789]

Okay, so I've exported the user data according to #5 - how do I set up PostgreSQL on the new system?

[drmason789]

Installing PostgreSQL

PostgreSQL is database server software that X-Dream uses to manage user data.
You may have it in the Trixter\Live folder: “\postgresql-9.1.3-1-windows.exe”

You could also download a more appropriate version from the PostgreSQL web site. If you are installing on a 64-bit system, you might want to get the 64-bit installer instead. Also, beyond version 9.x, the installers are a great deal larger so you might not want to bother with them if X-Dream is the only software you use that needs it.

When prompted for a password for the service account, use “postgres”.

If asked, don’t run Stack Builder.
Locate the PostgreSQL config file in the Trixter installation folder:

• Trixter\Live\pg_hba.conf

Locate the corresponding file in the PostgreSQL installation, e.g.

• C:\Program Files\PostgreSQL\9.1\data\pg_hba.conf

Make a backup copy of this file, and replace it with Trixter\Live\pg_hba.conf

This change is effectively as follows:
For the PostgreSQL config (installdir\data\pg_hba.conf, the default has a pair of lines that look like this:

# TYPE  DATABASE        USER            ADDRESS                 METHOD
# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
# IPv6 local connections:
host    all             all             ::1/128                 md5

But in the one provided with the v1 system, these lines are like this:

# TYPE  DATABASE        USER            ADDRESS                 METHOD
# IPv4 local connections:
host    all             all             127.0.0.1/32            trust
# IPv6 local connections:
host    all             all             ::1/128                 trust

I.e. "md5" changed to "trust"

Restart the PC (or just the postgresql service, if you know how to use the Services applet under administrative tools) so that it picks up the configuration changes.

Restoring the User Database (optional)

This is not necessary if you don’t want to transfer user data from another computer.

1. Double click the shortcut for the TrixterAppRelease executable that you created on the desktop. This should start the X-dream software. At some point between doing this and telling you to press the green button to start, the application creates a new database named “trixter” in the PostgreSQL server.

2. Exit from the application using Alt-F4.

3. Find the “pgAdmin III” application:
   

4. Click down to the trixter database using the password “postgres”, right click and select “Restore…”

5. Enter the path to your backup of the database and set the format and rolename options.

6. On the “Restore Options Welcome to Trixter X-Dream Bike Discussions! #1” tab, enable “Clean before restore”
   
7. Click “Restore”. Look for an exit code of 0.