If you have 6 app servers it's just daft to stick 6 NICs in your DB
server.
While there might be some cases where that makes sense most likely it
isn't something you would want to do. I believe the original motivation
was to solve bandwidth congestion rather than security.
The world rejoiced as [EMAIL PROTECTED] (Bryan Biggers) wrote:
> Can anyone tell me what the data file names with the .1 .2 .3
> etc. extensions are? Are these undo versions of my tables or
> something? I need to recover some disk space and I'm wondering if I
> need them. Here is an example...
> -r
There have been many comments about this already Kent. My $.02:
The most common practice I am aware of is to install 2 NIC's in each
appserver - one to your load balancer, and one to your private network
(192.168.*) where your database server sites. In fact, ideally your
database machine has no
On Tue, Oct 19, 2004 at 23:13:44 +0100,
Matt Clark <[EMAIL PROTECTED]> wrote:
>
> If you have 6 app servers it's just daft to stick 6 NICs in your DB
> server.
While there might be some cases where that makes sense most likely it
isn't something you would want to do. I believe the original mot
Switches are not security devices. While it is harder to sniff packets on
switches, you can't count on them to prevent hostile machines on the
switch from playing games with the arp protocol. Also I believe that if
a switch doesn't remember where a particular mac address is it will send
the packet
On Tue, Oct 19, 2004 at 17:37:43 +0100,
Matt Clark <[EMAIL PROTECTED]> wrote:
> You would assign a different subnet to the connection, and then tell the
> servers to connect to the PG server's address on that subnet. No other
> changes required. Very odd setup though. If you want a 'private'
>
On Tue, 19 Oct 2004, Bryan Biggers wrote:
> Can anyone tell me what the data file names with the .1 .2 .3 etc.
> extensions are? Are these undo versions of my tables or something? I
> need to recover some disk space and I'm wondering if I need them. Here
> is an example...
> -rw---1 postg
Bryan Biggers <[EMAIL PROTECTED]> writes:
> Can anyone tell me what the data file names with the .1 .2 .3 etc.
> extensions are? Are these undo versions of my tables or something? I
> need to recover some disk space and I'm wondering if I need them.
You will be very very unhappy if you remove th
while you weren't looking, Bryan Biggers wrote:
> Can anyone tell me what the data file names with the .1 .2 .3 etc.
> extensions are? Are these undo versions of my tables or something? I
> need to recover some disk space and I'm wondering if I need them.
Delete them at your peril.
Really quick
Can anyone tell me what the data file names with the .1 .2 .3 etc.
extensions are? Are these undo versions of my tables or something? I
need to recover some disk space and I'm wondering if I need them. Here
is an example...
-rw---1 postgres postgres 1073741824 Oct 18 20:01 19523580
-rw--
Hello Postgres User,
I'd have to say that functions have the same "function" in SQL as they do in any
language; a logical grouping of often repeated opperations.
So, if you have a repeated sequence like
query1(args);
if(result of query1 does this){
query2(args);
}
else{
query3(args);
}
then
True. I can't imagine a modern server room, even running windows, that
doesn't have a gigabit or fiber backbone for the servers.
Rick
Andrew Sullivan
My 2 pence.
I think it's not a big task. If the servers are located nearby, all you
need is.
Connect the two machines:
===
- get a crossover patch cable (Should be crossover - you can buy or make
one by googling instructions.)
- install one extra NIC on each machine
On Tue, Oct 19, 2004 at 12:11:20PM -0500, [EMAIL PROTECTED] wrote:
>
> Depends on the NIC. If your running 100MBS Ether and put in 1GBS Ether or
> fiber, it would make a difference.
Not if you're not using 100 megs in the first place :)
A
--
Andrew Sullivan | [EMAIL PROTECTED]
I remember whe
Peter Eisentraut wrote:
Am Freitag, 15. Oktober 2004 08:37 schrieb macdickson:
Can any one tell me how to store jpegh files in Postgres Database
Use the data type "bytea".
First, Sorry about my english.
I use the "lo" type (see contrib folder). This is similar to oid type,
but helps you
On Tue, Oct 19, 2004 at 11:02:31AM -0600, Scott Marlowe scratched on the wall:
> This is more a networking issue than a PostgreSQL one. What you'll like
> want to do is to set up a nic in each box and use a "rolled" cable
> directly between them
Actually, you want a "cross-over" cable, not a "r
Depends on the NIC. If your running 100MBS Ether and put in 1GBS Ether or
fiber, it would make a difference.
Rick
Andrew Sullivan
This is more a networking issue than a PostgreSQL one. What you'll like
want to do is to set up a nic in each box and use a "rolled" cable
directly between them. Assign an IP to each machine like 10.0.0.1 and
10.0.0.2 and edit your route tables to make each machine use those IPs
respectively to t
unsubscribe
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Title: Message
You
would assign a different subnet to the connection, and then tell the servers to
connect to the PG server's address on that subnet. No other changes
required. Very odd setup though. If you want a 'private' connection
then use a switch, rather than needing umpty NICs in t
On Tue, Oct 19, 2004 at 12:05:05PM -0400, Kent Anderson wrote:
> We are upgrading our servers and have run into an interesting situation. It
> has been proposed that we have a direct connection from the web servers to
> the postgres server via extra NICs.
> Before we even waste time installing th
We are upgrading our
servers and have run into an interesting situation. It has been proposed
that we have a direct connection from the web servers to the postgres
server via extra NICs. Has anyone done this before and how big a project would
it be to alter ASP and Java applications to make
Andrew Sullivan <[EMAIL PROTECTED]> writes:
>> LOG: unexpected EOF on client connection
> These are cases where the client has gone away without shutting down
> its connection properly. At the TCP timeout, the postmaster checks
> the client, discovers it isn't there, and shuts down the connectio
On Tue, Oct 19, 2004 at 01:14:10PM +1000, Ashley Maher wrote:
> My original post stated I'd had the postmaster stop without explanation.
> I now have log files. I can see nothing in messaegs or syslog of interest.
I agree there's not much there:
> LOG: unexpected EOF on client connection
> LOG:
What are the advantages to SQL Functions? I'm looking to optimize
'default' PostgreSQL environments for clients. I'm writing an
application and looking to put functions to optimize just that table,
etc. They don't want to have a full-time database admin (surprise!).
Thanks,
J
-
> Hello All,
>
> I'd like to know what I am doing wrong. I've installed the
> 7.5 win32 version of Postgres (love it...). I've entered the
> bin directory and loaded the plpgsql language on my database
> (works fine)...
>
> I have perl 5.6.1 installed as well and would like to load
> the plpe
26 matches
Mail list logo
