RE: [ADMIN] pg_sorttemp files

As soon as every postgres back-end server if closed, it is safe to delete these files. I do a... ps axf | grep -e "[P]ID" -e "[p]ost" ... to check for living back-ends... Nicolas Huillard -Message d'origine- De: brianb [SMTP:[EMAIL PROTECTED]] Date: mercredi 3 mai 2000 04:32 À:

Re: [ADMIN] pg_sorttemp files

Ok, thanks. But why are they there in the first place, then? Nicolas Huillard writes: As soon as every postgres back-end server if closed, it is safe to delete these files. I do a... ps axf | grep -e "[P]ID" -e "[p]ost" ... to check for living back-ends... Nicolas Huillard

Re: [ADMIN] pg_sorttemp files

On Wed, 3 May 2000, brianb wrote: Ok, thanks. But why are they there in the first place, then? A backend crash during sorting -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

RE: [ADMIN] pg_sorttemp files

These files are temporary files used by back-ends while sorting (as their names tell). They where probably forgotten when the back-end finished (either a died back-end or some sort or abnormal thing). The fact that these files are big can mean that the corresponding back-ends had problems with

[ADMIN] backup of my database...

how do i do backup of my databases in Postgresql. Must i terminate the postmaster process or is it possible make backup with my web site running and users conecteds ??? Thank's

Re: [ADMIN] Output from 'timestamp' column!?

You just need to cut this column. e.g. use perl you can use: new_column = substr(old_column, 0, 19) Or you can use the function to convert to what you want when you select this column from the table. Check functions -- Banghe Jack Zhu wrote: Hi, all: PostgreSQL 7 Beta 5 on Red hat Linux

Re: [ADMIN] database copy and move

You need to use pg_dump. pg_dump old_db_name > old.dump Then send old.dump to the machine you want, and use commands on that machine: createDB new_db_name cat old.dump | psql new_db_name Note: new_db_name can be the same as old_db_name here. -- Banghe Todd Turner wrote: Hello;

Re: [ADMIN] database copy and move

Thanks much for the quick info that's what I needed. tjt: Todd Turner [EMAIL PROTECTED] 801-585-1266 Center for High Performance Computing University of Utah On Wed, 3 May 2000, bangh

[ADMIN] Removing NOT NULL Contraint

I may be missing something simple here, but I have an attribute in a table that was created as NOT NULL. I now need to remove this constraint. I don't see a proper way to do this. I think I can update the pg_attribute table and change attnotnull from true to false. Is this an acceptable

[ADMIN] Investigación

Señores: Soy Joaquin Pardo y estoy investigando Postgres pero me encuentro con dificultades de que quiero utilizar delphi para windows y no puedo conectarme a la base de datos. Saludos muy atentamente. Joaquin Gentlemen: I am Brown