Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit81fa9e0

Browse files
committed
in the Directory src/bin/pgtclsh there is a good mechanism to integrate
thetcl-spec in the Makefile.The patch in the attachemant does this in the src/interfaces/libpgtcltooThank you Rudolf Weber
1 parent37ce95c commit81fa9e0

File tree

3 files changed

+134
-8
lines changed

3 files changed

+134
-8
lines changed

‎configure.in

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1312,6 +1312,8 @@ AC_OUTPUT(
13121312
src/interfaces/libpq++/Makefile
13131313
src/interfaces/libpgeasy/Makefile
13141314
src/interfaces/libpgtcl/Makefile
1315+
src/interfaces/libpgtcl/mkMakefile.tcldefs.sh
1316+
src/interfaces/libpgtcl/mkMakefile.tkdefs.sh
13151317
src/interfaces/odbc/GNUmakefile
13161318
src/interfaces/odbc/Makefile.global
13171319
src/interfaces/python/GNUmakefile

‎doc/TODO.detail/replication

Lines changed: 118 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -43,7 +43,7 @@ From owner-pgsql-hackers@hub.org Fri Dec 24 10:01:18 1999
4343
Received: from renoir.op.net (root@renoir.op.net [207.29.195.4])
4444
by candle.pha.pa.us (8.9.0/8.9.0) with ESMTP id LAA11295
4545
for <pgman@candle.pha.pa.us>; Fri, 24 Dec 1999 11:01:17 -0500 (EST)
46-
Received: from hub.org (hub.org [216.126.84.1]) by renoir.op.net (o1/$Revision: 1.4 $) with ESMTP id KAA20310 for <pgman@candle.pha.pa.us>; Fri, 24 Dec 1999 10:39:18 -0500 (EST)
46+
Received: from hub.org (hub.org [216.126.84.1]) by renoir.op.net (o1/$Revision: 1.5 $) with ESMTP id KAA20310 for <pgman@candle.pha.pa.us>; Fri, 24 Dec 1999 10:39:18 -0500 (EST)
4747
Received: from localhost (majordom@localhost)
4848
by hub.org (8.9.3/8.9.3) with SMTP id KAA61760;
4949
Fri, 24 Dec 1999 10:31:13 -0500 (EST)
@@ -129,7 +129,7 @@ From owner-pgsql-hackers@hub.org Fri Dec 24 18:31:03 1999
129129
Received: from renoir.op.net (root@renoir.op.net [207.29.195.4])
130130
by candle.pha.pa.us (8.9.0/8.9.0) with ESMTP id TAA26244
131131
for <pgman@candle.pha.pa.us>; Fri, 24 Dec 1999 19:31:02 -0500 (EST)
132-
Received: from hub.org (hub.org [216.126.84.1]) by renoir.op.net (o1/$Revision: 1.4 $) with ESMTP id TAA12730 for <pgman@candle.pha.pa.us>; Fri, 24 Dec 1999 19:30:05 -0500 (EST)
132+
Received: from hub.org (hub.org [216.126.84.1]) by renoir.op.net (o1/$Revision: 1.5 $) with ESMTP id TAA12730 for <pgman@candle.pha.pa.us>; Fri, 24 Dec 1999 19:30:05 -0500 (EST)
133133
Received: from localhost (majordom@localhost)
134134
by hub.org (8.9.3/8.9.3) with SMTP id TAA57851;
135135
Fri, 24 Dec 1999 19:23:31 -0500 (EST)
@@ -212,7 +212,7 @@ From owner-pgsql-hackers@hub.org Fri Dec 24 21:31:10 1999
212212
Received: from renoir.op.net (root@renoir.op.net [207.29.195.4])
213213
by candle.pha.pa.us (8.9.0/8.9.0) with ESMTP id WAA02578
214214
for <pgman@candle.pha.pa.us>; Fri, 24 Dec 1999 22:31:09 -0500 (EST)
215-
Received: from hub.org (hub.org [216.126.84.1]) by renoir.op.net (o1/$Revision: 1.4 $) with ESMTP id WAA16641 for <pgman@candle.pha.pa.us>; Fri, 24 Dec 1999 22:18:56 -0500 (EST)
215+
Received: from hub.org (hub.org [216.126.84.1]) by renoir.op.net (o1/$Revision: 1.5 $) with ESMTP id WAA16641 for <pgman@candle.pha.pa.us>; Fri, 24 Dec 1999 22:18:56 -0500 (EST)
216216
Received: from localhost (majordom@localhost)
217217
by hub.org (8.9.3/8.9.3) with SMTP id WAA89135;
218218
Fri, 24 Dec 1999 22:11:12 -0500 (EST)
@@ -486,7 +486,7 @@ From owner-pgsql-hackers@hub.org Sun Dec 26 08:31:09 1999
486486
Received: from renoir.op.net (root@renoir.op.net [207.29.195.4])
487487
by candle.pha.pa.us (8.9.0/8.9.0) with ESMTP id JAA17976
488488
for <pgman@candle.pha.pa.us>; Sun, 26 Dec 1999 09:31:07 -0500 (EST)
489-
Received: from hub.org (hub.org [216.126.84.1]) by renoir.op.net (o1/$Revision: 1.4 $) with ESMTP id JAA23337 for <pgman@candle.pha.pa.us>; Sun, 26 Dec 1999 09:28:36 -0500 (EST)
489+
Received: from hub.org (hub.org [216.126.84.1]) by renoir.op.net (o1/$Revision: 1.5 $) with ESMTP id JAA23337 for <pgman@candle.pha.pa.us>; Sun, 26 Dec 1999 09:28:36 -0500 (EST)
490490
Received: from localhost (majordom@localhost)
491491
by hub.org (8.9.3/8.9.3) with SMTP id JAA90738;
492492
Sun, 26 Dec 1999 09:21:58 -0500 (EST)
@@ -909,7 +909,7 @@ From owner-pgsql-hackers@hub.org Thu Dec 30 08:01:09 1999
909909
Received: from renoir.op.net (root@renoir.op.net [207.29.195.4])
910910
by candle.pha.pa.us (8.9.0/8.9.0) with ESMTP id JAA10317
911911
for <pgman@candle.pha.pa.us>; Thu, 30 Dec 1999 09:01:08 -0500 (EST)
912-
Received: from hub.org (hub.org [216.126.84.1]) by renoir.op.net (o1/$Revision: 1.4 $) with ESMTP id IAA02365 for <pgman@candle.pha.pa.us>; Thu, 30 Dec 1999 08:37:10 -0500 (EST)
912+
Received: from hub.org (hub.org [216.126.84.1]) by renoir.op.net (o1/$Revision: 1.5 $) with ESMTP id IAA02365 for <pgman@candle.pha.pa.us>; Thu, 30 Dec 1999 08:37:10 -0500 (EST)
913913
Received: from localhost (majordom@localhost)
914914
by hub.org (8.9.3/8.9.3) with SMTP id IAA87902;
915915
Thu, 30 Dec 1999 08:34:22 -0500 (EST)
@@ -1006,7 +1006,7 @@ From owner-pgsql-patches@hub.org Sun Jan 2 23:01:38 2000
10061006
Received: from renoir.op.net (root@renoir.op.net [207.29.195.4])
10071007
by candle.pha.pa.us (8.9.0/8.9.0) with ESMTP id AAA16274
10081008
for <pgman@candle.pha.pa.us>; Mon, 3 Jan 2000 00:01:28 -0500 (EST)
1009-
Received: from hub.org (hub.org [216.126.84.1]) by renoir.op.net (o1/$Revision: 1.4 $) with ESMTP id XAA02655 for <pgman@candle.pha.pa.us>; Sun, 2 Jan 2000 23:45:55 -0500 (EST)
1009+
Received: from hub.org (hub.org [216.126.84.1]) by renoir.op.net (o1/$Revision: 1.5 $) with ESMTP id XAA02655 for <pgman@candle.pha.pa.us>; Sun, 2 Jan 2000 23:45:55 -0500 (EST)
10101010
Received: from hub.org (hub.org [216.126.84.1])
10111011
by hub.org (8.9.3/8.9.3) with ESMTP id XAA13828;
10121012
Sun, 2 Jan 2000 23:40:47 -0500 (EST)
@@ -1424,7 +1424,7 @@ From owner-pgsql-hackers@hub.org Tue Jan 4 10:31:01 2000
14241424
Received: from renoir.op.net (root@renoir.op.net [207.29.195.4])
14251425
by candle.pha.pa.us (8.9.0/8.9.0) with ESMTP id LAA17522
14261426
for <pgman@candle.pha.pa.us>; Tue, 4 Jan 2000 11:31:00 -0500 (EST)
1427-
Received: from hub.org (hub.org [216.126.84.1]) by renoir.op.net (o1/$Revision: 1.4 $) with ESMTP id LAA01541 for <pgman@candle.pha.pa.us>; Tue, 4 Jan 2000 11:27:30 -0500 (EST)
1427+
Received: from hub.org (hub.org [216.126.84.1]) by renoir.op.net (o1/$Revision: 1.5 $) with ESMTP id LAA01541 for <pgman@candle.pha.pa.us>; Tue, 4 Jan 2000 11:27:30 -0500 (EST)
14281428
Received: from localhost (majordom@localhost)
14291429
by hub.org (8.9.3/8.9.3) with SMTP id LAA09992;
14301430
Tue, 4 Jan 2000 11:18:07 -0500 (EST)
@@ -1617,3 +1617,114 @@ RDBMS, and you will have trouble convincing management that this is not
16171617
really true.
16181618

16191619

1620+
From pgsql-hackers-owner+M2401@hub.org Tue May 23 12:19:54 2000
1621+
Received: from news.tht.net (news.hub.org [216.126.91.242])
1622+
by candle.pha.pa.us (8.9.0/8.9.0) with ESMTP id MAA28410
1623+
for <pgman@candle.pha.pa.us>; Tue, 23 May 2000 12:19:53 -0400 (EDT)
1624+
Received: from hub.org (majordom@hub.org [216.126.84.1])
1625+
by news.tht.net (8.9.3/8.9.3) with ESMTP id MAB53304;
1626+
Tue, 23 May 2000 12:00:08 -0400 (EDT)
1627+
(envelope-from pgsql-hackers-owner+M2401@hub.org)
1628+
Received: from gwineta.repas.de (gwineta.repas.de [193.101.49.1])
1629+
by hub.org (8.9.3/8.9.3) with ESMTP id LAA39896
1630+
for <pgsql-hackers@postgresql.org>; Tue, 23 May 2000 11:57:31 -0400 (EDT)
1631+
(envelope-from kardos@repas-aeg.de)
1632+
Received: (from smap@localhost)
1633+
by gwineta.repas.de (8.8.8/8.8.8) id RAA27154
1634+
for <pgsql-hackers@postgresql.org>; Tue, 23 May 2000 17:57:23 +0200
1635+
Received: from dragon.dr.repas.de(172.30.48.206) by gwineta.repas.de via smap (V2.1)
1636+
id xma027101; Tue, 23 May 00 17:56:20 +0200
1637+
Received: from kardos.dr.repas.de ([172.30.48.153])
1638+
by dragon.dr.repas.de (UCX V4.2-21C, OpenVMS V6.2 Alpha);
1639+
Tue, 23 May 2000 17:57:24 +0200
1640+
Message-ID: <010201bfc4cf$7334d5a0$99301eac@Dr.repas.de>
1641+
From: "Kardos, Dr. Andreas" <kardos@repas-aeg.de>
1642+
To: "Todd M. Shrider" <tshrider@varesearch.com>,
1643+
<pgsql-hackers@postgresql.org>
1644+
References: <Pine.LNX.4.04.10005180846290.15739-100000@silicon.su.valinux.com>
1645+
Subject: Re: [HACKERS] failing over with postgresql
1646+
Date: Tue, 23 May 2000 17:56:20 +0200
1647+
Organization: repas AEG Automation GmbH
1648+
MIME-Version: 1.0
1649+
Content-Type: text/plain;
1650+
charset="iso-8859-1"
1651+
Content-Transfer-Encoding: 8bit
1652+
X-Priority: 3
1653+
X-MSMail-Priority: Normal
1654+
X-Mailer: Microsoft Outlook Express 5.00.2314.1300
1655+
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
1656+
X-Mailing-List: pgsql-hackers@postgresql.org
1657+
Precedence: bulk
1658+
Sender: pgsql-hackers-owner@hub.org
1659+
Status: OR
1660+
1661+
For a SCADA system (Supervisory Control and Data Akquisition) which consists
1662+
of one master and one hot-standby server I have implemented such a
1663+
solution. To these UNIX servers client workstations are connected (NT and/or
1664+
UNIX). The database client programms run on client and server side.
1665+
1666+
When developing this approach I had to goals in mind:
1667+
1) Not to get dependend on the PostgreSQL sources since they change very
1668+
dynamically.
1669+
2) Not to get dependend on the fe/be protocol since there are discussions
1670+
around to change it.
1671+
1672+
So the approach is quite simple: Forward all database requests to the
1673+
standby server on TCP/IP level.
1674+
1675+
On both servers the postmaster listens on port 5433 and not on 5432. On
1676+
standard port 5432 my program listens instead. This program forks twice for
1677+
every incomming connection. The first instance forwards all packets from the
1678+
frontend to both backends. The second instance receives the packets from all
1679+
backends and forwards the packets from the master backend to the frontend.
1680+
So a frontend running on a server machine connects to port 5432 of
1681+
localhost.
1682+
1683+
On the client machine runs another program (on NT as a service). This
1684+
program forks for every incomming connections twice. The first instance
1685+
forwards all packets to port 5432 of the current master server and the
1686+
second instance forwards the packets from the master server to the frontend.
1687+
1688+
During standby computer startup the database of the master computer is
1689+
dumped, zipped, copied to the standby computer, unzipped and loaded into
1690+
that database.
1691+
If a standby startup took place, all client connections are aborted to allow
1692+
a login into the standby database. The frontends need to reconnect in this
1693+
case. So the database of the standby computer is always in sync.
1694+
1695+
The disadvantage of this method is that a query cannot be canceled in the
1696+
standby server since the request key of this connections gets lost. But we
1697+
can live with that.
1698+
1699+
Both programms are able to run on Unix and on (native!) NT. On NT threads
1700+
are created instead of forked processes.
1701+
1702+
This approach is simple, but it is effective and it works.
1703+
1704+
We hope to survive this way until real replication will be implemented in
1705+
PostgreSQL.
1706+
1707+
Andreas Kardos
1708+
1709+
-----Urspr�ngliche Nachricht-----
1710+
Von: Todd M. Shrider <tshrider@varesearch.com>
1711+
An: <pgsql-hackers@postgresql.org>
1712+
Gesendet: Donnerstag, 18. Mai 2000 17:48
1713+
Betreff: [HACKERS] failing over with postgresql
1714+
1715+
1716+
>
1717+
> is anyone working on or have working a fail-over implentation for the
1718+
> postgresql stuff. i'd be interested in seeing if and how any might be
1719+
> dealing with just general issues as well as the database syncing issues.
1720+
>
1721+
> we are looking to do this with heartbeat and lvs in mind. also if anyone
1722+
> is load ballancing their databases that would be cool to talk about to.
1723+
>
1724+
> ---
1725+
> Todd M. Shrider VA Linux Systems
1726+
> Systems Engineer
1727+
> tshrider@valinux.com www.valinux.com
1728+
>
1729+
1730+

‎src/interfaces/libpgtcl/Makefile.in

Lines changed: 14 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -6,7 +6,7 @@
66
# Copyright (c) 1994, Regents of the University of California
77
#
88
# IDENTIFICATION
9-
# $Header: /cvsroot/pgsql/src/interfaces/libpgtcl/Attic/Makefile.in,v 1.41 2000/06/06 22:01:01 petere Exp $
9+
# $Header: /cvsroot/pgsql/src/interfaces/libpgtcl/Attic/Makefile.in,v 1.42 2000/06/13 09:16:39 momjian Exp $
1010
#
1111
#-------------------------------------------------------------------------
1212

@@ -19,6 +19,14 @@ include $(SRCDIR)/Makefile.global
1919

2020
CFLAGS+= -I$(LIBPQDIR)
2121

22+
#
23+
# Include definitions from the tclConfig.sh file
24+
#
25+
include Makefile.tcldefs
26+
ifeq ($(USE_TK), true)
27+
include Makefile.tkdefs
28+
endif
29+
2230
ifdefKRBVERS
2331
CFLAGS+=$(KRBFLAGS)
2432
endif
@@ -46,6 +54,11 @@ install-headers: beforeinstall-headers libpgtcl.h
4654
beforeinstall-headers:
4755
-@if [!-d$(HEADERDIR) ];then mkdir$(HEADERDIR);fi
4856

57+
Makefile.tcldefs: mkMakefile.tcldefs.sh
58+
/bin/sh mkMakefile.tcldefs.sh
59+
60+
Makefile.tkdefs: mkMakefile.tkdefs.sh
61+
/bin/sh mkMakefile.tkdefs.sh
4962

5063
.PHONY: clean
5164

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp