Postgres graphing.
Sorry to be a little off topic. I'm looking for a tool that would connect to a postgres base, list the tables/constraints of it and make a nice .jpeg file showing the data model out of it. All this would be automagical off course... Does such a beast exists ? Anything near ? Nico -- Administrateur Système/Réseau - GHS 38, rue du Texel 75014 Paris Tél : 01 43 21 16 66 - [EMAIL PROTECTED] - [EMAIL PROTECTED] -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Re: Postgres graphing.
On Wed, Dec 12, 2001 at 15:50:23 +0100, Nicolas Bouthors wrote: I'm looking for a tool that would connect to a postgres base, list the tables/constraints of it and make a nice .jpeg file showing the data model out of it. All this would be automagical off course... http://freshmeat.net/projects/postgresql_autodoc/ looks like it, at least based on its description - haven't tried it myself. HTH, Ray -- Where do you want to go today? Confutatis maledictis, flammis acribus addictis. -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Re: Traffic control with traffic shaper
--- Limiting Outgoing and Incoming Bandwidth in Linux (for 2.2+ Kernels) Brian Wilson - [EMAIL PROTECTED] - 12/5/2000 Overview The point of this document is to walk you through setting up bandwidth limiting for outgoing and incoming network packets under Linux 2.2.x+ kernel series. The limiting of the outgoing bandwidth is accomplished using the built-in QoS Class Based Queueing (CBQ) functions in the 2.2.x kernel. The limiting of the incoming bandwidth is accomplished using a stand-alone kernel module called rshaper. NOTE: rshaper also requires slight modififications to your network driver source code. Before You Begin You first need to download a few utilities. - iproute ftp://ftp.funet.fi/pub/mirrors/ftp.inr.ac.ru/ip-routing/iproute2-current.tar.gz (and if you wish to limit incoming traffic as well, you'll need rshaper) - rshaper ftp://ftp.prosa.it/pub/software/rshaper-1.07.tar.gz Installation You'll first need to configure your kernel for QoS and CBQ. This is accomplished under the Networking Options menu. Here you need to enable Routing Messages and the Kernel/User netlink socket. Next, under QoS and/or Fair Queueing menu, you need to enable all of the options. Below is the Networking Options portion of my kernel config. You should probably mimic this setup (unless you want to build them as modules). If you do choose to build them as modules, then you'll have to load all the specifc QoS modules (sch_cbq sch_tbf sch_sfq sch_prio cls_u32) after your machine boots (or allow them to be autoloaded). Since I don't like dealing with a slew of modules, I usually try to compile everything in staticly. * Packet socket [*] Kernel/User netlink socket [*] Routing messages * Netlink device emulation [*] Network firewalls [*] Socket Filtering * Unix domain sockets [*] TCP/IP networking [*] IP: multicasting [*] IP: advanced router [*] IP: policy routing [*] IP: equal cost multipath [*] IP: use TOS value as routing key [ ] IP: verbose route monitoring [ ] IP: large routing tables [*] IP: fast network address translation [ ] IP: kernel level autoconfiguration [*] IP: firewalling [ ] IP: firewall packet netlink device [*] IP: use FWMARK value as routing key [*] IP: masquerading --- Protocol-specific masquerading support will be built as modules. [*] IP: ICMP masquerading --- Protocol-specific masquerading support will be built as modules. [*] IP: masquerading special modules support * IP: ipautofw masq support (EXPERIMENTAL) * IP: ipportfw masq support (EXPERIMENTAL) * IP: ip fwmark masq-forwarding support (EXPERIMENTAL) [ ] IP: optimize as router not host IP: tunneling [*] IP: aliasing support [ ] IP: ARP daemon support (EXPERIMENTAL) [*] IP: TCP syncookie support (not enabled per default) --- (it is safe to leave these untouched) * IP: Reverse ARP [*] IP: Allow large windows (not recommended if 16Mb of memory) The IPv6 protocol (EXPERIMENTAL) --- The IPX protocol Appletalk DDP CCITT X.25 Packet Layer (EXPERIMENTAL) LAPB Data Link Driver (EXPERIMENTAL) [ ] Bridging (EXPERIMENTAL) [ ] 802.2 LLC (EXPERIMENTAL) Acorn Econet/AUN protocols (EXPERIMENTAL) WAN router [*] CPU is too slow to handle full bandwidth QoS and/or fair queueing --- [*] QoS and/or fair queueing * CBQ packet scheduler * CSZ packet scheduler * The simplest PRIO pseudoscheduler * RED queue * SFQ queue * TEQL queue * TBF queue [*] QoS support [*] Rate estimator [*] Packet classifier API * Routing table based classifier * Firewall based classifier * U32 classifier * Special RSVP classifier Special RSVP classifier for IPv6 [*] Ingres traffic policing While you are in the kernel config, if you have decided to use rshaper and limit incoming traffic, then go ahead and modularize your network device driver (if its not already a module). M Sun LANCE support Doing so will be helpful in modifying the driver and setting it up for
Postgres graphing.
Sorry to be a little off topic. I'm looking for a tool that would connect to a postgres base, list the tables/constraints of it and make a nice .jpeg file showing the data model out of it. All this would be automagical off course... Does such a beast exists ? Anything near ? Nico -- Administrateur Système/Réseau - GHS 38, rue du Texel 75014 Paris Tél : 01 43 21 16 66 - [EMAIL PROTECTED] - [EMAIL PROTECTED]
Re: Postgres graphing.
On Wed, Dec 12, 2001 at 15:50:23 +0100, Nicolas Bouthors wrote: I'm looking for a tool that would connect to a postgres base, list the tables/constraints of it and make a nice .jpeg file showing the data model out of it. All this would be automagical off course... http://freshmeat.net/projects/postgresql_autodoc/ looks like it, at least based on its description - haven't tried it myself. HTH, Ray -- Where do you want to go today? Confutatis maledictis, flammis acribus addictis.
Re: Traffic control with traffic shaper
--- Limiting Outgoing and Incoming Bandwidth in Linux (for 2.2+ Kernels) Brian Wilson - [EMAIL PROTECTED] - 12/5/2000 Overview The point of this document is to walk you through setting up bandwidth limiting for outgoing and incoming network packets under Linux 2.2.x+ kernel series. The limiting of the outgoing bandwidth is accomplished using the built-in QoS Class Based Queueing (CBQ) functions in the 2.2.x kernel. The limiting of the incoming bandwidth is accomplished using a stand-alone kernel module called rshaper. NOTE: rshaper also requires slight modififications to your network driver source code. Before You Begin You first need to download a few utilities. - iproute ftp://ftp.funet.fi/pub/mirrors/ftp.inr.ac.ru/ip-routing/iproute2-current.tar.gz (and if you wish to limit incoming traffic as well, you'll need rshaper) - rshaper ftp://ftp.prosa.it/pub/software/rshaper-1.07.tar.gz Installation You'll first need to configure your kernel for QoS and CBQ. This is accomplished under the Networking Options menu. Here you need to enable Routing Messages and the Kernel/User netlink socket. Next, under QoS and/or Fair Queueing menu, you need to enable all of the options. Below is the Networking Options portion of my kernel config. You should probably mimic this setup (unless you want to build them as modules). If you do choose to build them as modules, then you'll have to load all the specifc QoS modules (sch_cbq sch_tbf sch_sfq sch_prio cls_u32) after your machine boots (or allow them to be autoloaded). Since I don't like dealing with a slew of modules, I usually try to compile everything in staticly. * Packet socket [*] Kernel/User netlink socket [*] Routing messages * Netlink device emulation [*] Network firewalls [*] Socket Filtering * Unix domain sockets [*] TCP/IP networking [*] IP: multicasting [*] IP: advanced router [*] IP: policy routing [*] IP: equal cost multipath [*] IP: use TOS value as routing key [ ] IP: verbose route monitoring [ ] IP: large routing tables [*] IP: fast network address translation [ ] IP: kernel level autoconfiguration [*] IP: firewalling [ ] IP: firewall packet netlink device [*] IP: use FWMARK value as routing key [*] IP: masquerading --- Protocol-specific masquerading support will be built as modules. [*] IP: ICMP masquerading --- Protocol-specific masquerading support will be built as modules. [*] IP: masquerading special modules support * IP: ipautofw masq support (EXPERIMENTAL) * IP: ipportfw masq support (EXPERIMENTAL) * IP: ip fwmark masq-forwarding support (EXPERIMENTAL) [ ] IP: optimize as router not host IP: tunneling [*] IP: aliasing support [ ] IP: ARP daemon support (EXPERIMENTAL) [*] IP: TCP syncookie support (not enabled per default) --- (it is safe to leave these untouched) * IP: Reverse ARP [*] IP: Allow large windows (not recommended if 16Mb of memory) The IPv6 protocol (EXPERIMENTAL) --- The IPX protocol Appletalk DDP CCITT X.25 Packet Layer (EXPERIMENTAL) LAPB Data Link Driver (EXPERIMENTAL) [ ] Bridging (EXPERIMENTAL) [ ] 802.2 LLC (EXPERIMENTAL) Acorn Econet/AUN protocols (EXPERIMENTAL) WAN router [*] CPU is too slow to handle full bandwidth QoS and/or fair queueing --- [*] QoS and/or fair queueing * CBQ packet scheduler * CSZ packet scheduler * The simplest PRIO pseudoscheduler * RED queue * SFQ queue * TEQL queue * TBF queue [*] QoS support [*] Rate estimator [*] Packet classifier API * Routing table based classifier * Firewall based classifier * U32 classifier * Special RSVP classifier Special RSVP classifier for IPv6 [*] Ingres traffic policing While you are in the kernel config, if you have decided to use rshaper and limit incoming traffic, then go ahead and modularize your network device driver (if its not already a module). M Sun LANCE support Doing so will be helpful in modifying the driver and setting it up for
