Обсуждение: BUG #4846: Error reading file: config

The following bug has been logged online:

Bug reference:      4846
Logged by:          Anders Gunnarsson
Email address:      fsogren@passagen.se
PostgreSQL version: newest
Operating system:   Windows XP
Description:        Error reading file: config
Details:

Problem running post-install step. Installation may not complete correctly
Error reading file D:/Program/POSTGRESQL/8.4/data/postgresql.conf

Help!?!?

On Wed, Jun 10, 2009 at 9:40 AM, Anders Gunnarsson<fsogren@passagen.se> wro=
te:
>
> The following bug has been logged online:
>
> Bug reference: =A0 =A0 =A04846
> Logged by: =A0 =A0 =A0 =A0 =A0Anders Gunnarsson
> Email address: =A0 =A0 =A0fsogren@passagen.se
> PostgreSQL version: newest
> Operating system: =A0 Windows XP
> Description: =A0 =A0 =A0 =A0Error reading file: config
> Details:
>
> Problem running post-install step. Installation may not complete correctly
> Error reading file D:/Program/POSTGRESQL/8.4/data/postgresql.conf

Please uninstall, and remove that data directory (you may need to take
ownership of it first), and then try the updated installer build at
http://developer.pgadmin.org/~dpage/postgresql-8.4.0-1b2-windows.exe

Regards, Dave

--=20
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com

On Wed, Jun 10, 2009 at 9:58 AM, Anders Gunnarsson<fsogren@passagen.se> wrote:
> Very fast support!
>
> I managed to install it but when I tried to start the program (Holdem
> Manager) which uses PostgreSQL it says: "new encoding (SQL_ASCII) is
> incompatible with the encoding of the template database (UTF8)
>
> I tried two times, both with "install template" and without, same result
>
> Do you know how to solve this :(

The first thing to do is to complain to your software vendor for
requiring SQL_ASCII - that's an encoding option that basically means
'I don't care about the encoding of my data, just store any old
garbage'.

PostgreSQL has got pretty strict recently about enforcing encoding
compatibility. If you need to create an SQL_ASCII database from a
UTF-8 cluster, you'll need to use template0 as the template database,
eg:

CREATE DATABASE mydb TEMPLATE template0;

You can also do that in pgAdmin, by selecting template0 as the
template in the create database dialog.

I should also point out that you've downloaded a beta version of
PostgreSQL, which is not guaranteed to be stable, nor will it
necessarily be possible to upgrade to later releases. For production
use, you should use PostgreSQL 8.8.7 which is the current stable
release.

--
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com

On Wed, Jun 10, 2009 at 10:46 AM, Anders Gunnarsson<fsogren@passagen.se> wrote:
> Is It possible to change to template0 on the existing DB?
> Created a new one in pgAdmin with template0, both the old postgres-db and
> this new one got red X on themself in "pgadmin", and the program saw this
> new DB as unknown and whouldnt accept it
> How do I get rid of the red X-mark on one of the db?

That just means you're not yet connected to that database. Just
double-click it to connect.

> And "CREATE DATABASE mydb TEMPLATE template0; ", where do I write that?
> (have to try this method too)

You can do that either in the psql command line, or the pgAdmin query
tool. But if you're in pgAdmin anyway, it's much easier to just
right-click Databases in the treeview, and select the New Database
option.

--
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com