[ADMIN] PostgreSQL replication solution?

Hi to all,   I have to do a database replication (of corse pgsql database) and I never done something like this. I still read about ...  what replication is.   Can anyone send me some directions, documentation, ideeas, solutions?   Thanks. Andy.

[ADMIN] Log File Maintainance

Hello,   I am working on live server where we have installed postgres database as our back end. But now the problem is due to continues work on postgres, size of log files has become problem for us. And the partition where our postgres exists is full. Postmaster is not working now. I tried

Re: [ADMIN] Mysql to postgres

Title: RE: [ADMIN] Mysql to postgres Thankyou all for your feedback. Unfortunately, I think I may have to go down the lower() road of changing the code. It will be far more time consuming, however there are other columns that are char,varchar,text etc. Will definitely keep the citext contr

Re: [ADMIN] Pg_autovacuum script.

A while back, I wrote this: http://www.sitening.com/auto_pg_autovacuum While not exactly an init script, it sanely avoids multiply starting pg_autovacuum. Then I did this: http://www.sitening.com/pgautovacuum which is a proper init script. Thanks for prompting me to post it! Now there are some op

Re: [ADMIN] Limited to 100 connections

max_connections is a setting that can only be set at server start. Are you restarting postgres after you change the setting in postgresql.conf? -tfo -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC Strategic Open Source: Open Your i™ http://www.sitening.com/ 110 30th Avenue

Re: [ADMIN] Trying to use initlocation

For an explanation of the purpose and behavior of initlocation, look here: http://www.postgresql.org/docs/7.4/static/app-initlocation.html You can call it with an explicit path (e.g., /usr/lib/postgresql/bin/initlocation), or you can add it to your path. -tfo -- Thomas F. O'Connell Co-Founder,

Re: [ADMIN] Mysql to postgres

On Mon, Apr 11, 2005 at 03:02:01AM -0400, Tom Lane wrote: > I think you could probably also do it by building a locale whose > comparisons are case-insensitive, but I don't know enough about > locales to be sure. FWIW, this is how old versions of Sybase handled case insensitivity. Pretty much ever

Re: [ADMIN] Problem in order by

Hi Stephan, tks I drop database and move directory data to data01. I already executed "initdb --locale=C" and the file postgresql.conf change to LC_MESSAGES, LC_MONETARY, LC_NUMERIC and LC_TIME = 'C', but the problem persist. I already executed too after move the directory data: initdb --encoding

Re: [ADMIN] Problem in order by

On Mon, 11 Apr 2005, [iso-8859-1] Reuly Bússolo Mendes wrote: > In the Cygwin, the return is correct: > >prodes > > TELHA FRANCESA CAMBORIU > TELHA PORTUGUESA SAO CRISTOVAO > TELHA ROMANA LEONEL PEREIRA > TELHA TRANS

[ADMIN] Problem in order by

Hi, I make a dump from a database in cygwin in Windows to PG 7.3 in linux Red Hat 9. But I have a problem with 'order by'. The query is 'select prodes from es002 where prodes like 'TELHA%' order by 1' In the Cygwin, the return is correct: prodes --

Re: [ADMIN] pg_dump on remote machine

Hello, > I have been trying to dump my data from one machine to another. I have > proper configuration in the pg_hba.conf file on both machines. I can connect > to the remote DB using : > > psql -h 172.16.1.39 ha > > I then run the command: > > pg_dump -h 172.16.1.20 evo10 > > to get

[ADMIN] pg_dump on remote machine

I have been trying to dump my data from one machine to another. I have proper configuration in the pg_hba.conf file on both machines. I can connect to the remote DB using : psql -h 172.16.1.39 ha I then run the command: pg_dump -h 172.16.1.20 evo10 to get the DB evo10 from machine 172

Re: [ADMIN] pg_dump on remote machine

Hello, > Yes I can get connected by psql -h 172.16.30.2 (dbname) and I can also connect to the remote DB using phpPgAdmin. I have given the permissions on pg_hba.conf file. Hmmm, when you connected with psql -h 172.16.30.2 (dbname), are you able to get data with the select-command? If not, you mu

Re: [ADMIN] Mysql to postgres

Theo Galanakis <[EMAIL PROTECTED]> writes: > There may be a way to change the database in postgres to be case > insensitive. i.e. change some of the operations such as "text=text" to be > case insensitive. Does this sound Insane? I think it would be exceedingly unwise to muck with the standard beh