ALTER SERVER(7) PostgreSQL 9.2.7 Documentation ALTER SERVER(7)NAME
ALTER_SERVER - change the definition of a foreign server
SYNOPSIS
ALTER SERVER name [ VERSION 'new_version' ]
[ OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] ) ]
ALTER SERVER name OWNER TO new_owner
ALTER SERVER name RENAME TO new_name
DESCRIPTION
ALTER SERVER changes the definition of a foreign server. The first form changes the server version string or the generic options of the
server (at least one clause is required). The second form changes the owner of the server.
To alter the server you must be the owner of the server. Additionally to alter the owner, you must own the server and also be a direct or
indirect member of the new owning role, and you must have USAGE privilege on the server's foreign-data wrapper. (Note that superusers
satisfy all these criteria automatically.)
PARAMETERS
name
The name of an existing server.
new_version
New server version.
OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] )
Change options for the server. ADD, SET, and DROP specify the action to be performed. ADD is assumed if no operation is explicitly
specified. Option names must be unique; names and values are also validated using the server's foreign-data wrapper library.
new_owner
The user name of the new owner of the foreign server.
new_name
The new name for the foreign server.
EXAMPLES
Alter server foo, add connection options:
ALTER SERVER foo OPTIONS (host 'foo', dbname 'foodb');
Alter server foo, change version, change host option:
ALTER SERVER foo VERSION '8.4' OPTIONS (SET host 'baz');
COMPATIBILITY
ALTER SERVER conforms to ISO/IEC 9075-9 (SQL/MED). The OWNER TO and RENAME forms are PostgreSQL extensions.
SEE ALSO
CREATE SERVER (CREATE_SERVER(7)), DROP SERVER (DROP_SERVER(7))
PostgreSQL 9.2.7 2014-02-17 ALTER SERVER(7)
Check Out this Related Man Page
DROP USER MAPPING(7) PostgreSQL 9.2.7 Documentation DROP USER MAPPING(7)NAME
DROP_USER_MAPPING - remove a user mapping for a foreign server
SYNOPSIS
DROP USER MAPPING [ IF EXISTS ] FOR { user_name | USER | CURRENT_USER | PUBLIC } SERVER server_name
DESCRIPTION
DROP USER MAPPING removes an existing user mapping from foreign server.
The owner of a foreign server can drop user mappings for that server for any user. Also, a user can drop a user mapping for his own user
name if USAGE privilege on the server has been granted to the user.
PARAMETERS
IF EXISTS
Do not throw an error if the user mapping does not exist. A notice is issued in this case.
user_name
User name of the mapping. CURRENT_USER and USER match the name of the current user. PUBLIC is used to match all present and future
user names in the system.
server_name
Server name of the user mapping.
EXAMPLES
Drop a user mapping bob, server foo if it exists:
DROP USER MAPPING IF EXISTS FOR bob SERVER foo;
COMPATIBILITY
DROP USER MAPPING conforms to ISO/IEC 9075-9 (SQL/MED). The IF EXISTS clause is a PostgreSQL extension.
SEE ALSO
CREATE USER MAPPING (CREATE_USER_MAPPING(7)), ALTER USER MAPPING (ALTER_USER_MAPPING(7))
PostgreSQL 9.2.7 2014-02-17 DROP USER MAPPING(7)
Hi ,
I a stuck with this problem. I am trying to execute this script1 on SERVER 1 from SERVER 2 using script2
script1 on SERVER 1
#!/usr/bin/ksh
/opt/perf/bin/glance -f -adviser_only -iterations 2 -maxpages 2 > /home/user/scripts/glance.op
cpuval1=`grep ^CPU... (4 Replies)
Hi all ,
Can u please help me in this. I tried to just login server through the below script
SERVER="Server_NAME"
USER="i am user"
PASSWD="mypassword"
ftp -in $SERVER<<EOF
user $USER $PASSWD
mkdir Chanakya #To create directory with my name in $HOME
ls > list
put list
bye... (5 Replies)
hi all,
My script :D is like this
ssh user@SERVER <<EOF
TODAY_DATE=`date '+%Y%m%d'`
echo $TODAY_DATE
EOF
but this variable have NULL value.
can any one help me how to resolve this?
Thanks,
Swat :eek: :confused: (3 Replies)
Hi all,
I have a file of around 300 lines in which string "SERVER" occurs around 32 times.
for eg.
I need to split files like, for eg
I am using this code
awk '/SERVER/{n++}{print > f n}' f=/vikas/list /vikas/final
But the problem is that it makes maximum of 10 files, but I... (12 Replies)
I want to manipulate files that are present on another server.
I tried telnet. I get the following error:
Connection to <hostname> closed by foreign host.
I need to do this through a KSH. Any help is appreciated!
Thanks,
Edison (6 Replies)
Hello,
the install routine puts automatically the servername "SERVER" in the symlink like:
hello.txt --> /SERVER/usr/lpp/hello.txt
world.txt --> /SERVER/usr/lpp/world.txt
... but i need to change this symlinks (without servername) to:
hello.txt --> /usr/lpp/hello.txt
world.txt -->... (3 Replies)
Hi all,
I cannot reach my SERVER from my NetBackup server connect through SERVER_prv ("cannot connect to client")
My SERVER was Sun OS 5.8, below is the message i get when i ping my SERVER:
# ping 192.168.X.X or
# ping SERVER_prv
ICMP Net Unreachable from gateway 172.16.102.XXX
for... (3 Replies)
Hi, I am currently working on 2 SPARC-ENTREPRISE T5220 (cluster servers), named SERVER 3A and SERVER 3B.
Both servers have their own Ip ADRESS and share 1 Virtual IP adress to share applications.......
Both servers are available , but can't communicate together right now. For example, from... (8 Replies)
What I want to do is to connect to a server A (connected to a public IP) and forward the FTP connexion to server B (Connected to another public IP).
CLIENT ==>Debian SERVER A===> Debian SERVER B with ProFTPD
Passive FTP uses two ports, 21 that carries the commands and any port from about... (5 Replies)
Hey All,
I am seeking for the script which will do as follows,
1) Login on one Unix server "Server1"
2) Want to access other Unix server "Server2", and want to get the information as, on one go.
df -k /tmp
df -k /
df -k "any file system"
3) Re-direct the output to "space.txt" on... (12 Replies)
I need a FTP SERVER program for using in ubuntu, Do you know any for free? ps: there will be no internet connection so, vsftp will not work. need a tool (like filezilla but filezilla has no server version for unix ubuntu) that has to be installation package to extract in it. (6 Replies)
I have a below command
ALTER TABLE `abc` ADD PARTITION ( PARTITION 20130613 VALUES less than (DAY('13')));
Below is requirement
It runs in Loop
as DAY start with 13 and end with 100 along with this of counter "20130613" also increases per command
as the next command should be
... (8 Replies)
hi,
i have a shellscipt that is in another server, my question is how do i run the script from a different server.
EXAMPLE:
SCRIPT_NAME: sample.sh
SERVER: A
what i wanted to achieve is to call that script from server B. Tried using ssh
ssh <username>@serverB /home/sample.sh
but... (5 Replies)
Hi Folks,
I have a requirement of file management on different servers.
Source Server is SERVER-A.
Two servers will fetch files from SERVER-A: SERVER1 and SERVER2.
4th SERVER is SERVER-B, It will fetch files from SERVER1. If SERVER1 goes DOWN, SERVER-B will fetch pending files from... (2 Replies)