Re: [ADMIN] Restore postgres database problem

The command I use for dump is: pg_dump -Fc -h host name database name dump file For restore, I create the database first on pgsql, and then (on shell) I give the command: pg_restore -d database name dump file Luis Sousa Inpreet Singh wrote: *Taken Dump :* /usr/bin/pg_dumpall /home/inpreet

Re: [ADMIN] Restore postgres database problem

Which options did you use to dump data? And which options did you use to restore it? Please submit the command lines used. Luis Sousa Inpreet Singh wrote: 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

[ADMIN] SSL connection

for a long time without problems. Thanks in advance. Luis Sousa ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [ADMIN] [SQL] Database diagram

analyze is your friend Did you already tried dia? I never used it, but someone told me that imports data definition from PostgreSQL. You can try it. Luis Sousa smime.p7s Description: S/MIME Cryptographic Signature

Re: [ADMIN] Logrotate

Oliver Elphick wrote: On Wed, 2002-11-20 at 10:14, Luis Sousa wrote: Hi all, I'm running postgresql 7.2.1 on a debian 3.0 machine and I want to do some log rotation, but I'm having some problems. The configuration that I'm using is: In /etc/logrotate.d/postgres: /var/log/postgres.log

[ADMIN] Logrotate

anyway. pg_ctl: cannot start postmaster Examine the log output. Any sugestions !! What's wrong ? Regards, Luis Sousa smime.p7s Description: S/MIME Cryptographic Signature

Re: [ADMIN] Why my /var/log/pgsql is empy

= on log_timestamp = on syslog = 0 Luis Sousa ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

[ADMIN] View the value of the variables in the log !

turno,tipo,parte,indice FROM evento_v WHERE id_e = $1. How can I see the values that are passing in the queries, using log ? Thanks, Luis Sousa ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send

[ADMIN] Re: Operator *=

The script file that I was talking about can be found at /usr/lib/postgresql/share/contrib/array_iterator.sq Luis Sousa Luis Sousa wrote: Hello I know that exists a script file in postgres (I think) that have all of these operators. But what is the name of the file

[ADMIN] Operator *=

Hello I know that exists a script file in postgres (I think) that have all of these operators. But what is the name of the file ? Is it in the package of postgresql by defualt ? If not, can someone send me that file ? Thanks Luis Sousa ---(end of broadcast

[ADMIN] Rule ON DELETE, to perform to DELETE querys !

this Thanks Luis Sousa ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[ADMIN] Listing rules !!!

How can i know which rules are activate in my database ?? I can see the tables with \d, the views with \dv and so on ..., but for the rules ??? Thanks Luis Sousa ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[ADMIN] Users logged !

Is it possible to see what users are logged into the database using version 7.1 ?? Luis Sousa ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[ADMIN] Re: Restore template1

What really does "initdb" ? It creates a new database system but is for use of the user that created her !!! Luis Sousa Ragnar Kjørstad wrote: On Mon, Dec 18, 2000 at 03:49:18PM +0000, Luis Sousa wrote: There's a way to backup template1 to restore it when happens a disaster

[ADMIN] Restore template1

There's a way to backup template1 to restore it when happens a disaster without installing again PostgreSQL ??? Regards -- Luis Sousa Tecnico Superior de Informatica Gabinete de Assessoria e Planeamento Universidade do Algarve

[ADMIN] Connected users !

I made a search in the list and i saw that this subject was already discussed but no one gave a response to the question. What i want to know is if it's possible to know what users are connected to the database or to postgres and how can i manage it ?? Thanks Luis Sousa