Hi guys, I wonder if someone would be able to assist with my problem. I have just set up a load balancer for a company I am working for. HTTP redirection is working fine, however they also want to load balance SSH and FTP too.
At the moment the perlbal config looks like;
However when I try to add SSH and FTP to this like so;
I get this error when I try and restart perlbal
Quote:
root@loadbalancer2:/home/hostingadmin# perlbal --daemon
ERROR: Can't start service 'sshbalancer' on 192.168.0.99:22: Error creating list ening socket: IO::Socket::INET: Address already in use
Error starting up.
I cant seem to find much documentation of perlbal on the net so I wondered if anyone on here may be able to assist me?
If you have two or more servers load balancing, are the servers mirroring one another? If images, etc., are uploaded, will they be stored on all the servers so that if one server goes down, the images will be served up by another server? (1 Reply)
The title speaks for itself. I have never attempted this but understand there is a way to use two network cards (en0 and en1) with the same IP address so as to load balance the traffic flow through both cards. Anyone know the answer? (4 Replies)
Is it possible to do a load balancing ( incoming and outgoing )with with IPMP in solaris 10 like sun trunking ? If yes what are the steps involved in it , i know how to do the failover IPMP both link based and probe based but i 'm looking for possible load balancing (3 Replies)
Hi All,
I have one webserver which has an application for a set of internal users can be accessed by _http://server1.com
I am planning to load balance this application. For that I have cloned this server and build a new one which can be accessed using _http://server2.com]Server2.com. Also i... (2 Replies)
Hi folks,
(Sorry I don't know what its technology is termed exactly. High Availability OR load balancing)
What I'm going to explore is as follows:-
For example, on Physical Servers;
Server-1 - LAMP, a working server
Server-2 - LAMP, for redundancy
While Server-1 is working all... (3 Replies)
Hi,
We have 2 pools of servers. Lets call them A and B and they would contain 2 servers each. Pool A will be hosting www.example.com/app/v1 and pool B will be hosting www.example.com/app/v2. Clients will be requesting right url (/v1 or /v2) but will be hitting just one IP.
I'd like to:
1)... (3 Replies)
Hi,
Currently we have 3 old and 3 new servers catering to Live traffic. As my component move from legacy interfaces to MQ one, we want to have load balancing of old interfaces available on MQ interface as well.
For this, we want to send only 30% of all MQ traffic on 3 OLD Live servers, and want... (1 Reply)
Hi,
I am working on development project where I have to migrate many jobs from Tidal to Autosys R11.
During this project we came across the following requirements.
1. There are 3 real machines. There could be many jobs activated simultaneously, but only one job should execute at a time and... (0 Replies)
Dear All,
Can any one help me for this request?
There is a case. I have 20 files which I need to FTP to 5 servers. I want to know if there is any possibility to make a load balancer which transfers files in round robin manner to 5 servers.
As per theoretical algorithm, what I think, flow can... (9 Replies)
Discussion started by: Zaib
9 Replies
LEARN ABOUT CENTOS
set_role
SET ROLE(7) PostgreSQL 9.2.7 Documentation SET ROLE(7)NAME
SET_ROLE - set the current user identifier of the current session
SYNOPSIS
SET [ SESSION | LOCAL ] ROLE role_name
SET [ SESSION | LOCAL ] ROLE NONE
RESET ROLE
DESCRIPTION
This command sets the current user identifier of the current SQL session to be role_name. The role name can be written as either an
identifier or a string literal. After SET ROLE, permissions checking for SQL commands is carried out as though the named role were the one
that had logged in originally.
The specified role_name must be a role that the current session user is a member of. (If the session user is a superuser, any role can be
selected.)
The SESSION and LOCAL modifiers act the same as for the regular SET(7) command.
The NONE and RESET forms reset the current user identifier to be the current session user identifier. These forms can be executed by any
user.
NOTES
Using this command, it is possible to either add privileges or restrict one's privileges. If the session user role has the INHERITS
attribute, then it automatically has all the privileges of every role that it could SET ROLE to; in this case SET ROLE effectively drops
all the privileges assigned directly to the session user and to the other roles it is a member of, leaving only the privileges available to
the named role. On the other hand, if the session user role has the NOINHERITS attribute, SET ROLE drops the privileges assigned directly
to the session user and instead acquires the privileges available to the named role.
In particular, when a superuser chooses to SET ROLE to a non-superuser role, she loses her superuser privileges.
SET ROLE has effects comparable to SET SESSION AUTHORIZATION (SET_SESSION_AUTHORIZATION(7)), but the privilege checks involved are quite
different. Also, SET SESSION AUTHORIZATION determines which roles are allowable for later SET ROLE commands, whereas changing roles with
SET ROLE does not change the set of roles allowed to a later SET ROLE.
SET ROLE does not process session variables as specified by the role's ALTER ROLE (ALTER_ROLE(7)) settings; this only happens during login.
SET ROLE cannot be used within a SECURITY DEFINER function.
EXAMPLES
SELECT SESSION_USER, CURRENT_USER;
session_user | current_user
--------------+--------------
peter | peter
SET ROLE 'paul';
SELECT SESSION_USER, CURRENT_USER;
session_user | current_user
--------------+--------------
peter | paul
COMPATIBILITY
PostgreSQL allows identifier syntax ("rolename"), while the SQL standard requires the role name to be written as a string literal. SQL does
not allow this command during a transaction; PostgreSQL does not make this restriction because there is no reason to. The SESSION and LOCAL
modifiers are a PostgreSQL extension, as is the RESET syntax.
SEE ALSO
SET SESSION AUTHORIZATION (SET_SESSION_AUTHORIZATION(7))
PostgreSQL 9.2.7 2014-02-17 SET ROLE(7)