No title

Started by Ho Pek Lingover 24 years ago4 messagesdocs
Jump to latest
#1Ho Pek Ling
ASPLHo@ntu.edu.sg

Hi,

I have a few question regarding postgresql product.

1) I understand that downloading of the postgresql is free from the website.
So do you provide any technical support and how much you charge for the
support?

2) From the postgresql website, I had read up the Postgresql's Limitation.
It indicated that the "Performance may suffer when these values get
unusually large." You mean what kind of perfomance and what kind of values?
3) I had read an article comparing MySQL and PostgreSQL, indicating that
when postgresql migrate database from one machine to another, it will need
to dump the database and then "recreate" during migration. What do they mean
by the "recreate", it is manually creating the whole database again or there
will be a software automate the process for us? Or this article is not true
in the sense that there is no need to "recreate" anything?

Hope that you will be able to answer my queries as this information is
important for me in choosing the right database for my company.

Thanks and Regards,
Felice Ho Pek Ling

#2Rene Pijlman
rene@lab.applinet.nl
In reply to: Ho Pek Ling (#1)
Re:

On Wed, 31 Oct 2001 14:41:38 +0800, you wrote:

1) I understand that downloading of the postgresql is free from the website.
So do you provide any technical support and how much you charge for the
support?

PostgreSQL is a volunteer open source project. For commercial
support check out
http://www.postgresql.org/users-lounge/commercial-support.html

This mailing list is for discussing PostgreSQL documentation
with volunteer maintainers, its not intended for general user
questions. You can ask your other questions on
pgsql-general@postgresql.org ("This is a general discussion area
for users. Outside of compile, acceptance test and bug problems,
most new users who don't want to contribute to development or
documentation will probably only be interested in this mailing
list.")

Regards,
Ren� Pijlman <rene@lab.applinet.nl>

#3Bruce Momjian
bruce@momjian.us
In reply to: Rene Pijlman (#2)
Re: [BUGS] [tim@perdue.net: Re: mysql2pgsql tool]

I found many PostgreSQL-related export scripts listed at:

http://www.rot13.org/~dpavlin/sql.html

Can we add this to techdocs page?

On Fri, 12 Oct 2001 10:44:03 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us> wrote:

Oops, sorry, Thomas Lockhart has worked on the tool and perhaps he can
fix this. However, I have been trying to find someone who will analyze
each version and add the missing features from one into the other so we
can have one better version rather than two.

Looking at the code, my2pg.pl seems much more complete. Not sure if
mysql2pgsql does anything that my2pg.pl doesn't already do. Comments?

The last time I was looking at the mysql2pgsql code was long ago.
I cannot compare the 2 tools. The one thing I'm sure is that my tool needs extensive testing.
People send me various patches, however I often have no time to test it well.

I can give you a link to another similar tool: http://www.rot13.org/~dpavlin/projects.html. Called also mysql2pgsql.
The Author is Dobrica Pavlinius <dpavlin@rot13.org>. I didn't tested his tool, give it you for completeness.

Max Rudensky.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
#4Justin Clift
justin@postgresql.org
In reply to: Bruce Momjian (#3)
Re: [BUGS] [tim@perdue.net: Re: mysql2pgsql tool]

Hi Bruce,

It's already there, but with the URL
http://docman.sourceforge.net/home_html/sql.html

:-)

Regards and best wishes,

Justin Clift

Bruce Momjian wrote:

I found many PostgreSQL-related export scripts listed at:

http://www.rot13.org/~dpavlin/sql.html

Can we add this to techdocs page?

On Fri, 12 Oct 2001 10:44:03 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us> wrote:

Oops, sorry, Thomas Lockhart has worked on the tool and perhaps he can
fix this. However, I have been trying to find someone who will analyze
each version and add the missing features from one into the other so we
can have one better version rather than two.

Looking at the code, my2pg.pl seems much more complete. Not sure if
mysql2pgsql does anything that my2pg.pl doesn't already do. Comments?

The last time I was looking at the mysql2pgsql code was long ago.
I cannot compare the 2 tools. The one thing I'm sure is that my tool needs extensive testing.
People send me various patches, however I often have no time to test it well.

I can give you a link to another similar tool: http://www.rot13.org/~dpavlin/projects.html. Called also mysql2pgsql.
The Author is Dobrica Pavlinius <dpavlin@rot13.org>. I didn't tested his tool, give it you for completeness.

Max Rudensky.

--
Bruce Momjian                        |  http://candle.pha.pa.us
pgman@candle.pha.pa.us               |  (610) 853-3000
+  If your life is a hard drive,     |  830 Blythe Avenue
+  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi