[ADMIN] [Fwd: how to determine storage size of a numeric column]

I did not see it come through. resent. --- Begin Message --- I'm running 7.3.4, and am trying to calculate the space requirements for my tables. However, I have several tables that have numeric columns, and am not sure how much space postgres is using for them. Does anyone know how to determi

Re: [ADMIN] Postgres database access problem

On Tue, Jan 25, 2005 at 11:46:54AM +0530, Inpreet Singh wrote: > I am using postgres 7.3.4. I am trying to retrieve data from already > existing database. I am using postgres, which is super user of my > database in php.ini. But when I am trying to retrieve data following > error is coming > pg_c

Re: [ADMIN] Restore postgres database problem

On Tue, Jan 25, 2005 at 10:26:25AM +0530, Inpreet Singh wrote: > > I am using postgres 7.3.4. I am trying to restore database dump using > psql command but getting following error. > > Taken Dump : /usr/bin/pg_dumpall > /home/inpreet/postgres.sql > Restoring Dump : su - postgres > /usr/local

[ADMIN] Postgres database access problem

Hello,   I am using postgres 7.3.4. I am trying to retrieve data from already existing database. I am using postgres, which is super user of my database in php.ini. But when I am trying to retrieve data following error is coming pg_class_aclcheck: invalid user id 100   please help me in rec

[ADMIN] Restore postgres database problem

Hello, I am using postgres 7.3.4. I am trying to restore database dump using psql command but getting following error.   Taken Dump :   /usr/bin/pg_dumpall > /home/inpreet/postgres.sql Restoring Dump :   su - postgres /usr/local/pgsql/bin/psql -d template1 < /home/inpreet/postgres.sql   b

[ADMIN] SSL connection

Hi all, I'm using PostgreSQL 7.4.6-6 from Debian Sarge. I'm trying to start server with SSL enabled, but I'm getting this error on my log: FATAL: could not load server certificate file "/var/lib/postgres/data/server.crt": no start line I'm already using this certificate on a apache web server f