Change PostgreSql database encoding

Hello there ,
change PostgreSql database encoding

Rename database with old encoding

alter database test RENAME to test_old;

Create database with new encoding

CREATE DATABASE test ENCODING=’UTF-8′ LC_COLLATE = ‘tr_TR.UTF-8′ LC_CTYPE=’tr_TR.UTF-8’ TEMPLATE template0;

Set new database owner

alter database test OWNER to test_user;

 

 337 views last month,  2 views today

About tayfun inam

Computer Engineer -PostgreSql-Oracle Database Administrator I am about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 8+years experience.I have OCA,PostgreSql senior Certificates I have worked 50+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.

Leave a Reply