postgresql enconding.

[SACHIN]

HI,


how can i set encoding for postgresql tables and database?



Thank you,

 

[MaX DiVeL]

you want add a new database in youre cpanel

or what?

 

[nrm]

Answer from cPanel support:


This isn't possible at this time. You would need to manually create the databases from the command line for users. There are already several feature requests in our bugzilla system for this functionality.

http://bugzilla.cpanel.net/show_bug.cgi?id=3632
http://bugzilla.cpanel.net/show_bug.cgi?id=3716
http://bugzilla.cpanel.net/show_bug.cgi?id=3958

Thank you.




--
Michael Photakis
Technical Support
cPanel

 

[casey]

su - postgres
psql template1 postgres
update pg_database set encoding = pg_char_to_encoding('NEWENCODING');

After this, from now on all databases will be created with the new encoding. This only works, of course, if you want all databases to be the same encoding.

 

[bryanabhay]

Hello,


But before doing this i am not able to

psql -U postgres -w

this command is not accepting the password

and hence i am unable to login as postgres user and do the other tasks ?

does anyone know why ?

~ Bryan