Re: [ADMIN] can be database files be copied using 'cp' between hosts with

2005-04-10 Thread William Yu
I've been able to do Solaris x86 -> Linux x86 copies. But I'm pretty sure Sparc & x86 are not compatible endian-wise so hence the data is not stored the same. Other attempts that have failed -- Linux x86 32bit --> Linux x86_64. Vlad Harchev wrote: On Sat, Apr 09, 2005 at 08:42:19PM +0200, Peter

Re: [ADMIN] Automatic Backups

2005-04-10 Thread John DeSoi
On Apr 8, 2005, at 4:00 PM, David A. Leedom wrote: I found that the registry entries use a GUID product code on the final node of the registry. Is there any way to link this back to the running database? I could hard code the product codes into my backup app. If for some reason there are more

Re: [ADMIN] Automatic Backups

2005-04-10 Thread Magnus Hagander
>> I found that the registry entries use a GUID product code on >the final >> node of the registry. Is there any way to link this back to the >> running database? You mean from the GUID to the database? From the GUID you can get the data directory, port number, service id etc - it should be ev

[ADMIN] PostgreSQL 8.0 installation on Windows XP installation

2005-04-10 Thread Abdul Shakoor
I'm trying for the first time to install Postgresql-8.0 in Windows. When I came up to the point where I was asked to make a choice between the installation as a service or programe. On that point I selected Program. Installation process was completed I have not made any changes to any of the fil

Re: [ADMIN] Trying to use initlocation

2005-04-10 Thread Henric Ernstson
Ok, if it's not in my path /usr/lib/postgresql/bin/initlocation how do I do then to use initlocation? Must it bee in that path? (what exactly do initlocation?) sets some parameter in some set-up files? Citerar Jonathan Daugherty <[EMAIL PROTECTED]>: > # And after that I have tryed to run initl

[ADMIN] Automatically updating pg_hba.conf

2005-04-10 Thread Serge Obeuf
Hi all, How can Administrative PostGres Client such as "pgadmin" automatically update the server pg_hba.conf file as soon as a new user is created ? Thank you for telling is there is any way ? Best regards. -- Serge Obeuf DISI/SI ---(end of broadcast)-

[ADMIN] conection erro

2005-04-10 Thread Fernando Andreacci
postgresql.conf not exist... when I click to edit the file, windows ask me to create one because not exist, so I create a .txt file, but not work. please help me :D Fernando _ MSN Messenger: converse online com seus amigos . http:/

[ADMIN] Limited to 100 connections

2005-04-10 Thread fred
Hi, I'm using Postgres on MacOS X 10.3 and I'm limited to 100 connections. In the postgres.conf, I set max_connections to 300, but I'm always limited to 100 connections. I also increased the SHM_MAX to 400 Megs I connect to my database using PHP scripts and pg_pconnect. If anyone got an idea, I'

[ADMIN] Problem Postgres importation of sql file

2005-04-10 Thread Kelly Kane
Hi, Please, I would like to know if there's any software which let create tables (for database) and export them into a sript which can be used by postgres to import the database created ? I'm using PgAdminIII for postgres and the software I used to create tables is called "DB Designer" but the

[ADMIN] Postgress ETL/Replication

2005-04-10 Thread hokah
Hi, Im wish to build Data Warehouse on PostgreSQL, what I need is the tool for replication with the Progress database and getting data from txt files, as far i know I need ETL tool to achive this. If you know any free tool for ETL which would work with PostgreSQL and Progress, please let me know

[ADMIN] Problems recovering sequences from a backup done with pg_dump

2005-04-10 Thread David Sáez Palacios
Hi all,     I've done a dump from a PostgreSQL 7.4.5 using pg_dump and it worked find. The problem comes when I restore the backup and all the sequences values are 1. I can fix the problem manually giving the sequeces their appropiate value but I wonder wether is a way to force pg_dump to store th

[ADMIN] postgres help

2005-04-10 Thread goa
We had developed some apllication with postgres-7.0.3-8 as back end now that we have upgraded all our servers to redhat9.0,also we cannot use new version of postgres since there is some issues with date fields which we use of postgres-7.0   I am not able to compile postgresql-7.0.3-8 on redhat9.0i

Re: [ADMIN] postgres help

2005-04-10 Thread Michael Fuhr
On Sat, Apr 09, 2005 at 02:46:01AM -0700, goa wrote: > > We had developed some apllication with postgres-7.0.3-8 as back end > now that we have upgraded all our servers to redhat9.0,also we cannot > use new version of postgres since there is some issues with date fields > which we use of postgres-7

Re: [ADMIN] Problem Postgres importation of sql file

2005-04-10 Thread Bruno Wolff III
On Sun, Apr 10, 2005 at 13:06:15 +, Kelly Kane <[EMAIL PROTECTED]> wrote: > > I'm using PgAdminIII for postgres and the software I used to create tables > is called "DB Designer" but the sql file generated doesn't work with > postgres if I try to import from this file, it makes errors (for

Re: [ADMIN] Problems recovering sequences from a backup done with pg_dump

2005-04-10 Thread Michael Fuhr
On Wed, Apr 06, 2005 at 10:18:34AM -0100, David Sáez Palacios wrote: > > I've done a dump from a PostgreSQL 7.4.5 using pg_dump and it worked find. > The problem comes when I restore the backup and all the sequences values are > 1. I can fix the problem manually giving the sequeces their appropi

Re: [ADMIN] PostgreSQL 8.0 installation on Windows XP installation

2005-04-10 Thread John DeSoi
On Apr 6, 2005, at 7:58 PM, Abdul Shakoor wrote: I'm trying for the first time to install Postgresql-8.0 in Windows. When I came up to the point where I was asked to make a choice between the installation as a service or programe. On that point I selected Program. Installation process was complet

[ADMIN] Pg_autovacuum script.

2005-04-10 Thread Theo Galanakis
Title: Pg_autovacuum script. Since I could not locate anything similar on the net, I have written a script to automatically start and stop the autovacuum daemon. This should be added to the existing postgresql script. Please let me know if you can see any shortcomings. I have taken into cons

Re: [ADMIN] Automatically updating pg_hba.conf

2005-04-10 Thread Bruce Momjian
Serge Obeuf wrote: > Hi all, > > How can Administrative PostGres Client such as "pgadmin" automatically > update the server pg_hba.conf file as soon as a new user is created ? > > Thank you for telling is there is any way ? No. However, you can use groups in pg_hba.conf and just put the user i

Re: [ADMIN] postgres help

2005-04-10 Thread Tom Lane
Michael Fuhr <[EMAIL PROTECTED]> writes: > On Sat, Apr 09, 2005 at 02:46:01AM -0700, goa wrote: >> We had developed some apllication with postgres-7.0.3-8 as back end >> now that we have upgraded all our servers to redhat9.0,also we cannot >> use new version of postgres since there is some issues w

[ADMIN] Mysql to postgres

2005-04-10 Thread Theo Galanakis
Title: Mysql to postgres I have a legacy system that has been developed with a mysql backend. I'm in the process of converting it over to postgres. As postgres is case sensitive it appears as I will have to make numerous code changes from "like" to "ilike" and from e.g. "cola = cola" to  "lowe