pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedMigration
6+ messages / 4 participants
[nested] [flat]
* Migration
@ 2006-02-10 08:38 James Dey <james@mygus.com>
0 siblings, 1 reply; 6+ messages in thread
From: James Dey @ 2006-02-10 08:38 UTC (permalink / raw)
To: pgsql-admin
Hi Everyone,
I'm a newbie to the list, and look forward to helping out where I can if
possible.
I have an issue which I've not been able to get around. I have a Postgresql
7.4 server with a number of databases:
Name | Owner | Encoding
------------+----------+----------
xxx45 | postgres | UNICODE
xxx30 | postgres | UNICODE
xxx30_copy | postgres | UNICODE
yyy30 | postgres | UNICODE
xxxxxxx | postgres | UNICODE
xxxx | postgres | UNICODE
I have installed PostgreSQL 8.1 onto a new box, and when trying to create a
new database, even when specifiying -encoding=UNICODE I cannot create
UNICODE dbs, it makes them all UTF-8.
Then when I try and restore a DB dump, but keep on getting invalid "UTF-8
byte sequence detected near byte xxx" and although the restore continues, a
lot of data is missing.
Does anyone have any suggestions here, I would really appreciate it!
Regards,
James Dey
tel +27 11 704-1945
cell +27 82 785-5102
fax +27 11 388-8907
mail <mailto:james@mygus.com> james@mygus.com
myGUS / SLT retains all its intellectual property rights in any information
contained in e-mail messages (or any attachments thereto) which relates to
the official business of myGUS / SLT or of any of its associates. Such
information may be legally privileged, is to be treated as confidential and
myGUS / SLT will take legal steps against any unauthorised use. myGUS / SLT
does not take any responsibility for, or endorses any information which does
not relate to its official business, including personal mail and/or opinions
by senders who may or may not be employed by myGUS / SLT. In the event that
you receive a message not intended for you, we request that you notify the
sender immediately, do not read, disclose or use the content in any way
whatsoever and destroy/delete the message immediately. While myGUS / SLT
will take reasonable precautions, it cannot ensure that this e-mail will be
free of errors, viruses, interception or interference therewith. myGUS / SLT
does not, therefore, issue any guarantees or warranties in this regard and
cannot be held liable for any loss or damages incurred by the recipient
which have been caused by any of the above-mentioned factors.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Migration
@ 2006-02-10 08:44 Devrim GUNDUZ <devrim@commandprompt.com>
parent: James Dey <james@mygus.com>
0 siblings, 1 reply; 6+ messages in thread
From: Devrim GUNDUZ @ 2006-02-10 08:44 UTC (permalink / raw)
To: James Dey <james@mygus.com>; +Cc: pgsql-admin
Hi,
On Fri, 2006-02-10 at 10:38 +0200, James Dey wrote:
> I have installed PostgreSQL 8.1 onto a new box, and when trying to
> create a new database, even when specifiying –encoding=UNICODE I
> cannot create UNICODE dbs, it makes them all UTF-8.
>
>
> Then when I try and restore a DB dump, but keep on getting invalid
> “UTF-8 byte sequence detected near byte xxx” and although the restore
> continues, a lot of data is missing.
http://developer.postgresql.org/docs/postgres/release-8-1.html
"Some users are having problems loading UTF-8 data into 8.1.X. This is
because previous versions allowed invalid UTF-8 byte sequences to be
entered into the database, and this release properly accepts only valid
UTF-8 sequences. One way to correct a dumpfile is to run the command
iconv -c -f UTF-8 -t UTF-8 -o cleanfile.sql dumpfile.sql. The -c option
removes invalid character sequences. A diff of the two files will show
the sequences that are invalid. iconv reads the entire input file into
memory so it might be necessary to use split to break up the dump into
multiple smaller files for processing."
Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Migration
@ 2006-02-10 08:50 James Dey <james@mygus.com>
parent: Devrim GUNDUZ <devrim@commandprompt.com>
0 siblings, 1 reply; 6+ messages in thread
From: James Dey @ 2006-02-10 08:50 UTC (permalink / raw)
To: 'Devrim GUNDUZ' <devrim@commandprompt.com>; +Cc: pgsql-admin
Thank you Devrim,
Am I correct in saying then that UTF-8 and UNICODE are the same thing as far
as PostgreSQL is concerned?
Best regards,
James Dey
tel +27 11 704-1945
cell +27 82 785-5102
fax +27 11 388-8907
mail james@mygus.com
-----Original Message-----
From: Devrim GUNDUZ [mailto:devrim@commandprompt.com]
Sent: 10 February 2006 10:45 AM
To: James Dey
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Migration
Hi,
On Fri, 2006-02-10 at 10:38 +0200, James Dey wrote:
> I have installed PostgreSQL 8.1 onto a new box, and when trying to
> create a new database, even when specifiying -encoding=UNICODE I
> cannot create UNICODE dbs, it makes them all UTF-8.
>
>
> Then when I try and restore a DB dump, but keep on getting invalid
> "UTF-8 byte sequence detected near byte xxx" and although the restore
> continues, a lot of data is missing.
http://developer.postgresql.org/docs/postgres/release-8-1.html
"Some users are having problems loading UTF-8 data into 8.1.X. This is
because previous versions allowed invalid UTF-8 byte sequences to be
entered into the database, and this release properly accepts only valid
UTF-8 sequences. One way to correct a dumpfile is to run the command
iconv -c -f UTF-8 -t UTF-8 -o cleanfile.sql dumpfile.sql. The -c option
removes invalid character sequences. A diff of the two files will show
the sequences that are invalid. iconv reads the entire input file into
memory so it might be necessary to use split to break up the dump into
multiple smaller files for processing."
Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Migration
@ 2006-02-10 08:58 Devrim GUNDUZ <devrim@commandprompt.com>
parent: James Dey <james@mygus.com>
0 siblings, 0 replies; 6+ messages in thread
From: Devrim GUNDUZ @ 2006-02-10 08:58 UTC (permalink / raw)
To: James Dey <james@mygus.com>; +Cc: pgsql-admin
Hi,
On Fri, 2006-02-10 at 10:50 +0200, James Dey wrote:
> Am I correct in saying then that UTF-8 and UNICODE are the same thing as far
> as PostgreSQL is concerned?
Yes:
template1=# CREATE DATABASE test1 ENCODING 'UNICODE';
CREATE DATABASE
template1=# CREATE DATABASE test2 ENCODING 'UTF-8';
CREATE DATABASE
template1=# \l
List of databases
Name | Owner | Encoding
-----------+----------+----------
...
test1 | postgres | UTF8
test2 | postgres | UTF8
Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/
^ permalink raw reply [nested|flat] 6+ messages in thread
* Migration
@ 2020-02-16 13:16 Krishna B <krishnasvkb@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Krishna B @ 2020-02-16 13:16 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Hi All
Could you please help me to get complete step by step document for
migration from Oracle to aws RDS or EC2 enterprise dB
Thank you
--
Thanks
Krishna.B
469 345 5246
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Migration
@ 2020-02-16 13:22 Rahul Saha <rahul.blooming@gmail.com>
parent: Krishna B <krishnasvkb@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Rahul Saha @ 2020-02-16 13:22 UTC (permalink / raw)
To: Krishna B <krishnasvkb@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Hi Krishna,
If you are want to migrate to RDS PG as target, go ahead with AWS DMS(
Database Migration Service)
Regards
Rahul
On Sun, 16 Feb 2020 at 6:46 PM, Krishna B <krishnasvkb@gmail.com> wrote:
> Hi All
>
> Could you please help me to get complete step by step document for
> migration from Oracle to aws RDS or EC2 enterprise dB
>
> Thank you
> --
> Thanks
> Krishna.B
> 469 345 5246
>
--
Thanks & Regards
Rahul Saha
+91 8806351116
Sent from my iPhone
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2020-02-16 13:22 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-02-10 08:38 Migration James Dey <james@mygus.com>
2006-02-10 08:44 ` Devrim GUNDUZ <devrim@commandprompt.com>
2006-02-10 08:50 ` James Dey <james@mygus.com>
2006-02-10 08:58 ` Devrim GUNDUZ <devrim@commandprompt.com>
2020-02-16 13:16 Migration Krishna B <krishnasvkb@gmail.com>
2020-02-16 13:22 ` Rahul Saha <rahul.blooming@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox