fishScript.com d
Home| Progetto| Web| Faq| Acronimi

Argomenti

Documenti pubblicabili:1120
Scripts:1282
Documenti non pubblicabili:162
Categorie tematiche:68
.Net
   |_C#
   |_Visual basic.net
   |_Asp.net
Active Server Pages
C++
Cascade Style Sheet
JavaScript
Mysql
Php
Xml
Java
   |_Java 2 Micro Edition
   |_Java server pages
   |_Java Servlet
Oracle
   |_PLSQL
PostgreSQL
Unix








Basically, a web session can be defined as the timeframe in which a visitor navigates your web site.



XPath is a language for addressing parts of an XML document. It is designed to be used by XSLT and XPointer.

Basically, a web session can be defined as the timeframe in which a visitor navigates your web site.

PostgreSQL

Home >PostgreSQL > Postgres check database is Master or Replica

Stampa  Stampa


Ways to check if you are connected to a master or replica.

Use pg_is_in_recovery(); it returns true if replica.

On Master:
products=# SELECT pg_is_in_recovery(); pg_is_in_recovery ------------------- f (1 row)
On Replica:
products=# SELECT pg_is_in_recovery(); pg_is_in_recovery ------------------- t (1 row)
You can also query the Master view pg_stat_replication providing information and replica mode of connected slaves (potential,sync). On Master:
products=# select application_name, client_addr, sync_state from pg_stat_replication; application_name | client_addr | sync_state ------------------+----------------+------------ products3 | 172.22.100.127 | potential products2 | 172.22.100.120 | sync (3 rows)




Warning: include(ads/text468x15.html): failed to open stream: No such file or directory in D:\inetpub\webs\fishscriptcom\documents\view_document.php on line 131

Warning: include(): Failed opening 'ads/text468x15.html' for inclusion (include_path='.;C:\php\pear') in D:\inetpub\webs\fishscriptcom\documents\view_document.php on line 131

Tutorial
PostgreSQL determine database uptime   [PostgreSQL] 
Postgres check database is Master or Replica ways to check database replication role  [PostgreSQL] 
Ordering by highest or lowest value of multiple columns PostgreSQL functions in order by clause  [PostgreSQL] 
Posgresql how disable and renable foreign constraints forcing data into a table ignoring foreign keys (or trigger)  [PostgreSQL] 
Comandi
date and timestamp simple Using date and timestamp   [PostgreSQL] 
Add time to a date date function operation  [PostgreSQL] 
How set a default schema working away in your postgreSQL session  [PostgreSQL] 
postgres tip: how re-execute a query every n second a nice postgres shell command  [PostgreSQL] 
Grouping data by the week example date_trunc function, trimming days by the week  [PostgreSQL] 
How get PosgreSQL table size pg_total_relation_size function  [PostgreSQL] 
PostgreSQL determine database size pg_database_size function returns database size   [PostgreSQL] 
PostgreSQL enable autostart at reboot on Centos / Redhat Configure autostart after reboot  [PostgreSQL] 

signal Marco Magnani marcomagnani@fishscript.com



Cerca





A good scientist is a person with original ideas.
A good engineer is a person who makes a design that works with as few original ideas as possible. There are no prima donnas in engineering.
Freeman Dyson


A good scientist is a person with original ideas.
A good engineer is a person who makes a design that works with as few original ideas as possible. There are no prima donnas in engineering.
Freeman Dyson




Oracle... Definizioni: SCN





fishScript.Com is accessible by Mobile access technology as mobile phones, Palm and Pocket PC .

Nicoleta e Marco Magnani tutorial, examples, courses, esempi, corsi, esercizi, appunti vari Dottoressa Nicoleta Dragu Formatrice Docente Insegnante Mediatrice Culturale Dott. Marco Magnani Universita La Sapienza Roma Master Computer Science Hunter College New York , Data Base Administrator DBA oracle System architect

Last modified: 2017-11-30 amministratore@fishscript.comNico and Marco Magnani Software Production
Home|About this Site © 2003-2008 www.fishScript.com ®