Re: Replication

Thanks for all who replied.
 
There are certain cases where multi-master rep are very implementable such as where
the datasets being rep are fairly disjointed but need to be replicated for completeness in
terms of reporting. But you are absolutely 110% correct. Multimaster synchro is a nightmare.
 
 

	-----Original Message----- 
	From: Christopher Browne [mailto:cbbrowne <at> acm.org] 
	Sent: Sat 8/30/2003 4:47 PM 
	To: pgsql-admin <at> postgresql.org 
	Cc: 
	Subject: Re: [ADMIN] Replication
	
	

	Martha Stewart called it a Good Thing whenianh <at> hubspan.com ("Ian Huynh")wrote:
	> Seems that there are a number of simultaneous project in trying to implement replication
	> for postgres.
	> 
	> Is anyone out there using this feature currently? If so , which package & OS environment.
	> 
	> the latest news was eRServer v1.0.   Is this the same as the v1.2 that Postgres INC announced
	> early this year ?
	> 
	> Is there a master-master capability or only master-multi-slave ?
	
	The version of eRServer recently released as free software is not the
	latest "production" release, but it is a direct predecessor.

pg_atoi: error in.....: can't parse..."

Prompts in psql

Is there any way to change the prompt in the psql CLI client? In the
same way as one does with bash, or other shells.

Ideally I want:

username <at> host:database $

as the prompt. Anyone got any ideas/references?

--

-- 

Sam Barnett-Cormack
Software Developer                           |  Student of Physics & Maths
UK Mirror Service (http://www.mirror.ac.uk)  |  Lancaster University

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo <at> postgresql.org

Re: Prompts in psql

Sam Barnett-Cormack wrote:
> Is there any way to change the prompt in the psql CLI client? In the
> same way as one does with bash, or other shells.
> 
> Ideally I want:
> 
> username <at> host:database $
> 
> as the prompt. Anyone got any ideas/references?

Sure, see the psql manual page.

--

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman <at> candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo <at> postgresql.org

Running postgresql on an memory stick

Hi folks,

as anyone tested tunning postgresql on a memory stick ?

cu
--

-- 
---------------------------------------------------------------------
 Enrico Weigelt    ==   metux IT services

 phone:     +49 36207 519931         www:       http://www.metux.de/     
 fax:       +49 36207 519932         email:     contact <at> metux.de
 cellphone: +49 174 7066481	     
---------------------------------------------------------------------
 Diese Mail wurde mit UUCP versandt.      http://www.metux.de/uucp/

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html

Re: Prompts in psql

Sam Barnett-Cormack wrote:

>Is there any way to change the prompt in the psql CLI client? In the
>same way as one does with bash, or other shells.
>
>Ideally I want:
>
>username <at> host:database $
>
>as the prompt. Anyone got any ideas/references?
>
>  
>

Put
\set PROMPT1 '%n <at> %m:%~%R%# '
in your .psqlrc file.

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html

Re: pg_atoi: error in.....: can't parse..."

stessy writes:

> I have this error "pg_atoi: error in "PARC INDUSTRIEL": can't parse
> "PARC INDUSTRIEL" "  when I try to copy data from file to database.

The copy is seeing the value "PARC INDUSTRIEL" while it is trying to fill
a numerical column.  Make sure the order and type of your columns matches.

--

-- 
Peter Eisentraut   peter_e <at> gmx.net

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo <at> postgresql.org)

Still confusing with "LISTEN,UNLISTEN,NOTIFY" Command.

language "plpgsql" does not exist

Hi everybody.
I'm a new born in the PostGreSQL domain (usually deal with Oracle or SQL
Server) and I got the following error when trying to create a function using
the default language plpgsql: language "plpgsql" does not exist
I was not able to find clues on the net to help me to solve this problem,
that's why I'm sending this post now.

I just installed the version 7.3.4 of PostGreSQL (basic installation).

Here the source of the function I try to create:
-------------
CREATE OR REPLACE FUNCTION ts_groupEdit
(VARCHAR,INTEGER,VARCHAR,VARCHAR,INTEGER,INTEGER) RETURNS INTEGER AS '

DECLARE
vi_name ALIAS FOR $1;
vi_companyId ALIAS FOR $2;
vi_description ALIAS FOR $3;
vi_rights ALIAS FOR $4;
vi_debug ALIAS FOR $5;
v_groupId INTEGER;
BEGIN
        SELECT groupId INTO v_groupId
        FROM Groups
        WHERE companyId=vi_companyid AND
                name=vi_name;

        IF v_groupId IS NOT NULL THEN
                UPDATE GROUPS SET description=vi_description
                WHERE groupId=v_groupId;
        ELSE
                INSERT INTO Groups (companyId, name, description)
                VALUES (vi_companyid, vi_name, vi_description);
        END IF;

        RETURN 0;
END; '
LANGUAGE 'plpgsql';
-------------

Any help will be welcome.
May be I have to load or install the plpgsql module, but I didn't find such
instruction in the documentation so I guess it is there by default.

Seb.

--
Sébastien BAUDRY - DBA Oracle/MS-SQL & Project Manager
BAUDRY ENGINEERING BT. H-1025 Budapest Verhalom utca. 31/D. I/8.
 <at> .: sebastien.baudry <at> baudry-engineering.com
mobile.: +36-30-392-0279 / tel: +36-1-326-0241 / fax: +36-1-326-0241
http://www.baudry-engineering.com

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Re: language "plpgsql" does not exist

Hum, I feel sorry to have disturbed you with such beginner's question.
I just found out the solution: should create the language entry myself.

Next time I hope to have a more interesting question 

Seb.

--
Sébastien BAUDRY - DBA Oracle/MS-SQL & Project Manager
BAUDRY ENGINEERING BT. H-1025 Budapest Verhalom utca. 31/D. I/8.
 <at> .: sebastien.baudry <at> baudry-engineering.com
mobile.: +36-30-392-0279 / tel: +36-1-326-0241 / fax: +36-1-326-0241
http://www.baudry-engineering.com

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo <at> postgresql.org