Well, I see a problem ... db4 is my slave target, db2 is the live
database, db3 is the master I am using to test with first - restored
backup from db2 ...
db3 appears to be defaulting to UTF8 not SQL_ASCII like the other two servers.
I realize this is not a slony issue, but can anyone point me towards
where this is set, and how it may be changed?
<snippy>
[EMAIL PROTECTED]:~/proj/slony/footest]$ psql -l <- this is a.k.a db3 "test
master"
List of databases
Name | Owner | Encoding
--------------+------------+-----------
archive | postgres | SQL_ASCII
asterisk | asterisk | SQL_ASCII
cdr | davep | SQL_ASCII
davep | davep | SQL_ASCII
foo | davep | SQL_ASCII
foo_save | davep | SQL_ASCII
pgbench | postmaster | SQL_ASCII
pgbenchslave | postmaster | SQL_ASCII
postgres | postgres | SQL_ASCII
showbill | davep | SQL_ASCII
showbill_bak | davep | SQL_ASCII
template0 | postgres | SQL_ASCII
template1 | postgres | SQL_ASCII
trac | postgres | SQL_ASCII
voip | postgres | SQL_ASCII
(15 rows)
[EMAIL PROTECTED]:~/proj/slony/footest]$ psql -h db2 -l <-- db2 is the live
data ...
List of databases
Name | Owner | Encoding
--------------+----------+-----------
asterisk | postgres | SQL_ASCII
davep | root | SQL_ASCII
foo | postgres | SQL_ASCII
pgbench | slony | SQL_ASCII
pgbenchslave | slony | SQL_ASCII
postgres | postgres | SQL_ASCII
root | root | SQL_ASCII
template0 | postgres | SQL_ASCII
template1 | postgres | SQL_ASCII
trac | postgres | SQL_ASCII
(10 rows)
[EMAIL PROTECTED]:~/proj/slony/footest]$ psql -h db4 -l <-- db4 is the slave
target
List of databases
Name | Owner | Encoding
-----------+------------+----------
archive | davep | UTF8
cdr | davep | UTF8
davep | postmaster | UTF8
foo | davep | UTF8
pgsql | davep | UTF8
postgres | postmaster | UTF8
root | postmaster | UTF8
template0 | postmaster | UTF8
template1 | postmaster | UTF8
(9 rows)
[EMAIL PROTECTED]:~/proj/slony/footest]$
</snippy>
On 1/12/07, Dun <[EMAIL PROTECTED]> wrote:
> Dave Price wrote:
> > I used the slony scrip / pg_dump to copy the structure - does that
> > mean that the encoding is the same, or is it possible that the two
> > databases have a different defaul, and I need to override it?
> >
> > I am not a psql server configuration whiz, so I do not know how to
> > check this 'definitively'
> >
> > aloha,
> > dave
> >
>
> pg_dump has no effect on the encoding of the database, which is decided
> at the time of creation. psql -l will give you a list of databases and
> their encodings.
>
> Regards,
>
> MP
>
--
aloha,
dave
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
