07-28-2016
I solved the problem by installing Zabbix with PostgreSQL
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi everybody,
I am currently setting up a web site for customers to place orders. Having placed the order the file will be downloaded onto the Unix server (SCO UNIX v 5.0.4). At this point I need to be able to monitor the system for the file being resident and if it is then perform an action on... (2 Replies)
Discussion started by: cookiejar
2 Replies
2. News, Links, Events and Announcements
If you haven't heard about this elsewhere, here is one link to the story. But here is a pdf file from IBM's website listing the patents. (5 Replies)
Discussion started by: Perderabo
5 Replies
3. Solaris
i am looking for a really good monitoring solftware for solaris .
i need it to be installed on a server and accessed from a client application on windows , with some nice GUI interfaces .
thanks (6 Replies)
Discussion started by: ppass
6 Replies
4. UNIX for Dummies Questions & Answers
hi
can i know if there is any GUI interface software to help in monitoring the network of the servers i have? something like a web pages or a stock pages when a processes is down, a red colour is flashes. best if it is free ;) (1 Reply)
Discussion started by: legato
1 Replies
5. AIX
Hi All,
im trying to find some older versions of software due to a problem that i'm having after upgrading.
namely.
devices.sdd.43.rte
ibm2105.rte version 32.6.100.18
devices.fcp.disk.ibm2105.rte version 32.6.100.18
devices.scsi.disk.ibm2105.rte version 32.6.100.18
Anyone any ideas... (0 Replies)
Discussion started by: djdavies
0 Replies
6. UNIX for Advanced & Expert Users
Guys,
I need a monitoring software for my Unix servers.
Over the last couple of years, the number has increased to well over 40 servers.
All have different applications running on them and it is impossible to go to everyone of them and do checks.
I was using Spotlight on Unix.
I was... (1 Reply)
Discussion started by: jair
1 Replies
7. AIX
Hi,
I want to know whether IBM AIX can be installed on the IBM e series and x series server hardware?
Thanks & Regards
Arun (2 Replies)
Discussion started by: Arun.Kakarla
2 Replies
8. AIX
Hi,
How to create new SNMP at aix configuration?
Can your share in this the step by step..
regards, (1 Reply)
Discussion started by: williamen
1 Replies
9. Infrastructure Monitoring
Hi All
We have a new site going live. with 80 switches , 10 servers
We have used nagios ,icinga,mrtg and others
what do users think is the best new software worth a look?
thanks
Richard (1 Reply)
Discussion started by: rdunne
1 Replies
10. AIX
Hi There,
I have zero information and zero knowledge for IBM virtual machine except Amazon cloud and VMware ESXi (Only Linux OS available).
Anyone could provide me the following answer -
Can IBM VM been deploy on X86 and X64 (Intel Chip)?
If answer is yes any chance to deploy AIX OS... (13 Replies)
Discussion started by: chenyung
13 Replies
CLOSE(7) PostgreSQL 9.2.7 Documentation CLOSE(7)
NAME
CLOSE - close a cursor
SYNOPSIS
CLOSE { name | ALL }
DESCRIPTION
CLOSE frees the resources associated with an open cursor. After the cursor is closed, no subsequent operations are allowed on it. A cursor
should be closed when it is no longer needed.
Every non-holdable open cursor is implicitly closed when a transaction is terminated by COMMIT or ROLLBACK. A holdable cursor is implicitly
closed if the transaction that created it aborts via ROLLBACK. If the creating transaction successfully commits, the holdable cursor
remains open until an explicit CLOSE is executed, or the client disconnects.
PARAMETERS
name
The name of an open cursor to close.
ALL
Close all open cursors.
NOTES
PostgreSQL does not have an explicit OPEN cursor statement; a cursor is considered open when it is declared. Use the DECLARE(7) statement
to declare a cursor.
You can see all available cursors by querying the pg_cursors system view.
If a cursor is closed after a savepoint which is later rolled back, the CLOSE is not rolled back; that is, the cursor remains closed.
EXAMPLES
Close the cursor liahona:
CLOSE liahona;
COMPATIBILITY
CLOSE is fully conforming with the SQL standard. CLOSE ALL is a PostgreSQL extension.
SEE ALSO
DECLARE(7), FETCH(7), MOVE(7)
PostgreSQL 9.2.7 2014-02-17 CLOSE(7)