Re: [ADMIN] restore database from bare files

2005-07-01 Thread jehan procaccia
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

[ADMIN] encoding converting from ascii to unicode

2005-07-01 Thread Joel Fradkin
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

Re: [ADMIN] restore database from bare files

2005-07-01 Thread Ben Kim
>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

[ADMIN] replication for hot-standby?

2005-07-01 Thread Hannes Dorbath
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'

Re: [ADMIN] encoding converting from ascii to unicode (I got it

2005-07-01 Thread Joel Fradkin
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