Yes, seems so. I separated one of the tables having the problem and did
a test. First, loaded it with original file and saw the same: invalid
command then follows "out of memory". After I fixed those escape
characters, the table could be loaded successfully.
于 2011/8/30 10:14, Scott Marlowe 写道
2011/8/29 Rural Hunter :
> Hi all,
> I'm a newbie here. I'm trying to test pgsql with my mysql data. If the
> performance is good, I will migrate from mysql to pgsql.
> I installed pgsql 9.1rc on my Ubuntu server. I'm trying to import a large
> sql file dumped from mysql into pgsql with 'plsql -f'.
Thank you. I didn't understand what 'vacuum freeze' actually does. I
will check the detail to see if it's good for my situation. and I will
also test the load by tcp connection. Thanks again for all your advices
and they are really very helpful to me!
于 2011/8/30 0:06, Kevin Grittner 写道:
Rura
Thanks for your post. Sometimes i apply small changes to live
database. your accident warns me that recovery from backup is long and
not happy.
--
pasman
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.or
Rural Hunter wrote:
> 2011/8/29 23:18, Kevin Grittner:
>> I also recommend a VACUUM FREEZE ANALYZE on the database unless
>> most of these rows will be deleted or updated before you run a
>> billion database transactions. Otherwise you will get a painful
>> "anti-wraparound" autovacuum on everyt
Hi Kevin,
Thank you very much for the quick and detailed answers/suggestions. I
will check and try them.
于 2011/8/29 23:18, Kevin Grittner 写道:
Good (but don't forget to change that once the bulk load is done). You
should probably also turn off full_page_writes and synchronous_commit.
I've se
Rural Hunter wrote:
> yes, the size of my database(around 200g) is very close to yours.
> How long did it take you to migrate the data(100-200G)?
I don't remember off-hand, and I'm not sure it's worth digging for
the info because so much has changed in the intervening six years.
Recent Postgre
yes, the size of my database(around 200g) is very close to yours. How
long did it take you to migrate the data(100-200G)? I thought about to
write java code to transfer the data but it's a bit trivial. It would be
the best if I can complete this with regular export/import way. if that
won't wor
Rural Hunter wrote:
> it's a problem of migrating vast data from mysql to pgsql.
I don't know how helpful you'll find this, but when we migrated to
PostgreSQL a few years ago, we had good luck with using Java to
stream from one database to another. Be sure to include a lot of
inserts in each
well, thank you for the quick reply but actually I'm not concerning the
performance as of now. My problem is related to the bulk insert of
client side program psql. Or, it's a problem of migrating vast data from
mysql to pgsql.
于2011年8月29日 21:25:29,Julio Leyva写到:
check this out
http://www.re
Hi all,
I'm a newbie here. I'm trying to test pgsql with my mysql data. If the
performance is good, I will migrate from mysql to pgsql.
I installed pgsql 9.1rc on my Ubuntu server. I'm trying to import a
large sql file dumped from mysql into pgsql with 'plsql -f'. The file is
around 30G with bu
Adarsh Sharma wrote:
> Today by mistake I issued a drop table statement in Postgresql
> database. Now is it possible to get that data back through WAL.
> archive_mode = on
> archive_command = ''
If you were doing Point In Time Recovery (PITR) backups, you could
restore your last base backup
On 29/08/2011 4:08 PM, Lukasz Brodziak wrote:
Hello,
When I try to install PostgreSQL 8.2.4 on Windows 7 HP 64-bit
'
8.2.(old) on Win7 x64? Why?
At least install the latest 8.2.x point-release, 8.2.21 . Here are all
the fixes you are missing by installing 8.2.4 instead:
http://www.postgres
Hello,
When I try to install PostgreSQL 8.2.4 on Windows 7 HP 64-bit I get the
error "Failed to load LIBEAY32.dll: 193. The installer will not be able to
determine if there is a conflicting version od OpenSSL installed.'
I know that this is a 32 bit dll but still can anyone please tell me where
t
14 matches
Mail list logo
