Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

If somebody removed postmaster.pid file In postgreSql what will happened in postgres server ?

-
If somebody removed postmaster.pid file Server will be going to down becouse postgres server running based on postmaster.pid file so you need to start the server manually  after started the postgres server posmaster.pid file will be created automatically
[root@p1 data]# pwd
/opt/PostgreSQL/9.3/data[
root@p1 data]# mv postmaster.pid  /home/
mv: overwrite `/home/postmaster.pid'? y



bash-3.2$ pg_ctl -D /opt/PostgreSQL/9.3/data/ status
pg_ctl: no server running

after started the postgres server postmaster process id will be varried see below example first one is old postmaster.pid file next is new postmaster.pid file
Old Postmaster.pid file:
[root@p1 home]# cat postmaster.pid 
13750
/opt/PostgreSQL/9.3/data
1494571616
5432
/tmp
*
  5432001   3932161
New Postmaster.pid file After started postgres server:
[root@p1 data]# cat postmaster.pid
13957
/opt/PostgreSQL/9.3/data
1494572359
5432
/tmp
*
  5432001   3964929


Comments

Post a Comment

Popular posts from this blog

Pgbadger Feature In Postgresql

-
1. pgBadger reports everything about your SQL queries            Overall statistics            The most frequent waiting queries.            Queries that waited the most.            Queries generating the most temporary files.            Queries generating the largest temporary files.            The slowest queries.            Queries that took up the most time.            The most frequent queries.            The most frequent errors.            Histogram of query times.            Histogram of sessions times.            Users involved in top queries.            Applications involved in to...
Read more

ERROR: operator does not exist: text ->> unknown LINE 1: ...stomer' as customer_name,sales_info ->>'PRODUCTS' ->>'produc... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

-
postgres=# select * from sales; id | sales_info ----+---------------------------------------------------------------------------------- 1 | { "customer": "NIJAM", "PRODUCTS": {"product_name": "choclate","total_item": 6}} 2 | { "customer": "ABU", "PRODUCTS": {"product_name": "badam","total_item": 5}} 3 | { "customer": "UMAR", "PRODUCTS": {"product_name": "mobile","total_item": 1}} (3 rows) postgres=# SELECT sales_info ->>'customer' as customer_name,sales_info ->>'PRODUCTS' ->>'product_name' as name_of_product from sales where sales_info ->>'customer'='UMAR'; ERROR: operator does not exist: text ->> unknown LINE 1: ...stomer' as customer_name,sales_info -...
Read more

rman interview and scenario based questions and answer and also rman(backup and recovery) discussions panel

-
set 1 1.What is RMAN? Recovery Manager (RMAN) is a utility that can manage your entire Oracle backup and recovery activities. 2.What is the difference between using recovery catalog and control file?  When new incarnation happens, the old backup information in control file will be lost. It will be preserved in recovery catalog. In recovery catalog we can store scripts.  Recovery catalog is central and can have information of many databases. 3.Can we use same target database as catalog?      No, The recovery catalog should not reside in the target database (database should be backed up), because the database can’t be    recovered in the mounted state. 4.How do you know that how much RMAN task has been completed?    By querying v$rman_status or v$session_longops 5.From where list & report commands will get input? Both the commands command quering v$ and recovery catalog views. V$BACKUP_FILES or many of the recovery catalog views such as RC_...
Read more

PostgreSQL Enterprise Manager - PEM Monitoring Tools

-
Image
Database administration and management is required for any database on which there are continuous business transactions.  If databases across enterprises are not monitored and maintained, then such databases are vulnerable to disasters, which eventually brings downtime to missions-critical application and, of course, it will incur losses in the business. Data is now one of the key assets for running a business, globally. Hence, it is one of the major responsibilities of enterprises to invest in resources for database monitoring and management. There are many database management and monitoring tools available for proactive database monitoring. In this article, we will look at  PEM – “PostgreSQL Enterprise Manager” .Enterprise Manager, or PEM, is a graphical database management/monitoring tool that can help database administrators, system administrators, database developers, database managers, system architects, and performance analysts manage databases efficiently and proacti...
Read more

aireplay-ng

-
aireplay-ng -V (return code: 1) aireplay-ng: unrecognized option '--version' "aireplay-ng --help" for help. aireplay-ng -HELP (return code: 1) Aireplay-ng 1.2 rc4 - (C) 2006-2015 Thomas d'Otreppe http://www.aircrack-ng.org usage: aireplay-ng <options> <replay interface> Filter options: -b bssid : MAC address, Access Point -d dmac : MAC address, Destination -s smac : MAC address, Source -m len : minimum packet length -n len : maximum packet length -u type : frame control, type field -v subt : frame control, subtype field -t tods : frame control, To DS bit -f fromds : frame control, From DS bit -w iswep : frame control, WEP bit -D : disable AP detection Replay options: -x nbpps : number of packets per second -p fctrl : set frame control word (hex) -a bssid : set Access Point MAC address -c dmac : set D...
Read more