Re: [ADMIN] Database encoding

2008-09-04 Thread valgog
On Sep 3, 3:40 pm, [EMAIL PROTECTED] ("Anibal David Acosta") wrote: > Hello, I have a postgresql installed with encoding "WIN1252". > > But I need to create a DB with LATIN1 encoding, when I try I got the error: > "Encoding Latin1 does not match server's locale Spanish_Spain.1252. The > servers's L

[ADMIN] Database Conversion

2008-09-04 Thread Carol Walter
Hello, All, I have a new faculty member who has a large database that is in MySQL. We don't support MySQL so the database needs to be ported to PostgreSQL. Her GA, who know MySQL, says that he has a query that he will run that will put the data into postgres. I thought that the data wo

Re: [ADMIN] Database Conversion

2008-09-04 Thread Achilleas Mantzios
Στις Thursday 04 September 2008 16:24:34 ο/η Carol Walter έγραψε: > Hello, All, > > I have a new faculty member who has a large database that is in > MySQL. We don't support MySQL so the database needs to be ported to > PostgreSQL. Her GA, who know MySQL, says that he has a query that he >

Re: [ADMIN] Database Conversion

2008-09-04 Thread Achilleas Mantzios
Στις Thursday 04 September 2008 16:24:34 ο/η Carol Walter έγραψε: > Hello, All, > > I have a new faculty member who has a large database that is in > MySQL. We don't support MySQL so the database needs to be ported to > PostgreSQL. Her GA, who know MySQL, says that he has a query that he >

Re: [ADMIN] pg_dump etc. versions

2008-09-04 Thread Peter Eisentraut
Jan-Peter Seifert wrote: I'm wondering if there's a compatibility list of the tools supplied with PostgreSQL - e.g. psql seems to be very server version specific (only major or also minor versions?). For pg_dump I'd say users should use the version of the target server if it's already installe

Re: [ADMIN] server/db encoding (mix) issues

2008-09-04 Thread Peter Eisentraut
Jan-Peter Seifert wrote: we have a mix of older software still using LATIN1 as db encoding and the psqlODBC-drivers (ANSI) and newer software using UTF8 as db encoding. As running two server instances would use up more resources(?) than just one we'd like to have all dbs in one cluster. Which

Re: [ADMIN] Database Conversion

2008-09-04 Thread Ben Kim
I have a new faculty member who has a large database that is in MySQL. We don't support MySQL so the database needs to be ported to PostgreSQL. Her GA, who know MySQL, says that he has a query that he will run that will put the data into postgres. I thought that the data would have to be outp

Re: [ADMIN] Database Conversion

2008-09-04 Thread Carol Walter
Well, my database server lives on a Solaris 10 box. I'm running PosgreSQL 8.2.3. The database that is being converted from MySQL is currently on a Windows machine. So far it seems that every solution involves an interim step or two. I think he was alluding to just running a query. Car

Re: [ADMIN] Database Conversion

2008-09-04 Thread Hajek, Nick
> > Hello, All, > > I have a new faculty member who has a large database that is > in MySQL. We don't support MySQL so the database needs to be > ported to PostgreSQL. Her GA, who know MySQL, says that he > has a query that he will run that will put the data into > postgres. I thought tha

[ADMIN] Help!

2008-09-04 Thread Christian Larsen
Hi! I have bought a WS 444 PC Weather Station.In order to use the device, a software called WeatherProfessional wasincluded in the package.That software uses the postgresql service. I also got the PostgreSQL 8.0with the package. My problem is that I cannot get it to work properly.Firstly, if I

Re: [ADMIN] Help!

2008-09-04 Thread Scott Marlowe
On Thu, Sep 4, 2008 at 10:06 AM, Christian Larsen <[EMAIL PROTECTED]> wrote: > Hi! I have bought a WS 444 PC Weather Station. > In order to use the device, a software called WeatherProfessional was > included in the package. > That software uses the postgresql service. I also got the PostgreSQL 8.

Re: [ADMIN] Database Conversion

2008-09-04 Thread Scott Marlowe
On Thu, Sep 4, 2008 at 9:22 AM, Hajek, Nick <[EMAIL PROTECTED]> wrote: > >> >> Hello, All, >> >> I have a new faculty member who has a large database that is >> in MySQL. We don't support MySQL so the database needs to be >> ported to PostgreSQL. Her GA, who know MySQL, says that he >> has a quer

Re: [ADMIN] Database Conversion

2008-09-04 Thread Carol Walter
According to the GA, the database has 1,000,000 rows. I hesitate to pass that along because I don't know what that means. It strikes me as an odd way to talk about a relational database. Normally, a relational database has more than one table, so how is a "database" having a million rows

Re: [ADMIN] Database Conversion

2008-09-04 Thread H. Hall
Carol Walter wrote: Hello, All, I have a new faculty member who has a large database that is in MySQL. We don't support MySQL so the database needs to be ported to PostgreSQL. Her GA, who know MySQL, says that he has a query that he will run that will put the data into postgres. I thought

Re: [ADMIN] Database Conversion

2008-09-04 Thread Carol Walter
That's a good idea. I think I'll try that. Carol On Sep 4, 2008, at 1:18 PM, H. Hall wrote: Carol Walter wrote: Hello, All, I have a new faculty member who has a large database that is in MySQL. We don't support MySQL so the database needs to be ported to PostgreSQL. Her GA, who know

Re: [ADMIN] Database Conversion

2008-09-04 Thread Alan Scott
What version of Postgres? We have 8.3 and have been using Migration Studio from Enterprise DB (which is part of the Advanced Server install). Also, with MySQL 5.0 and above they have some conversion tools that do come with the install to assist you. On Thu, Sep 4, 2008 at 9:24 AM, Carol Walter <[E

Re: [ADMIN] Database Conversion

2008-09-04 Thread Steve Holdoway
On Thu, 4 Sep 2008 09:24:34 -0400 Carol Walter <[EMAIL PROTECTED]> wrote: > Hello, All, > > I have a new faculty member who has a large database that is in > MySQL. We don't support MySQL so the database needs to be ported to > PostgreSQL. Her GA, who know MySQL, says that he has a query th

Re: [ADMIN] Database Conversion

2008-09-04 Thread Carol Walter
I'm using 8.2.3. I don't know which version of MySQL the faculty member has her database in. I really appreciate all the helpful suggestions. This seems like a very interesting topic. Carol On Sep 4, 2008, at 3:42 PM, Alan Scott wrote: What version of Postgres? We have 8.3 and have been

Re: [ADMIN] rpm install not recognized by yum.

2008-09-04 Thread slamp slamp
anyone? i am able to install others apps like ptop from the repo. just cant update the installed ones. On Wed, Sep 3, 2008 at 11:24 AM, slamp slamp <[EMAIL PROTECTED]> wrote: > one of our servers had the pgdg rpms (8.2.4) installed by hand. now > that the yum repo is available, i installed > pgdg-

Re: [ADMIN] rpm install not recognized by yum.

2008-09-04 Thread slamp slamp
ok i managed to get this to work. however i still get the "Repository pgdg82 is listed more than once in the configuration", this is probably a rhel yum bug. On Thu, Sep 4, 2008 at 4:12 PM, slamp slamp <[EMAIL PROTECTED]> wrote: > anyone? i am able to install others apps like ptop from the repo. j

Re: [ADMIN] rpm install not recognized by yum.

2008-09-04 Thread Scott Marlowe
On Thu, Sep 4, 2008 at 2:42 PM, slamp slamp <[EMAIL PROTECTED]> wrote: > ok i managed to get this to work. however i still get the "Repository > pgdg82 is listed more than once in the configuration", this is > probably a rhel yum bug. Sure you don't have it again in an included yum .conf file? Th

Re: [ADMIN] Database Conversion

2008-09-04 Thread Scott Marlowe
Also you should really look into updating your pg install to 8.2.9. It takes only seconds / minutes to do. Release notes: http://www.postgresql.org/docs/8.2/static/release-8-2-4.html http://www.postgresql.org/docs/8.2/static/release-8-2-5.html http://www.postgresql.org/docs/8.2/static/release-8-2

Re: [ADMIN] SSL problems

2008-09-04 Thread Andriy Bakay
After I disable SSL option in postgresql.conf the server is starting successfully. Please, advise. Jan-Peter Seifert wrote: Hello Andriy, the reply-to settings are a bit uncomfortable here. Your mail went only to me. But I'm not part of the developer or support team. It's strange that pg_ctl

[ADMIN] user roles where are they stored

2008-09-04 Thread oca
hi, we are newto pg, one of our developers is asking how we can tap the user roles of pg.  what table to look at?  we have a functionality requirement that an application will behave according to his roles? thank you, oca