Thread: Long time when opening schema

Long time when opening schema

From

Masse Jacques

Date:

23 August 2002, 11:48:34

Hello,

After installing last version (1.3.76) from .msi, very long time for opening the list of tables (PG 7.1 on Slackware) when clicking for the first time on Schema-Public (about 3 min.)

Tried with 1.3.60 give the same result but not with the version I was using before (1.3.33)

Same delay with a very little database

Some idea ?

Thanks

Re: Long time when opening schema

From

"Dave Page"

Date:

23 August 2002, 11:56:23

-----Original Message-----
From: Masse Jacques [mailto:jacques.masse@bordeaux.cemagref.fr]
Sent: 23 August 2002 13:52
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] Long time when opening schema

Hello,

After installing last version (1.3.76) from .msi, very long time for opening the list of tables (PG 7.1 on Slackware) when clicking for the first time on Schema-Public (about 3 min.)
Tried with 1.3.60 give the same result but not with the version I was using before (1.3.33)
Same delay with a very little database

Some idea ?

Hi,

Make sure you have logging (Tools -> Options) switched to the lowest level possible - if it's on Full Debug, it will be *very* slow.

There are other mods in the later code that make clicking the schema seem slow. It's actually an illusion - a number of queries are now run at that point where previously they ran at different times. Unfortunately this is difficult to fix, without losing many of the new features and bug fixes.

Regards, Dave.

Re: Long time when opening schema

From

Masse Jacques

Date:

23 August 2002, 12:13:12

OK, it was full-debug with more than 20 Go written on the HD ...

Thanks for the quick answer and for this fine application

Regards

Jacques

VMWare connection

From

"Vikram Khurana"

Date:

23 August 2002, 18:48:17

Howdy,

I have RH 7.3 running on VMWare with W2k as the host. Postgres is
running on the Linux VMware. How do I connect to Postgres from the W2k
box. I tried the default connection with server=localhost, port =5432
and username=postgres with pwd blank, but no luck.

I'll appreciate it if someone can point me to some HOWTO's on the web. I
couldn't find any on the archive for this mailing list or on Google.

Thanks,
Vikram

Re: VMWare connection

From

"Krystian Brazulewicz"

Date:

23 August 2002, 19:54:32

Hello Vikram

When using VMWare, you've a fake network interface installed which is use
for communication between
your host and virtual machine.
Login on your 'virtual' RH7.3, go to the /etc/sysconfig/network-scripts, and
issue a command:

grep IPADDR ifcfg-eth?

then it should output a line formed like this:

ifcfg-eth0:IPADDR="XXX.XXX.XXX.XXX"

where XXX.XXX.XXX.XXX is an IP address you're looking for

Make sure that your pg_hba.conf allows to connect from your w2k box as user
postgres with no password! (postgresql documentation covers this area very
well)

hope this helps
Krystian Brazulewicz


> Howdy,
>
> I have RH 7.3 running on VMWare with W2k as the host. Postgres is
> running on the Linux VMware. How do I connect to Postgres from the W2k
> box. I tried the default connection with server=localhost, port =5432
> and username=postgres with pwd blank, but no luck.


>
> I'll appreciate it if someone can point me to some HOWTO's on the web. I
> couldn't find any on the archive for this mailing list or on Google.
>
> Thanks,
> Vikram
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
>

Re: VMWare connection

From

"Vikram Khurana"

Date:

23 August 2002, 20:29:49

I'm new to VMWare, Linux & Postgres. So pardon my newbie post.

grep IPADDR ifcfg-eth?

I didn't have a ifcfg-eth file so I did grep IPADDR ifcfg-eth0 in the
/etc/sysconfig/network-scripts directory but got back no result.

What does that mean?

I did do a ipconfig in W2k to find out my IP & tried to connect using
the IP for VMware. No luck with that either. Does Postgres's service run
on port 5432 by default?

I've tried changing the password for Postgres but it asks me for the
current passwd when I do that in Linux. As far as I could find it is
supposed to be empty, but when I just press enter at the current
password it errors it. Is there another default password for Postgres? I
did my install thro RPM's


-----Original Message-----
From: pgadmin-support-owner@postgresql.org
[mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Krystian
Brazulewicz
Sent: Friday, August 23, 2002 10:52 AM
To: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] VMWare connection

Hello Vikram

When using VMWare, you've a fake network interface installed which is
use
for communication between
your host and virtual machine.
Login on your 'virtual' RH7.3, go to the /etc/sysconfig/network-scripts,
and
issue a command:

grep IPADDR ifcfg-eth?

then it should output a line formed like this:

ifcfg-eth0:IPADDR="XXX.XXX.XXX.XXX"

where XXX.XXX.XXX.XXX is an IP address you're looking for

Make sure that your pg_hba.conf allows to connect from your w2k box as
user
postgres with no password! (postgresql documentation covers this area
very
well)

hope this helps
Krystian Brazulewicz


> Howdy,
>
> I have RH 7.3 running on VMWare with W2k as the host. Postgres is
> running on the Linux VMware. How do I connect to Postgres from the W2k
> box. I tried the default connection with server=localhost, port =5432
> and username=postgres with pwd blank, but no luck.


>
> I'll appreciate it if someone can point me to some HOWTO's on the web.
I
> couldn't find any on the archive for this mailing list or on Google.
>
> Thanks,
> Vikram
>
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
>


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Re: VMWare connection

From

"Krystian Brazulewicz"

Date:

24 August 2002, 06:24:47

Hello Vikram

> I'm new to VMWare, Linux & Postgres. So pardon my newbie post.
>
> grep IPADDR ifcfg-eth?
>
> I didn't have a ifcfg-eth file so I did grep IPADDR ifcfg-eth0 in the
> /etc/sysconfig/network-scripts directory but got back no result.
>

then login as root and try:

ifconfig

then send me the result of this command

> What does that mean?

That means that I've never set up Linux using VMWare (only W98) ;-)

>
> I did do a ipconfig in W2k to find out my IP & tried to connect using
> the IP for VMware. No luck with that either. Does Postgres's service run
> on port 5432 by default?

send me also result of ipconfig

>
> I've tried changing the password for Postgres but it asks me for the
> current passwd when I do that in Linux. As far as I could find it is
> supposed to be empty, but when I just press enter at the current
> password it errors it. Is there another default password for Postgres? I
> did my install thro RPM's

Did you intend to change password for Linux user postgres or PostgreSQL user
postgres?

>
>
> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Krystian
> Brazulewicz
> Sent: Friday, August 23, 2002 10:52 AM
> To: pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] VMWare connection
>
> Hello Vikram
>
> When using VMWare, you've a fake network interface installed which is
> use
> for communication between
> your host and virtual machine.
> Login on your 'virtual' RH7.3, go to the /etc/sysconfig/network-scripts,
> and
> issue a command:
>
> grep IPADDR ifcfg-eth?
>
> then it should output a line formed like this:
>
> ifcfg-eth0:IPADDR="XXX.XXX.XXX.XXX"
>
> where XXX.XXX.XXX.XXX is an IP address you're looking for
>
> Make sure that your pg_hba.conf allows to connect from your w2k box as
> user
> postgres with no password! (postgresql documentation covers this area
> very
> well)
>
> hope this helps
> Krystian Brazulewicz
>
>
> > Howdy,
> >
> > I have RH 7.3 running on VMWare with W2k as the host. Postgres is
> > running on the Linux VMware. How do I connect to Postgres from the W2k
> > box. I tried the default connection with server=localhost, port =5432
> > and username=postgres with pwd blank, but no luck.
>
>
> >
> > I'll appreciate it if someone can point me to some HOWTO's on the web.
> I
> > couldn't find any on the archive for this mailing list or on Google.
> >
> > Thanks,
> > Vikram
> >
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/users-lounge/docs/faq.html
> >
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

Re: VMWare connection

From

Jean-Michel POURE

Date:

25 August 2002, 13:24:21

Le Vendredi 23 Août 2002 21:49, Vikram Khurana a écrit :
> I'll appreciate it if someone can point me to some HOWTO's on the web. I
> couldn't find any on the archive for this mailing list or on Google.

You can read pgAdmin2 online help which includes PostgreSQL user manual.

Basically, you need to :

1) declare you client hosts in /var/lib/pgsql/data/pg_hba.conf
For example, to be sure to connect, add:
host    all     192.168.0.0     255.255.255.0       trust

2) enable "socket_connexion = true" in /var/lib/pgsql/data/postgresql.conf

3) Don't forget to restart PostgreSQL service typing
"service postgresql restart"

Cheers,
Jean-Michel

Re: VMWare connection

From

"Vikram Khurana"

Date:

26 August 2002, 19:37:07

I did the 1st and 3rd ones. I guess in step you are referring to
tcp_socket? I did enable that.
However still can't connect

BTW, I can connect to Postgre using pgaccess...

Anything else I should try.

THanks for your time,
Vikram

Jean-Michel POURE wrote:

>Le Vendredi 23 Août 2002 21:49, Vikram Khurana a écrit :
>
>>I'll appreciate it if someone can point me to some HOWTO's on the web. I
>>couldn't find any on the archive for this mailing list or on Google.
>>
>
>You can read pgAdmin2 online help which includes PostgreSQL user manual.
>
>Basically, you need to :
>
>1) declare you client hosts in /var/lib/pgsql/data/pg_hba.conf
>For example, to be sure to connect, add:
>host    all     192.168.0.0     255.255.255.0       trust
>
>2) enable "socket_connexion = true" in /var/lib/pgsql/data/postgresql.conf
>
>3) Don't forget to restart PostgreSQL service typing
>"service postgresql restart"
>
>Cheers,
>Jean-Michel
>
>