Re: [ADMIN] Parse the DF file to table

2007-04-22 Thread Andy Shellam
I think you need to provide more information on what you're trying to do, and the version of PostgreSQL you're using, which environment etc. If you're talking about reading a comma-delimited or tab-delimited text file, then see the COPY FROM command.

Re: [ADMIN] Checking a size of a given database

2007-04-22 Thread Robert Treat
On Tuesday 17 April 2007 07:39, Milen A. Radev wrote: Chuck Amadi написа: I have been given a task to try a proof of concept of migrating are active databases from PostgreSQL 8.0.1 to 8.2.3 I will install and configPostgreSQL on my local w/s and replicate the database users etc etc.

[ADMIN] PGcluster replicator from_host:0.0.0.0

2007-04-22 Thread Alexander
I use pgcluster-1.5.0rc16. OS: Debian Etch Linux 2.6.18-4-amd64 Servers: cluster-db-1.vm replicator-1.vm DNS info: # host cluster-db-1.vm cluster-db-1.vm A 192.168.0.91 # host replicator-1.vm replicator-1.vm A 192.168.0.93 # host 192.168.0.91 Name: cluster-db-1.vm

Re: [ADMIN] Return data from function

2007-04-22 Thread Robert Treat
On Tuesday 17 April 2007 15:17, Alexander B. wrote: Hello, I need to create a function that find data over 3 tables, merge and return data. With example can be specified more clearly: 1.1 Find all addresses code; 1.2 For each addresses code, get address, complement and city on the first

[ADMIN] Erro PostgreSQL

2007-04-22 Thread Carlos Zaffonatto
Prezados, Instalei o PostgreSQL 8.2 diversas vezes. Consigo utilizar somente se não reinicio o computador. Após reiniciar o pc quando tento conectar ele dá o erro: COULD NOT CONNECT SERVER: CONNECTION REFUSED (0X274D/10061) IS THE SERVER RUNNING ON HOST LOCALHOST AND ACCEPTING

Re: [ADMIN] Auto vacuum

2007-04-22 Thread Robert Treat
On Thursday 19 April 2007 13:54, Carol Walter wrote: I certainly appreciate the help you've given. Here's what the code in this part of postgresql.conf file says. autovacuum = on autovacuum_naptime = 30 # time between autovacuum runs, in secs autovacuum_vacuum_threshold = 500

[ADMIN] Postgresql Help

2007-04-22 Thread Mageshwaran
Hi , I am new to postgresql, I have been assigned a task of upgrading postgresql to higher version. In our company we are using 7.1.1,7.1.3,7.4.5 versions of postgresql, can you please tell me which is the stable and suitable version in 8.x version. Please reply me, Regards J Mageshwaran