Ben Kim wrote:
ezpublish_db-# ALTER USER ezpublish SET PASSWORD secret;
ERROR: syntax error at or near "$" at character 1
I wonder why you have "ezpublish_db-#" instead of "ezpublish_db=#"? I just
noticed it, and to me it happens usually when something's been carried
over from the previ
I have been trying to get unicode to work for us (we moved
from MSSQL and had to initially use ascii because it would blow up writing the French
chars when I built my data base).
I have a .net app that reads my tables and does insert
statements into a Unicode database.
The actual conve
>psql: FATAL: IDENT authentication failed for user "ezpublish"
This might help, or you may want to check or post your pg_hba.conf.
http://archives.postgresql.org/pgsql-sql/2004-03/msg00202.php
(or
http://www.postgresql.org/docs/7.4/interactive/auth-methods.html#AUTH-IDENT)
HTH,
Ben Kim / Dev
I need something that is able to replicate schema changes as well, so
Slony seems out of the game :/
pg_cluster?
mammoth postgresql?
db_mirror?
What to use for a hot-standby box?
Thanks in advance
---(end of broadcast)---
TIP 4: Don't 'kill -9'
I finally got it to work. I tested the unicode
database with the newer odbc drivers as well.
It is working ok as far asp pages now.
Dim ascii As Encoding = Encoding.ASCII
Dim [unicode] As Encoding = Encoding.Unicode
Dim unicodeBytes As Byte() = [unicode].GetBy