Mailing List Archive: Trac 1.4.2 Hotcopy -> TracError: Unsupported database type "postgres"

Trac 1.4.2 Hotcopy -> TracError: Unsupported database type "postgres"

Apr 12, 2022, 9:30 AM

Post #1 of 3 (346 views)

Hi,

I'm running Trac 1.4.2 and I'm about to move it to a different server.
I'm using Postgresql as my DB.

When I try to create a backup as described here
<https://trac.edgewall.org/wiki/TracBackup> with the command
trac-admin /path/to/my/project hotcopy /path/to/backup/dir

I get this error message:

Error: Unable to check for upgrade of trac.db.api.DatabaseManager:
TracError: Unsupported database type "postgres"

The docco doesn't give any indication that this shouldn't work with
Postgresql.

I gather from googling that I can use the --no-database flag to stop it
backing up the DB and then use pg_dump or similar to backup the DB, but
shouldn't the hotcopy command work?

TIA,

Rob Hills
Waikiki, Western Australia

--
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/5d716f5e-5724-428c-a28e-5ae5b006fc16n%40googlegroups.com.

Re: Trac 1.4.2 Hotcopy -> TracError: Unsupported database type "postgres" [ In reply to ]

rjollos at gmail

Apr 12, 2022, 1:36 PM

Post #2 of 3 (345 views)

Permalink

On Tue, Apr 12, 2022 at 12:30 PM Rob Hills <rcp.hills@gmail.com> wrote:

> Hi,
>
> I'm running Trac 1.4.2 and I'm about to move it to a different server.
> I'm using Postgresql as my DB.
>
> When I try to create a backup as described here
> <https://trac.edgewall.org/wiki/TracBackup> with the command
> trac-admin /path/to/my/project hotcopy /path/to/backup/dir
>
> I get this error message:
>
> Error: Unable to check for upgrade of trac.db.api.DatabaseManager:
> TracError: Unsupported database type "postgres"
>
> The docco doesn't give any indication that this shouldn't work with
> Postgresql.
>
> I gather from googling that I can use the --no-database flag to stop it
> backing up the DB and then use pg_dump or similar to backup the DB, but
> shouldn't the hotcopy command work?
>
> TIA,
>
> Rob Hills
> Waikiki, Western Australia
>

trac-admin isn't finding the psycopg2 library. Running the following may
provide some clues:

$ pip list
$ which trac-admin

Then look for, is the "trac-admin" associated with the same Trac
installation that is running with the webserver?

Ryan

--
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/CA%2BBGpn_DQikEYdmP-87qAjcD%3D3Gtr%3DnMkeWk0mfFn-mWFw4wbw%40mail.gmail.com.

Re: Trac 1.4.2 Hotcopy -> TracError: Unsupported database type "postgres" [ In reply to ]

rcp.hills at gmail

Apr 14, 2022, 12:31 AM

Post #3 of 3 (345 views)

Permalink

Many thanks Ryan. It has been a while since I installed trac on this
particular server and I'd forgotten the virtualenv configuration I'd used
for it. There were of course two trac-admins and I wasn't running the one
inside the virtualenv. Now all sorted.

Cheers,

Rob Hills
Waikiki, Western Australia

On Wednesday, 13 April 2022 at 04:37:02 UTC+8 RjOllos wrote:

> On Tue, Apr 12, 2022 at 12:30 PM Rob Hills <rcp....@gmail.com> wrote:
>
>> Hi,
>>
>> I'm running Trac 1.4.2 and I'm about to move it to a different server.
>> I'm using Postgresql as my DB.
>>
>> When I try to create a backup as described here
>> <https://trac.edgewall.org/wiki/TracBackup> with the command
>> trac-admin /path/to/my/project hotcopy /path/to/backup/dir
>>
>> I get this error message:
>>
>> Error: Unable to check for upgrade of trac.db.api.DatabaseManager:
>> TracError: Unsupported database type "postgres"
>>
>> The docco doesn't give any indication that this shouldn't work with
>> Postgresql.
>>
>> I gather from googling that I can use the --no-database flag to stop it
>> backing up the DB and then use pg_dump or similar to backup the DB, but
>> shouldn't the hotcopy command work?
>>
>> TIA,
>>
>> Rob Hills
>> Waikiki, Western Australia
>>
>
> trac-admin isn't finding the psycopg2 library. Running the following may
> provide some clues:
>
> $ pip list
> $ which trac-admin
>
> Then look for, is the "trac-admin" associated with the same Trac
> installation that is running with the webserver?
>
> Ryan
>
>

--
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/489db88f-0e53-48ab-a6cd-d11c57fbbf6cn%40googlegroups.com.