Re: [ADMIN] Postgres User Can Login without a password

2008-07-31 Thread Scott Marlowe
On Thu, Jul 31, 2008 at 1:08 PM, Rafael Domiciano <[EMAIL PROTECTED]> wrote: > Hi there, > > I have a situation that is a bit strange. > I discovered today that I can login in programs like EMS SQL Manager and in > the internal software (via ODBC) without using the password for the user. > > Exampl

[ADMIN] Postgres User Can Login without a password

2008-07-31 Thread Rafael Domiciano
Hi there, I have a situation that is a bit strange. I discovered today that I can login in programs like EMS SQL Manager and in the internal software (via ODBC) without using the password for the user. Example: Configuration on the ODBC: datasource: postgres database: Postgres server: "IP" user:

Re: [ADMIN] restore balloons db size

2008-07-31 Thread Tom Lane
Marc Fromm <[EMAIL PROTECTED]> writes: > Does anyone have some insight on why the db size is expanding with each > restore? > If I restore all the postgresql databases from pg_dumpall and use the -c to > drop databases before restoring them the size of the base directory > dramatically increases

[ADMIN] restore balloons db size

2008-07-31 Thread Marc Fromm
Does anyone have some insight on why the db size is expanding with each restore? If I restore all the postgresql databases from pg_dumpall and use the -c to drop databases before restoring them the size of the base directory dramatically increases with each restore (193MB to 355MB to 624MB). If

Re: [ADMIN] pgAdmin III

2008-07-31 Thread Johann Spies
On Thu, Jul 31, 2008 at 06:02:05AM -0500, Jim Toth wrote: > Not explicitly, are there separate installs for those? > Yes Regards Johann -- Johann Spies Telefoon: 021-808 4036 Informasietegnologie, Universiteit van Stellenbosch "Have not I commanded thee? Be strong and of a good

Re: [ADMIN] pgAdmin III

2008-07-31 Thread Jim Toth
Not explicitly, are there separate installs for those? On Thu, Jul 31, 2008 at 2:19 AM, Johann Spies <[EMAIL PROTECTED]> wrote: > On Wed, Jul 30, 2008 at 09:15:38PM -0500, Jim Toth wrote: > > I've installed PostgreSql 8.3 on Ubuntu 8.04. When I click on the > pgAdmin III > > link, nothing happen

Re: [ADMIN] pgAdmin III

2008-07-31 Thread Johann Spies
On Wed, Jul 30, 2008 at 09:15:38PM -0500, Jim Toth wrote: > I've installed PostgreSql 8.3 on Ubuntu 8.04. When I click on the pgAdmin III > link, nothing happens. I'm a newbie here, any help would be appreciated... Did you install pgadmin3 and pgadmin3-data also? Regards Johann -- Johann Spie