Thread:
Hi I am trying to migrate the database and its tables from mysql in my windows machine to postgresql in my new red hat linux . I was following your links which has converstions from msaccess,mysql to postgresql and in the process I have downloaded pgadmin 11 and i got the wizard. It says to connect to target server. now what is that I need to write in that target server? the field in the connect wizard are 1. server 2.port 3.username 4.password I have mysql control center in which I have some databases which I want to transfer to postgresql . is this pgadmin2 wizard will connect to the mysql server? what port number should I give and I have some usernames and passwords in the mysql database. shall I type those username and password. Kindly let me know I actually thought of installing postgresql in windows also and once I get the tables migrated from mysql to postgresql in the same machine.. then I will burn it to cd and then thought of copying them to postgresql present in red hat linux which is in different machine. actually both these machines are connected to the same LAN. but I dont know if there exists any way to direct dump the mysql tables in windows machine to postgresql in linux machine.. do let me know.... i am stuckup here. thankyou very much prashanthi
----Message d'origine---- >Date: Fri, 7 May 2004 15:49:00 +0300 >De: ashish anand <ashish.anand@helsinki.fi> >A: pgadmin-support@postgresql.org >Sujet: [pgadmin-support] > >Hi, > I'm trying to install pgAdmin3 on my mandrake 8.2 from source distribution >but unable to do that for last 1 week... > I followed the documentation thoroughly and installed wxWindows 2.5 cvs.. >Till here there was no problem. Then I try to install pgAdmin3. >"./configure" was successful w/o any problem but "make all" gave errror like >undefined reference for some files. how to overcome this problem.. >Any suggestion??:-( Hi, If you are trying to build the stable release and not a recent CVS checkout, please take a look at these pages: http://www.mail-archive.com/pgadmin-support@postgresql.org/msg02662.html http://archives.postgresql.org/pgadmin-support/2004-02/msg00087.php if you face the exact same problem, try to apply the patch you'll find their or consider using one of the latest snapshotsas configure problems were solved in the meanwhile. (Note that the patch mentioned in these pages is not a proper way to take care of the error you face, but it works.) Regards, Raphaël
Hi Raphel, Thanx for your suggestion. I followed the archieves and I'd the same problems. As I dont know how to combine patch with actual source files(may sound bit stupid, i didnt try to find out how), i downloaded the latest snapshots and tried to install. Everything happened as discussed in archieves (problem with "PQgetssl" etc) and I did as suggested there. Finally I was able to install the pgadmin3. But now when i try to run pgadmin3, it gives error "pgadmin3: error while loading shared libraries: libssl.so.0.9.7: cannot open shared object file: No such file or directory".... I've libssl.so.0.9.6 in /usr/lib....I tried to install openssl-0.9.7d(latest version of openssl) but again facing some problem.. Can you suggest something.. Thanx and Regards, Ashish Quoting blacknoz@club-internet.fr: > > > > ----Message d'origine---- > >Date: Fri, 7 May 2004 15:49:00 +0300 > >De: ashish anand <ashish.anand@helsinki.fi> > >A: pgadmin-support@postgresql.org > >Sujet: [pgadmin-support] > > > >Hi, > > I'm trying to install pgAdmin3 on my mandrake 8.2 from source > distribution > >but unable to do that for last 1 week... > > I followed the documentation thoroughly and installed wxWindows 2.5 > cvs.. > >Till here there was no problem. Then I try to install pgAdmin3. > >"./configure" was successful w/o any problem but "make all" gave errror > like > >undefined reference for some files. how to overcome this problem.. > >Any suggestion??:-( > > Hi, > > If you are trying to build the stable release and not a recent CVS > checkout, > please take a look at these pages: > http://www.mail-archive.com/pgadmin-support@postgresql.org/msg02662.html > > http://archives.postgresql.org/pgadmin-support/2004-02/msg00087.php > > if you face the exact same problem, try to apply the patch you'll find > their or consider using one of the latest snapshots as configure problems > were solved in the meanwhile. > (Note that the patch mentioned in these pages is not a proper way to take > care of the error you face, but it works.) > > Regards, > Raphaël > > -- Ashish Anand Visiting Student Androgen Receptor Laboratory Inst of Biomedicine/Physiology Biomedicum, Haartmaninkatu 8 P.O.Box 63, FIN-00014 Helsinki, Finland
Hi Raphael,Sorry for bothering the grp. I solved the problem of ssl but there is problem of another library. I guess there is some problem. I hope that will be solved. Thanx. Ashish Quoting ashish anand <ashish.anand@helsinki.fi>: > Hi Raphel, > Thanx for your suggestion. I followed the archieves and I'd the same > problems. > > As I dont know how to combine patch with actual source files(may sound > bit > stupid, i didnt try to find out how), i downloaded the latest snapshots > and > tried to install. Everything happened as discussed in archieves (problem > with "PQgetssl" etc) and I did as suggested there. Finally I was able to > install the pgadmin3. > > But now when i try to run pgadmin3, it gives error "pgadmin3: error > while > loading shared libraries: libssl.so.0.9.7: cannot open shared object > file: > No such file or directory".... > > I've libssl.so.0.9.6 in /usr/lib....I tried to install > openssl-0.9.7d(latest > version of openssl) but again facing some problem.. Can you suggest > something.. > > Thanx and Regards, > Ashish > > Quoting blacknoz@club-internet.fr: > > > > > > > > > ----Message d'origine---- > > >Date: Fri, 7 May 2004 15:49:00 +0300 > > >De: ashish anand <ashish.anand@helsinki.fi> > > >A: pgadmin-support@postgresql.org > > >Sujet: [pgadmin-support] > > > > > >Hi, > > > I'm trying to install pgAdmin3 on my mandrake 8.2 from source > > distribution > > >but unable to do that for last 1 week... > > > I followed the documentation thoroughly and installed wxWindows 2.5 > > cvs.. > > >Till here there was no problem. Then I try to install pgAdmin3. > > >"./configure" was successful w/o any problem but "make all" gave > errror > > like > > >undefined reference for some files. how to overcome this problem.. > > >Any suggestion??:-( > > > > Hi, > > > > If you are trying to build the stable release and not a recent CVS > > checkout, > > please take a look at these pages: > > > http://www.mail-archive.com/pgadmin-support@postgresql.org/msg02662.html > > > > http://archives.postgresql.org/pgadmin-support/2004-02/msg00087.php > > > > if you face the exact same problem, try to apply the patch you'll find > > their or consider using one of the latest snapshots as configure > problems > > were solved in the meanwhile. > > (Note that the patch mentioned in these pages is not a proper way to > take > > care of the error you face, but it works.) > > > > Regards, > > Raphaël > > > > > > > -- > Ashish Anand > Visiting Student > Androgen Receptor Laboratory > Inst of Biomedicine/Physiology > Biomedicum, Haartmaninkatu 8 > P.O.Box 63, FIN-00014 > Helsinki, Finland > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings > -- Ashish Anand Visiting Student Androgen Receptor Laboratory Inst of Biomedicine/Physiology Biomedicum, Haartmaninkatu 8 P.O.Box 63, FIN-00014 Helsinki, Finland
----Message d'origine---- >Date: Mon, 10 May 2004 14:12:00 +0300 >De: ashish anand <ashish.anand@helsinki.fi> >Copie à: blacknoz@club-internet.fr, pgadmin-support@postgresql.org >Sujet: Re: [pgadmin-support] > >Hi Raphael, > Sorry for bothering the grp. I solved the problem of ssl nice you got it :) > but there is >problem of another library. >I guess there is some problem. I hope that will be solved. what kind of problem ? Any chance we can give a hint ? Regards, Raphaël
> > > but there is > >problem of another library. > >I guess there is some problem. I hope that will be solved. > > what kind of problem ? Any chance we can give a hint ? sure.. the error msg is : "pgadmin3: error while loading shared libraries: libpangoxft-1.0.so.0: cannot open shared object file: No such file or directory" though i've installed pango. i guess again this is the version problem as in case of libssl.. but isnt these error should come during configure/make?? regards, ashish -- Ashish Anand Visiting Student Androgen Receptor Laboratory Inst of Biomedicine/Physiology Biomedicum, Haartmaninkatu 8 P.O.Box 63, FIN-00014 Helsinki, Finland
----Message d'origine---- >Date: Mon, 10 May 2004 14:43:18 +0300 >De: ashish anand <ashish.anand@helsinki.fi> >A: blacknoz@club-internet.fr >Copie à: pgadmin-support@postgresql.org >Sujet: Re: [pgadmin-support] > >> what kind of problem ? Any chance we can give a hint ? >sure.. >the error msg is : "pgadmin3: error while loading shared libraries: >libpangoxft-1.0.so.0: cannot open shared object file: No such file or >directory" though i've installed pango. > >i guess again this is the version problem as in case of libssl.. but isnt >these error should come during configure/make?? What is strange is that it means that it does not find the version used while you were building the software. Can you send the result of the following command: ldd `which pgadmin3` Did you find the place where you libpangoxft-1.0.so.0 is located ? Which piece of software, other than pgAdmin III and wxWid, did you rebuild by yourself ? Maybe you have some preload environment preventing the correct lib to come up at launch time. Thanks, Raphaël
Hi Ashish,
sorry for the delay...
ashish anand wrote:
>>What is strange is that it means that it does not find the version used
>>while you were building the software.
>>
>>Can you send the result of the following command:
>>ldd `which pgadmin3`
>>
>>
>
>I've attached the file.
>
>
The interesting part is this one:
/usr/bin/pgadmin3: /lib/libc.so.6: version `GLIBC_2.3' not found
(required by /usr/bin/pgadmin3)
/usr/bin/pgadmin3: /lib/libpthread.so.0: version `GLIBC_2.3.2' not found
(required by /usr/bin/pgadmin3)
libpangoxft-1.0.so.0 => not found
libpangoft2-1.0.so.0 => not found
libstdc++.so.5 => not found
Concerning the libpango* and libstdc++, just add to the LD_LIBRARY_PATH
env variable the path to where you installed them... Something like this
if you are using ksh or bash:
export
LD_LIBRARY_PATH=${LD_LIBRARY_PATH:-""}:/usr/local/mylibs/whereAreMyPangoLibs
What I really don't understand is that you seem to link to another glibc
thant the one distributed with MDK... Why ?
>>Did you find the place where you libpangoxft-1.0.so.0 is located ?
>>
>>
>
>seems i made some mistake during installation of pango or other dependency
>software as I didnot find libpangoxft-1.0.so.0 at the place where other
>libraries of pango is installed. I might have to rebuild pango...
>
>
or change your ld behaviour (LD_LIBRARY_PATH or /etc/ld.so.conf)
>>Which piece of software, other than pgAdmin III and wxWid, did you
>>rebuild by yourself ?
>>
>>
>glib-2.4.0, atk-1.6.0, gtk+- 2.2.4, pango-1.2.0, pkgconfig-0.15.0 .....
>
>
ok... a lot of stuff here...
> >Maybe you have some preload environment preventing the correct lib to
>> come up at launch time.
>
>
>i think u'r right..as i'm not an expert so might be my rebuild options for
>other softwares are somehow conflicting with already installed old
>versions...
>
yeah, I think all your problems come from here, but maybe your system or
at least part of it is too old to build pgA3, so you are right to go
this way if you can't upgrade the whole system.
>but ur suggestions are helping me very much in knowing the system
>better...
>
>
Fine, just trying to do my best, although I'm not an mdk expert.
Please CC to the list, some people are more involved in the MDK port
than I am and you will for sure get a better support from them.
Jean-Michel, can you help with this ? Did you try a build on MDK 8.2 ?
Regards,
Raphaël
Hi raphael,Due to other projects load for few days I wont be able to check the things
suggested by you. For the time being I satisfied myslef with phpPgAdmin. And
definitely will let you know when I reslove the problem.
Thanx a lot for support and suggestions.
Best regards,
ashish
Quoting Raphaël Enrici <blacknoz@club-internet.fr>:
> Hi Ashish,
> sorry for the delay...
>
> ashish anand wrote:
>
> >>What is strange is that it means that it does not find the version
> used
> >>while you were building the software.
> >>
> >>Can you send the result of the following command:
> >>ldd `which pgadmin3`
> >>
> >>
> >
> >I've attached the file.
> >
> >
> The interesting part is this one:
> /usr/bin/pgadmin3: /lib/libc.so.6: version `GLIBC_2.3' not found
> (required by /usr/bin/pgadmin3)
> /usr/bin/pgadmin3: /lib/libpthread.so.0: version `GLIBC_2.3.2' not found
>
> (required by /usr/bin/pgadmin3)
> libpangoxft-1.0.so.0 => not found
> libpangoft2-1.0.so.0 => not found
> libstdc++.so.5 => not found
>
> Concerning the libpango* and libstdc++, just add to the LD_LIBRARY_PATH
> env variable the path to where you installed them... Something like this
>
> if you are using ksh or bash:
> export
> LD_LIBRARY_PATH=${LD_LIBRARY_PATH:-""}:
/usr/local/mylibs/whereAreMyPangoLibs
>
> What I really don't understand is that you seem to link to another glibc
>
> thant the one distributed with MDK... Why ?
>
> >>Did you find the place where you libpangoxft-1.0.so.0 is located ?
> >>
> >>
> >
> >seems i made some mistake during installation of pango or other
> dependency
> >software as I didnot find libpangoxft-1.0.so.0 at the place where other
> >libraries of pango is installed. I might have to rebuild pango...
> >
> >
> or change your ld behaviour (LD_LIBRARY_PATH or /etc/ld.so.conf)
>
> >>Which piece of software, other than pgAdmin III and wxWid, did you
> >>rebuild by yourself ?
> >>
> >>
> >glib-2.4.0, atk-1.6.0, gtk+- 2.2.4, pango-1.2.0, pkgconfig-0.15.0 .....
>
> >
> >
> ok... a lot of stuff here...
>
> > >Maybe you have some preload environment preventing the correct lib to
> >> come up at launch time.
> >
> >
> >i think u'r right..as i'm not an expert so might be my rebuild options
> for
> >other softwares are somehow conflicting with already installed old
> >versions...
> >
> yeah, I think all your problems come from here, but maybe your system or
>
> at least part of it is too old to build pgA3, so you are right to go
> this way if you can't upgrade the whole system.
>
> >but ur suggestions are helping me very much in knowing the system
> >better...
> >
> >
> Fine, just trying to do my best, although I'm not an mdk expert.
>
> Please CC to the list, some people are more involved in the MDK port
> than I am and you will for sure get a better support from them.
> Jean-Michel, can you help with this ? Did you try a build on MDK 8.2 ?
>
> Regards,
> Raphaël
>
--
Ashish Anand
Visiting Student
Androgen Receptor Laboratory
Inst of Biomedicine/Physiology
Biomedicum, Haartmaninkatu 8
P.O.Box 63, FIN-00014
Helsinki, Finland
> -----Original Message----- > From: pgadmin-support-owner@postgresql.org > [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of > Cristinel Angheluta > Sent: 30 October 2005 08:28 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] > > > Hi, > > It seems that I'm unable to create foreign keys if one of the table > belongs to another schema than public. > I've used pgadmin3 1.4.0b3 & pgAdmin3 1.2.2. Hi, Works OK for me in RC1. What exactly happens - do you get an error message? Regards, Dave
> -----Original Message----- > From: Cristinel Angheluta [mailto:acristi@mymail.ro] > Sent: 04 November 2005 10:30 > To: Dave Page > Subject: Re: [pgadmin-support] > > > No I didn't get an error message. > On "New Foreign key" dialog I'm not able to see any of the > referencing > table's fields( bottom most combobox on "Colums" tab). That's > why I told > you I'unable to create foreign keys. > On "Properties" tab -> "References" combobox, all tables > (except publics' > ones) don't have as prefix the schema name (ex. schema2.table2). Hmm, sorry - I still can't reproduce this or any other problems when creating fkeys from either the table dialogue or when directly using the foreign key dialogue. Andreas (or anyone else) can you reproduce this, or think of any cisrcumstances in which it might happen? > One more thing that I discovered in 1.4.0 RC1 is that > creation of a third > schema helped me to solve this issue. Even if you delete/drop > the third > schema "New Foreign key" dialog works properly after that. Hmm, I wonder if this is a refresh thing - you didn't create the referenced table through the SQL dialogue, so it's not actually found until the tree is refreshed perhaps? Regards, Dave.
Dave Page wrote: > > > >>-----Original Message----- >>From: Cristinel Angheluta [mailto:acristi@mymail.ro] >>Sent: 04 November 2005 10:30 >>To: Dave Page >>Subject: Re: [pgadmin-support] >> >> >>No I didn't get an error message. >>On "New Foreign key" dialog I'm not able to see any of the >>referencing >>table's fields( bottom most combobox on "Colums" tab). That's >>why I told >>you I'unable to create foreign keys. >>On "Properties" tab -> "References" combobox, all tables >>(except publics' >>ones) don't have as prefix the schema name (ex. schema2.table2). > > > Hmm, sorry - I still can't reproduce this or any other problems when > creating fkeys from either the table dialogue or when directly using the > foreign key dialogue. > > Andreas (or anyone else) can you reproduce this, No or think of any > cisrcumstances in which it might happen? No, except for user issues. Regards, Andreas