Re: [pgadmin-support] Positioning the panes

2007-01-22 Thread Laurent Yaish
Hey Andy, It worked, thanks! Laurent On 1/22/07, Andy Shellam (Mailing Lists) <[EMAIL PROTECTED]> wrote: Hehe yep that's quite funny. You reminded me that's how I had mine setup in the 1.4 days (I thought something looked different!), so I had a go at re-doing, if you haven't worked it out: -

Re: [pgadmin-support] Positioning the panes

2007-01-22 Thread Andy Shellam (Mailing Lists)
Hehe yep that's quite funny. You reminded me that's how I had mine setup in the 1.4 days (I thought something looked different!), so I had a go at re-doing, if you haven't worked it out: - Drag the SQL pane out so it's "floating" - Drag the object explorer pane out so it's "floating", and you

Re: [pgadmin-support] Cannot connect to one specific postgres database

2007-01-22 Thread Andy Shellam (Mailing Lists)
Melvin Davidson wrote: Yes, you are correct, but you can have multiple _clusters_ with different ports, so there would a separate postmaster for each cluster on a server/machine with a different port. Yes, you can, but the way you've worded your response was that you have one postmaster p

[pgadmin-support] Positioning the panes

2007-01-22 Thread Laurent Yaish
Hi, I can't position the 3 windows panes in the main window like I'd like to. In 1.4.3 I had the object browser on the left ocuppying 1/3 width and 100% vertical. The other 2/3 are split vertically between the properties and the SQL pane. Try to drag the panes around and see if you can get them t

Re: [pgadmin-support] Cannot connect to one specific postgres database on a server

2007-01-22 Thread Melvin Davidson
Yes, you are correct, but you can have multiple _clusters_ with different ports, so there would a separate postmaster for each cluster on a server/machine with a different port. Keep in mind the port for the database was not specified in the original description so it s entirely possible the una

Re: [pgadmin-support] Cannot connect to one specific postgres database

2007-01-22 Thread Andy Shellam (Mailing Lists)
Melvin, Your understanding of how to set up a PostgreSQL server is wrong. One server process (it was called the postmaster up to 8.1, since 8.2 it's now called the Server process) can run any number of databases, you don't need multiple postmasters for multiple databases or your server is goin

Re: [pgadmin-support] Foreign Key selection / no public schema

2007-01-22 Thread Dave Page
Philipp Specht wrote: > Dave Page wrote: >> Philipp Specht wrote: >>> Hi! >>> >>> I hope you can tell me how to avoid the following problem: >>> >>> I'm using pgadmin 1.6.2 on MacOSX (same problem with 1.6.1) connecting >>> to a 8.2.0 database. >>> >>> I've renamed my public schema and created a ne

Re: [pgadmin-support] Slony-I on Windows

2007-01-22 Thread Hiroshi Saito
Hi. From: Ezequias Rodrigues da Rocha Nice, just two questions. I must install Slony-1 on master and on slave servers ? Two. How do I start it. Where is the instalation path ? Oh, Please refer to Robert-san page for usage.:-) See. http://people.planetpostgresql.org/xzilla/index.php?/archiv

Re: [pgadmin-support] Cannot connect to one specific postgres database on a server

2007-01-22 Thread Melvin Davidson
When you say "The site that is using the database is also running fine", Do you mean users are accessing that database? If so, that check the port # you are using to connect. You might also try adding a new server connection to that database in pgadmin. postmaster is the postgresql process that

Re: [pgadmin-support] Cannot connect to one specific postgres database

2007-01-22 Thread Hiroshi Saito
Hi. I am one idea. Please set up a log as the option of pgAdmin and acquire it. The information on it and the version to be used is required. we have to avoid hang/crash ..:-( Regards, Hiroshi Saito - Original Message - From: "Andy Shellam (Mailing Lists)" Can you connect to i

Re: [pgadmin-support] Cannot connect to one specific postgres database

2007-01-22 Thread Andy Shellam (Mailing Lists)
Can you connect to it OK using psql on the server's console? If you can, try dumping the database using pg_dump, then restore it as a different database and try connecting via PgAdmin to the new copy. Matt Busby wrote: Hello, I am having trouble connecting to one specific database on my ser

Re: [pgadmin-support] Cannot connect to one specific postgres database on a server

2007-01-22 Thread Melvin Davidson
I cannot tell you what is specificially wrong, but try the following: Can you telnet to that database and query? Is the postmaster running for that database? Do you get any errors returned when you try to connect via telnet? What are they? Is it possible your database is corrupted and you n

Re: [pgadmin-support] Slony-I on Windows

2007-01-22 Thread Hiroshi Saito
Hi. - Original Message - From: Ezequias Rodrigues da Rocha Hi list, It is possible to put slony to run on windows ? Yes, It can be used from Version 1.2. and it is included in pginstaller.:-) Furthermore, the independent thing is prepared also here. http://developer.pgadmin.org/~hi

[pgadmin-support] Cannot connect to one specific postgres database on a server

2007-01-22 Thread Matt Busby
Hello, I am having trouble connecting to one specific database on my server. I can connect to the server via pgadmin and have pgadmin display 7 or 8 databases I have running on the server. I can successfully connect to all of the databases except one. This particular database I am trying to connec

[pgadmin-support] Slony-I on Windows

2007-01-22 Thread Ezequias Rodrigues da Rocha
Hi list, It is possible to put slony to run on windows ? -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

[pgadmin-support] Cosmetic issue

2007-01-22 Thread Clodoaldo
When I place the mouse pointer over an internal border to drag it the pointer does not turn into a double arrow as it does when it is placed over an external border. Then when I click the internal border it turns into a double arrow. 1.6.2 Fedora Core 5 -- Clodoaldo Pinto Neto -

Re: [pgadmin-support] installing pgAdmin3 1.6.2 on FC6

2007-01-22 Thread Andy Shellam (Mailing Lists)
Willy-Bas Loos wrote: Ok thanks, guess i missed that one :x So after i upgraded wxWidgets, it says i need to upgrade to libpq.so.5. But i can't upgrade, because all kinds of software (i.e. postgresql-contrib) still depends on libpq.so.4 , because i'm running PostgreSQL 8.1.6 It's not necesarr

Re: [pgadmin-support] installing pgAdmin3 1.6.2 on FC6

2007-01-22 Thread Willy-Bas Loos
Ok thanks, guess i missed that one :x So after i upgraded wxWidgets, it says i need to upgrade to libpq.so.5. But i can't upgrade, because all kinds of software (i.e. postgresql-contrib) still depends on libpq.so.4 , because i'm running PostgreSQL 8.1.6 It's not necesarry to upgrade the backend f

Re: [pgadmin-support] Foreign Key selection / no public schema

2007-01-22 Thread Philipp Specht
Dave Page wrote: > Philipp Specht wrote: >> Hi! >> >> I hope you can tell me how to avoid the following problem: >> >> I'm using pgadmin 1.6.2 on MacOSX (same problem with 1.6.1) connecting >> to a 8.2.0 database. >> >> I've renamed my public schema and created a new schema. There's no >> 'public'

Re: [pgadmin-support] installing pgAdmin3 1.6.2 on FC6

2007-01-22 Thread Devrim GUNDUZ
Hi, On Mon, 2007-01-22 at 13:34 +0100, Willy-Bas Loos wrote: > Am i missing a repository where these can be found? I We don't have a yum repo for it; but there is an FTP repo: http://www.postgresql.org/ftp/pgadmin3/release/v1.6.2/fedora-core-6/ See the wx and rpm directories. Regards, -- The

[pgadmin-support] installing pgAdmin3 1.6.2 on FC6

2007-01-22 Thread Willy-Bas Loos
Hi, I am a novice FC6 user, and trying to upgrade pgAdmin3 from version 1.4.3(default) to 1.6.2 However, it seems yum doesn't find the libs that it depends on (e.g. wxWidgets 2.8, yum output below) Since you are offering binaries for FC6 i figure that i should't have to build the deps from source

Re: [pgadmin-support] Deleting a row leads to crash 1.6.2

2007-01-22 Thread Dave Page
Clodoaldo wrote: > As you suggested in the private email I loaded the db into a test db > and the crash was gone. Then I droped the original and reloaded the > dump to the original db name and now it works with no crash. Weird. At least it's working now. Regards, Dave ---

Re: [pgadmin-support] Deleting a row leads to crash 1.6.2

2007-01-22 Thread Clodoaldo
2007/1/19, Clodoaldo <[EMAIL PROTECTED]>: 2007/1/19, Clodoaldo <[EMAIL PROTECTED]>: > 2007/1/19, Dave Page <[EMAIL PROTECTED]>: > > Clodoaldo wrote: > > > 2007/1/18, Dave Page <[EMAIL PROTECTED]>: > > >> > > >> > > >> > --- Original Message --- > > >> > From: Laurent ROCHE <[EMAIL PROTECT

Re: [pgadmin-support] Foreign Key selection / no public schema

2007-01-22 Thread Dave Page
Philipp Specht wrote: > Hi! > > I hope you can tell me how to avoid the following problem: > > I'm using pgadmin 1.6.2 on MacOSX (same problem with 1.6.1) connecting > to a 8.2.0 database. > > I've renamed my public schema and created a new schema. There's no > 'public' schema any more. > > Now