[ADMIN] Expectations of MEM requirements for a DB with large tables.

2000-11-03 Thread Michael Miyabara-McCaskey
Hello PostgreSQL demi-gods... I am new to the PostgreSQL world, as well as the Linux world... kind of a double whammy... Anyway, I crashed my system the other day when I did a "select *" from one of my large tables (about 5.5gb in size). Now this is not something that will normally happen, as I

Re: [ADMIN] Consulta

2000-11-03 Thread Rodrigo Fernandez
> HOla a todos, quisiera remitirles una par de consultas > 1. Como realizo una funcion que me retorne una > consulta o tablas temporales Podes usar \"select into\", para mas info mira esta pagina: http://www.postgresql.org/users-lounge/docs/7.0/user/sql-selectinto.htm Rodrigo F. --

[ADMIN] problem creating database

2000-11-03 Thread matthew . copeland
I'm using postgresql 7.0.2 compiled from the source. I seem to have things up and working, but I am getting the problem shown below. I can psql into another database, if I use a different name, and on another system I can create a database with the name product. I even tried dropping it and re

Re: [ADMIN] Starting postmaster problem

2000-11-03 Thread Nataraj
run "su - postgres" Then it will export the env variables (which you set in the .bash_profile file). If you do "su postgres" it may not export. Raj Bogdan Paduraru wrote: > Hello, > I installed Postgresql 7.0.2 on a Redhat Linux 6.1 and I want now to run > it, but it seems I have a problem. > I

[ADMIN] Consulta

2000-11-03 Thread Judith Elizabeth Trejo Alvarez
HOla a todos, quisiera remitirles una par de consultas 1. Como realizo una funcion que me retorne una consulta o tablas temporales _ Do You Yahoo!? Obtenga su dirección de correo-e gratis @yahoo.com en http://correo.espanol.yahoo.com