Difference between revisions of "Help:PGAdmin4 with python"

From iDempiere en
m
Line 1: Line 1:
<html xmlns:o="urn:schemas-microsoft-com:office:office"
+
== PGADMIN4 ON UBUNTU 16.04 ==
xmlns:w="urn:schemas-microsoft-com:office:word"
 
xmlns:m="http://schemas.microsoft.com/office/2004/12/omml"
 
xmlns="http://www.w3.org/TR/REC-html40">
 
  
<head>
+
=== 1. Install
<meta name=Title content="">
 
<meta http-equiv=Content-Type content="text/html; charset=macintosh">
 
<meta name=ProgId content=Word.Document>
 
<meta name=Generator content="Microsoft Word 15">
 
<meta name=Originator content="Microsoft Word 15">
 
<link rel=File-List
 
href="UBUNTU%2016.04%20-%20PGAdmin4%20with%20python%20.fld/filelist.xml">
 
<!--[if gte mso 9]><xml>
 
<o:DocumentProperties>
 
  <o:Author>Usuario de Microsoft Office</o:Author>
 
  <o:LastAuthor>Usuario de Microsoft Office</o:LastAuthor>
 
  <o:Revision>2</o:Revision>
 
  <o:TotalTime>52</o:TotalTime>
 
  <o:Created>2018-04-08T09:29:00Z</o:Created>
 
  <o:LastSaved>2018-04-08T09:29:00Z</o:LastSaved>
 
  <o:Pages>5</o:Pages>
 
  <o:Words>1296</o:Words>
 
  <o:Characters>7134</o:Characters>
 
  <o:Paragraphs>es-ES</o:Paragraphs>
 
  <o:Lines>59</o:Lines>
 
  <o:Paragraphs>16</o:Paragraphs>
 
  <o:CharactersWithSpaces>8414</o:CharactersWithSpaces>
 
  <o:Version>15.0</o:Version>
 
</o:DocumentProperties>
 
</xml><![endif]-->
 
<link rel=themeData
 
href="UBUNTU%2016.04%20-%20PGAdmin4%20with%20python%20.fld/themedata.thmx">
 
<!--[if gte mso 9]><xml>
 
<w:WordDocument>
 
  <w:View>Print</w:View>
 
  <w:Zoom>130</w:Zoom>
 
  <w:SpellingState>Clean</w:SpellingState>
 
  <w:GrammarState>Clean</w:GrammarState>
 
  <w:TrackMoves>false</w:TrackMoves>
 
  <w:TrackFormatting/>
 
  <w:HyphenationZone>21</w:HyphenationZone>
 
  <w:PunctuationKerning/>
 
  <w:ValidateAgainstSchemas/>
 
  <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
 
  <w:IgnoreMixedContent>false</w:IgnoreMixedContent>
 
  <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
 
  <w:DoNotPromoteQF/>
 
  <w:LidThemeOther>ES-TRAD</w:LidThemeOther>
 
  <w:LidThemeAsian>X-NONE</w:LidThemeAsian>
 
  <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript>
 
  <w:Compatibility>
 
  <w:BreakWrappedTables/>
 
  <w:SnapToGridInCell/>
 
  <w:WrapTextWithPunct/>
 
  <w:UseAsianBreakRules/>
 
  <w:DontGrowAutofit/>
 
  <w:SplitPgBreakAndParaMark/>
 
  <w:EnableOpenTypeKerning/>
 
  <w:DontFlipMirrorIndents/>
 
  <w:OverrideTableStyleHps/>
 
  </w:Compatibility>
 
  <m:mathPr>
 
  <m:mathFont m:val="Cambria Math"/>
 
  <m:brkBin m:val="before"/>
 
  <m:brkBinSub m:val="&#45;-"/>
 
  <m:smallFrac m:val="off"/>
 
  <m:dispDef/>
 
  <m:lMargin m:val="0"/>
 
  <m:rMargin m:val="0"/>
 
  <m:defJc m:val="centerGroup"/>
 
  <m:wrapIndent m:val="1440"/>
 
  <m:intLim m:val="subSup"/>
 
  <m:naryLim m:val="undOvr"/>
 
  </m:mathPr></w:WordDocument>
 
</xml><![endif]--><!--[if gte mso 9]><xml>
 
<w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="false"
 
  DefSemiHidden="false" DefQFormat="false" DefPriority="99"
 
  LatentStyleCount="380">
 
  <w:LsdException Locked="false" Priority="0" QFormat="true" Name="Normal"/>
 
  <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 1"/>
 
  <w:LsdException Locked="false" Priority="9" SemiHidden="true"
 
  UnhideWhenUsed="true" QFormat="true" Name="heading 2"/>
 
  <w:LsdException Locked="false" Priority="9" SemiHidden="true"
 
  UnhideWhenUsed="true" QFormat="true" Name="heading 3"/>
 
  <w:LsdException Locked="false" Priority="9" SemiHidden="true"
 
  UnhideWhenUsed="true" QFormat="true" Name="heading 4"/>
 
  <w:LsdException Locked="false" Priority="9" SemiHidden="true"
 
  UnhideWhenUsed="true" QFormat="true" Name="heading 5"/>
 
  <w:LsdException Locked="false" Priority="9" SemiHidden="true"
 
  UnhideWhenUsed="true" QFormat="true" Name="heading 6"/>
 
  <w:LsdException Locked="false" Priority="9" SemiHidden="true"
 
  UnhideWhenUsed="true" QFormat="true" Name="heading 7"/>
 
  <w:LsdException Locked="false" Priority="9" SemiHidden="true"
 
  UnhideWhenUsed="true" QFormat="true" Name="heading 8"/>
 
  <w:LsdException Locked="false" Priority="9" SemiHidden="true"
 
  UnhideWhenUsed="true" QFormat="true" Name="heading 9"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="index 1"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="index 2"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="index 3"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="index 4"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="index 5"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="index 6"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="index 7"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="index 8"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="index 9"/>
 
  <w:LsdException Locked="false" Priority="39" SemiHidden="true"
 
  UnhideWhenUsed="true" Name="toc 1"/>
 
  <w:LsdException Locked="false" Priority="39" SemiHidden="true"
 
  UnhideWhenUsed="true" Name="toc 2"/>
 
  <w:LsdException Locked="false" Priority="39" SemiHidden="true"
 
  UnhideWhenUsed="true" Name="toc 3"/>
 
  <w:LsdException Locked="false" Priority="39" SemiHidden="true"
 
  UnhideWhenUsed="true" Name="toc 4"/>
 
  <w:LsdException Locked="false" Priority="39" SemiHidden="true"
 
  UnhideWhenUsed="true" Name="toc 5"/>
 
  <w:LsdException Locked="false" Priority="39" SemiHidden="true"
 
  UnhideWhenUsed="true" Name="toc 6"/>
 
  <w:LsdException Locked="false" Priority="39" SemiHidden="true"
 
  UnhideWhenUsed="true" Name="toc 7"/>
 
  <w:LsdException Locked="false" Priority="39" SemiHidden="true"
 
  UnhideWhenUsed="true" Name="toc 8"/>
 
  <w:LsdException Locked="false" Priority="39" SemiHidden="true"
 
  UnhideWhenUsed="true" Name="toc 9"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Normal Indent"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="footnote text"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="annotation text"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="header"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="footer"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="index heading"/>
 
  <w:LsdException Locked="false" Priority="35" SemiHidden="true"
 
  UnhideWhenUsed="true" QFormat="true" Name="caption"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="table of figures"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="envelope address"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="envelope return"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="footnote reference"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="annotation reference"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="line number"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="page number"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="endnote reference"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="endnote text"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="table of authorities"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="macro"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="toa heading"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="List"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="List Bullet"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="List Number"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="List 2"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="List 3"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="List 4"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="List 5"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="List Bullet 2"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="List Bullet 3"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="List Bullet 4"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="List Bullet 5"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="List Number 2"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="List Number 3"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="List Number 4"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="List Number 5"/>
 
  <w:LsdException Locked="false" Priority="10" QFormat="true" Name="Title"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Closing"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Signature"/>
 
  <w:LsdException Locked="false" Priority="1" SemiHidden="true"
 
  UnhideWhenUsed="true" Name="Default Paragraph Font"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Body Text"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Body Text Indent"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="List Continue"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="List Continue 2"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="List Continue 3"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="List Continue 4"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="List Continue 5"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Message Header"/>
 
  <w:LsdException Locked="false" Priority="11" QFormat="true" Name="Subtitle"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Salutation"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Date"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Body Text First Indent"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Body Text First Indent 2"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Note Heading"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Body Text 2"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Body Text 3"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Body Text Indent 2"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Body Text Indent 3"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Block Text"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Hyperlink"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="FollowedHyperlink"/>
 
  <w:LsdException Locked="false" Priority="22" QFormat="true" Name="Strong"/>
 
  <w:LsdException Locked="false" Priority="20" QFormat="true" Name="Emphasis"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Document Map"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Plain Text"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="E-mail Signature"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="HTML Top of Form"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="HTML Bottom of Form"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Normal (Web)"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="HTML Acronym"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="HTML Address"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="HTML Cite"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="HTML Code"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="HTML Definition"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="HTML Keyboard"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="HTML Preformatted"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="HTML Sample"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="HTML Typewriter"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="HTML Variable"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Normal Table"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="annotation subject"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="No List"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Outline List 1"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Outline List 2"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Outline List 3"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table Simple 1"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table Simple 2"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table Simple 3"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table Classic 1"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table Classic 2"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table Classic 3"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table Classic 4"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table Colorful 1"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table Colorful 2"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table Colorful 3"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table Columns 1"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table Columns 2"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table Columns 3"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table Columns 4"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table Columns 5"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table Grid 1"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table Grid 2"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table Grid 3"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table Grid 4"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table Grid 5"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table Grid 6"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table Grid 7"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table Grid 8"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table List 1"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table List 2"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table List 3"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table List 4"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table List 5"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table List 6"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table List 7"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table List 8"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table 3D effects 1"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table 3D effects 2"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table 3D effects 3"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table Contemporary"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table Elegant"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table Professional"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table Subtle 1"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table Subtle 2"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table Web 1"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table Web 2"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table Web 3"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Balloon Text"/>
 
  <w:LsdException Locked="false" Priority="39" Name="Table Grid"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Table Theme"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Note Level 1"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Note Level 2"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Note Level 3"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Note Level 4"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Note Level 5"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Note Level 6"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Note Level 7"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Note Level 8"/>
 
  <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
 
  Name="Note Level 9"/>
 
  <w:LsdException Locked="false" SemiHidden="true" Name="Placeholder Text"/>
 
  <w:LsdException Locked="false" Priority="1" QFormat="true" Name="No Spacing"/>
 
  <w:LsdException Locked="false" Priority="60" Name="Light Shading"/>
 
  <w:LsdException Locked="false" Priority="61" Name="Light List"/>
 
  <w:LsdException Locked="false" Priority="62" Name="Light Grid"/>
 
  <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1"/>
 
  <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2"/>
 
  <w:LsdException Locked="false" Priority="65" Name="Medium List 1"/>
 
  <w:LsdException Locked="false" Priority="66" Name="Medium List 2"/>
 
  <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1"/>
 
  <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2"/>
 
  <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3"/>
 
  <w:LsdException Locked="false" Priority="70" Name="Dark List"/>
 
  <w:LsdException Locked="false" Priority="71" Name="Colorful Shading"/>
 
  <w:LsdException Locked="false" Priority="72" Name="Colorful List"/>
 
  <w:LsdException Locked="false" Priority="73" Name="Colorful Grid"/>
 
  <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 1"/>
 
  <w:LsdException Locked="false" Priority="61" Name="Light List Accent 1"/>
 
  <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 1"/>
 
  <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 1"/>
 
  <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 1"/>
 
  <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 1"/>
 
  <w:LsdException Locked="false" SemiHidden="true" Name="Revision"/>
 
  <w:LsdException Locked="false" Priority="34" QFormat="true"
 
  Name="List Paragraph"/>
 
  <w:LsdException Locked="false" Priority="29" QFormat="true" Name="Quote"/>
 
  <w:LsdException Locked="false" Priority="30" QFormat="true"
 
  Name="Intense Quote"/>
 
  <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 1"/>
 
  <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 1"/>
 
  <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 1"/>
 
  <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 1"/>
 
  <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 1"/>
 
  <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 1"/>
 
  <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 1"/>
 
  <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 1"/>
 
  <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 2"/>
 
  <w:LsdException Locked="false" Priority="61" Name="Light List Accent 2"/>
 
  <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 2"/>
 
  <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 2"/>
 
  <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 2"/>
 
  <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 2"/>
 
  <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 2"/>
 
  <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 2"/>
 
  <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 2"/>
 
  <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 2"/>
 
  <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 2"/>
 
  <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 2"/>
 
  <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 2"/>
 
  <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 2"/>
 
  <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 3"/>
 
  <w:LsdException Locked="false" Priority="61" Name="Light List Accent 3"/>
 
  <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 3"/>
 
  <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 3"/>
 
  <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 3"/>
 
  <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 3"/>
 
  <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 3"/>
 
  <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 3"/>
 
  <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 3"/>
 
  <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 3"/>
 
  <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 3"/>
 
  <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 3"/>
 
  <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 3"/>
 
  <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 3"/>
 
  <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 4"/>
 
  <w:LsdException Locked="false" Priority="61" Name="Light List Accent 4"/>
 
  <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 4"/>
 
  <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 4"/>
 
  <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 4"/>
 
  <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 4"/>
 
  <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 4"/>
 
  <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 4"/>
 
  <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 4"/>
 
  <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 4"/>
 
  <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 4"/>
 
  <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 4"/>
 
  <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 4"/>
 
  <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 4"/>
 
  <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 5"/>
 
  <w:LsdException Locked="false" Priority="61" Name="Light List Accent 5"/>
 
  <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 5"/>
 
  <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 5"/>
 
  <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 5"/>
 
  <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 5"/>
 
  <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 5"/>
 
  <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 5"/>
 
  <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 5"/>
 
  <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 5"/>
 
  <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 5"/>
 
  <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 5"/>
 
  <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 5"/>
 
  <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 5"/>
 
  <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 6"/>
 
  <w:LsdException Locked="false" Priority="61" Name="Light List Accent 6"/>
 
  <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 6"/>
 
  <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 6"/>
 
  <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 6"/>
 
  <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 6"/>
 
  <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 6"/>
 
  <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 6"/>
 
  <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 6"/>
 
  <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 6"/>
 
  <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 6"/>
 
  <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 6"/>
 
  <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 6"/>
 
  <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 6"/>
 
  <w:LsdException Locked="false" Priority="19" QFormat="true"
 
  Name="Subtle Emphasis"/>
 
  <w:LsdException Locked="false" Priority="21" QFormat="true"
 
  Name="Intense Emphasis"/>
 
  <w:LsdException Locked="false" Priority="31" QFormat="true"
 
  Name="Subtle Reference"/>
 
  <w:LsdException Locked="false" Priority="32" QFormat="true"
 
  Name="Intense Reference"/>
 
  <w:LsdException Locked="false" Priority="33" QFormat="true" Name="Book Title"/>
 
  <w:LsdException Locked="false" Priority="37" SemiHidden="true"
 
  UnhideWhenUsed="true" Name="Bibliography"/>
 
  <w:LsdException Locked="false" Priority="39" SemiHidden="true"
 
  UnhideWhenUsed="true" QFormat="true" Name="TOC Heading"/>
 
  <w:LsdException Locked="false" Priority="41" Name="Plain Table 1"/>
 
  <w:LsdException Locked="false" Priority="42" Name="Plain Table 2"/>
 
  <w:LsdException Locked="false" Priority="43" Name="Plain Table 3"/>
 
  <w:LsdException Locked="false" Priority="44" Name="Plain Table 4"/>
 
  <w:LsdException Locked="false" Priority="45" Name="Plain Table 5"/>
 
  <w:LsdException Locked="false" Priority="40" Name="Grid Table Light"/>
 
  <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light"/>
 
  <w:LsdException Locked="false" Priority="47" Name="Grid Table 2"/>
 
  <w:LsdException Locked="false" Priority="48" Name="Grid Table 3"/>
 
  <w:LsdException Locked="false" Priority="49" Name="Grid Table 4"/>
 
  <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark"/>
 
  <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful"/>
 
  <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful"/>
 
  <w:LsdException Locked="false" Priority="46"
 
  Name="Grid Table 1 Light Accent 1"/>
 
  <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 1"/>
 
  <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 1"/>
 
  <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 1"/>
 
  <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 1"/>
 
  <w:LsdException Locked="false" Priority="51"
 
  Name="Grid Table 6 Colorful Accent 1"/>
 
  <w:LsdException Locked="false" Priority="52"
 
  Name="Grid Table 7 Colorful Accent 1"/>
 
  <w:LsdException Locked="false" Priority="46"
 
  Name="Grid Table 1 Light Accent 2"/>
 
  <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 2"/>
 
  <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 2"/>
 
  <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 2"/>
 
  <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 2"/>
 
  <w:LsdException Locked="false" Priority="51"
 
  Name="Grid Table 6 Colorful Accent 2"/>
 
  <w:LsdException Locked="false" Priority="52"
 
  Name="Grid Table 7 Colorful Accent 2"/>
 
  <w:LsdException Locked="false" Priority="46"
 
  Name="Grid Table 1 Light Accent 3"/>
 
  <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 3"/>
 
  <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 3"/>
 
  <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 3"/>
 
  <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 3"/>
 
  <w:LsdException Locked="false" Priority="51"
 
  Name="Grid Table 6 Colorful Accent 3"/>
 
  <w:LsdException Locked="false" Priority="52"
 
  Name="Grid Table 7 Colorful Accent 3"/>
 
  <w:LsdException Locked="false" Priority="46"
 
  Name="Grid Table 1 Light Accent 4"/>
 
  <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 4"/>
 
  <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 4"/>
 
  <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 4"/>
 
  <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 4"/>
 
  <w:LsdException Locked="false" Priority="51"
 
  Name="Grid Table 6 Colorful Accent 4"/>
 
  <w:LsdException Locked="false" Priority="52"
 
  Name="Grid Table 7 Colorful Accent 4"/>
 
  <w:LsdException Locked="false" Priority="46"
 
  Name="Grid Table 1 Light Accent 5"/>
 
  <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 5"/>
 
  <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 5"/>
 
  <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 5"/>
 
  <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 5"/>
 
  <w:LsdException Locked="false" Priority="51"
 
  Name="Grid Table 6 Colorful Accent 5"/>
 
  <w:LsdException Locked="false" Priority="52"
 
  Name="Grid Table 7 Colorful Accent 5"/>
 
  <w:LsdException Locked="false" Priority="46"
 
  Name="Grid Table 1 Light Accent 6"/>
 
  <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 6"/>
 
  <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 6"/>
 
  <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 6"/>
 
  <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 6"/>
 
  <w:LsdException Locked="false" Priority="51"
 
  Name="Grid Table 6 Colorful Accent 6"/>
 
  <w:LsdException Locked="false" Priority="52"
 
  Name="Grid Table 7 Colorful Accent 6"/>
 
  <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light"/>
 
  <w:LsdException Locked="false" Priority="47" Name="List Table 2"/>
 
  <w:LsdException Locked="false" Priority="48" Name="List Table 3"/>
 
  <w:LsdException Locked="false" Priority="49" Name="List Table 4"/>
 
  <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark"/>
 
  <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful"/>
 
  <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful"/>
 
  <w:LsdException Locked="false" Priority="46"
 
  Name="List Table 1 Light Accent 1"/>
 
  <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 1"/>
 
  <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 1"/>
 
  <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 1"/>
 
  <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 1"/>
 
  <w:LsdException Locked="false" Priority="51"
 
  Name="List Table 6 Colorful Accent 1"/>
 
  <w:LsdException Locked="false" Priority="52"
 
  Name="List Table 7 Colorful Accent 1"/>
 
  <w:LsdException Locked="false" Priority="46"
 
  Name="List Table 1 Light Accent 2"/>
 
  <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 2"/>
 
  <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 2"/>
 
  <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 2"/>
 
  <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 2"/>
 
  <w:LsdException Locked="false" Priority="51"
 
  Name="List Table 6 Colorful Accent 2"/>
 
  <w:LsdException Locked="false" Priority="52"
 
  Name="List Table 7 Colorful Accent 2"/>
 
  <w:LsdException Locked="false" Priority="46"
 
  Name="List Table 1 Light Accent 3"/>
 
  <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 3"/>
 
  <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 3"/>
 
  <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 3"/>
 
  <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 3"/>
 
  <w:LsdException Locked="false" Priority="51"
 
  Name="List Table 6 Colorful Accent 3"/>
 
  <w:LsdException Locked="false" Priority="52"
 
  Name="List Table 7 Colorful Accent 3"/>
 
  <w:LsdException Locked="false" Priority="46"
 
  Name="List Table 1 Light Accent 4"/>
 
  <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 4"/>
 
  <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 4"/>
 
  <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 4"/>
 
  <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 4"/>
 
  <w:LsdException Locked="false" Priority="51"
 
  Name="List Table 6 Colorful Accent 4"/>
 
  <w:LsdException Locked="false" Priority="52"
 
  Name="List Table 7 Colorful Accent 4"/>
 
  <w:LsdException Locked="false" Priority="46"
 
  Name="List Table 1 Light Accent 5"/>
 
  <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 5"/>
 
  <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 5"/>
 
  <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 5"/>
 
  <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 5"/>
 
  <w:LsdException Locked="false" Priority="51"
 
  Name="List Table 6 Colorful Accent 5"/>
 
  <w:LsdException Locked="false" Priority="52"
 
  Name="List Table 7 Colorful Accent 5"/>
 
  <w:LsdException Locked="false" Priority="46"
 
  Name="List Table 1 Light Accent 6"/>
 
  <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 6"/>
 
  <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 6"/>
 
  <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 6"/>
 
  <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 6"/>
 
  <w:LsdException Locked="false" Priority="51"
 
  Name="List Table 6 Colorful Accent 6"/>
 
  <w:LsdException Locked="false" Priority="52"
 
  Name="List Table 7 Colorful Accent 6"/>
 
</w:LatentStyles>
 
</xml><![endif]-->
 
<style>
 
<!--
 
/* Font Definitions */
 
@font-face
 
{font-family:Arial;
 
panose-1:2 11 6 4 2 2 2 2 2 4;
 
mso-font-charset:0;
 
mso-generic-font-family:auto;
 
mso-font-pitch:variable;
 
mso-font-signature:-536859905 -1073711037 9 0 511 0;}
 
@font-face
 
{font-family:"Courier New";
 
panose-1:2 7 3 9 2 2 5 2 4 4;
 
mso-font-charset:0;
 
mso-generic-font-family:auto;
 
mso-font-pitch:variable;
 
mso-font-signature:-536859905 -1073711037 9 0 511 0;}
 
@font-face
 
{font-family:Times;
 
panose-1:0 0 5 0 0 0 0 2 0 0;
 
mso-font-charset:0;
 
mso-generic-font-family:auto;
 
mso-font-pitch:variable;
 
mso-font-signature:-536870145 1342185562 0 0 415 0;}
 
@font-face
 
{font-family:Wingdings;
 
panose-1:5 0 0 0 0 0 0 0 0 0;
 
mso-font-charset:2;
 
mso-generic-font-family:auto;
 
mso-font-pitch:variable;
 
mso-font-signature:0 268435456 0 0 -2147483648 0;}
 
@font-face
 
{font-family:Mangal;
 
panose-1:0 0 0 0 0 0 0 0 0 0;
 
mso-font-charset:1;
 
mso-generic-font-family:roman;
 
mso-font-format:other;
 
mso-font-pitch:variable;
 
mso-font-signature:8192 0 0 0 0 0;}
 
@font-face
 
{font-family:"Cambria Math";
 
panose-1:2 4 5 3 5 4 6 3 2 4;
 
mso-font-charset:0;
 
mso-generic-font-family:auto;
 
mso-font-pitch:variable;
 
mso-font-signature:-536870145 1107305727 0 0 415 0;}
 
@font-face
 
{font-family:"Liberation Serif";
 
mso-font-alt:"Times New Roman";
 
mso-font-charset:128;
 
mso-generic-font-family:roman;
 
mso-font-pitch:variable;
 
mso-font-signature:0 0 0 0 0 0;}
 
@font-face
 
{font-family:"Liberation Sans";
 
mso-font-alt:Arial;
 
mso-font-charset:128;
 
mso-generic-font-family:swiss;
 
mso-font-pitch:variable;
 
mso-font-signature:0 0 0 0 0 0;}
 
@font-face
 
{font-family:"Noto Sans CJK SC Regular";
 
panose-1:0 0 0 0 0 0 0 0 0 0;
 
mso-font-charset:0;
 
mso-generic-font-family:roman;
 
mso-font-format:other;
 
mso-font-pitch:auto;
 
mso-font-signature:0 0 0 0 0 0;}
 
@font-face
 
{font-family:FreeSans;
 
panose-1:0 0 0 0 0 0 0 0 0 0;
 
mso-font-alt:"Times New Roman";
 
mso-font-charset:0;
 
mso-generic-font-family:roman;
 
mso-font-format:other;
 
mso-font-pitch:auto;
 
mso-font-signature:0 0 0 0 0 0;}
 
@font-face
 
{font-family:"Liberation Mono";
 
mso-font-alt:"Courier New";
 
mso-font-charset:1;
 
mso-generic-font-family:modern;
 
mso-font-pitch:fixed;
 
mso-font-signature:0 0 0 0 0 0;}
 
@font-face
 
{font-family:inherit;
 
mso-font-alt:"Times New Roman";
 
mso-font-charset:1;
 
mso-generic-font-family:auto;
 
mso-font-pitch:auto;
 
mso-font-signature:0 0 0 0 0 0;}
 
@font-face
 
{font-family:"Consolas\;Menlo\;Monaco\;Lucida Co";
 
panose-1:0 0 0 0 0 0 0 0 0 0;
 
mso-font-alt:"Times New Roman";
 
mso-font-charset:0;
 
mso-generic-font-family:roman;
 
mso-font-format:other;
 
mso-font-pitch:auto;
 
mso-font-signature:0 0 0 0 0 0;}
 
@font-face
 
{font-family:Menlo;
 
panose-1:2 11 6 9 3 8 4 2 2 4;
 
mso-font-charset:0;
 
mso-generic-font-family:auto;
 
mso-font-pitch:variable;
 
mso-font-signature:-436198657 -771687941 33554472 0 479 0;}
 
@font-face
 
{font-family:"Playfair Display";
 
panose-1:0 0 0 0 0 0 0 0 0 0;
 
mso-font-alt:"Times New Roman";
 
mso-font-charset:0;
 
mso-generic-font-family:roman;
 
mso-font-format:other;
 
mso-font-pitch:auto;
 
mso-font-signature:0 0 0 0 0 0;}
 
/* Style Definitions */
 
p.MsoNormal, li.MsoNormal, div.MsoNormal
 
{mso-style-unhide:no;
 
mso-style-qformat:yes;
 
mso-style-parent:"";
 
margin:0cm;
 
margin-bottom:.0001pt;
 
mso-pagination:widow-orphan;
 
font-size:12.0pt;
 
font-family:"Liberation Serif","serif";
 
mso-fareast-font-family:"Noto Sans CJK SC Regular";
 
mso-hansi-font-family:"Liberation Serif";
 
mso-bidi-font-family:FreeSans;
 
mso-ansi-language:ES;
 
mso-fareast-language:ZH-CN;
 
mso-bidi-language:HI;}
 
h1
 
{mso-style-unhide:no;
 
mso-style-qformat:yes;
 
mso-style-parent:Heading;
 
mso-style-next:"Texto independiente";
 
margin-top:12.0pt;
 
margin-right:0cm;
 
margin-bottom:6.0pt;
 
margin-left:0cm;
 
mso-pagination:widow-orphan;
 
page-break-after:avoid;
 
mso-outline-level:1;
 
font-size:24.0pt;
 
font-family:"Liberation Serif","serif";
 
mso-fareast-font-family:"Noto Sans CJK SC Regular";
 
mso-hansi-font-family:"Liberation Serif";
 
mso-bidi-font-family:FreeSans;
 
mso-font-kerning:0pt;
 
mso-ansi-language:ES;
 
mso-fareast-language:ZH-CN;
 
mso-bidi-language:HI;
 
font-weight:bold;}
 
h2
 
{mso-style-priority:9;
 
mso-style-unhide:no;
 
mso-style-qformat:yes;
 
mso-style-parent:Heading;
 
mso-style-link:"T’tulo 2 Car";
 
mso-style-next:"Texto independiente";
 
margin-top:10.0pt;
 
margin-right:0cm;
 
margin-bottom:6.0pt;
 
margin-left:0cm;
 
mso-pagination:widow-orphan;
 
page-break-after:avoid;
 
mso-outline-level:2;
 
font-size:18.0pt;
 
font-family:"Liberation Serif","serif";
 
mso-fareast-font-family:"Noto Sans CJK SC Regular";
 
mso-hansi-font-family:"Liberation Serif";
 
mso-bidi-font-family:FreeSans;
 
mso-ansi-language:ES;
 
mso-fareast-language:ZH-CN;
 
mso-bidi-language:HI;
 
font-weight:bold;}
 
h3
 
{mso-style-unhide:no;
 
mso-style-qformat:yes;
 
mso-style-parent:Heading;
 
mso-style-next:"Texto independiente";
 
margin-top:7.0pt;
 
margin-right:0cm;
 
margin-bottom:6.0pt;
 
margin-left:0cm;
 
mso-pagination:widow-orphan;
 
page-break-after:avoid;
 
mso-outline-level:3;
 
font-size:14.0pt;
 
font-family:"Liberation Serif","serif";
 
mso-fareast-font-family:"Noto Sans CJK SC Regular";
 
mso-hansi-font-family:"Liberation Serif";
 
mso-bidi-font-family:FreeSans;
 
mso-ansi-language:ES;
 
mso-fareast-language:ZH-CN;
 
mso-bidi-language:HI;
 
font-weight:bold;}
 
p.MsoCaption, li.MsoCaption, div.MsoCaption
 
{mso-style-unhide:no;
 
mso-style-qformat:yes;
 
margin-top:6.0pt;
 
margin-right:0cm;
 
margin-bottom:6.0pt;
 
margin-left:0cm;
 
mso-pagination:widow-orphan no-line-numbers;
 
font-size:12.0pt;
 
font-family:"Liberation Serif","serif";
 
mso-fareast-font-family:"Noto Sans CJK SC Regular";
 
mso-hansi-font-family:"Liberation Serif";
 
mso-bidi-font-family:FreeSans;
 
mso-ansi-language:ES;
 
mso-fareast-language:ZH-CN;
 
mso-bidi-language:HI;
 
font-style:italic;}
 
p.MsoList, li.MsoList, div.MsoList
 
{mso-style-unhide:no;
 
mso-style-parent:"Texto independiente";
 
margin-top:0cm;
 
margin-right:0cm;
 
margin-bottom:7.0pt;
 
margin-left:0cm;
 
line-height:120%;
 
mso-pagination:widow-orphan;
 
font-size:12.0pt;
 
font-family:"Liberation Serif","serif";
 
mso-fareast-font-family:"Noto Sans CJK SC Regular";
 
mso-hansi-font-family:"Liberation Serif";
 
mso-bidi-font-family:FreeSans;
 
mso-ansi-language:ES;
 
mso-fareast-language:ZH-CN;
 
mso-bidi-language:HI;}
 
p.MsoBodyText, li.MsoBodyText, div.MsoBodyText
 
{mso-style-unhide:no;
 
margin-top:0cm;
 
margin-right:0cm;
 
margin-bottom:7.0pt;
 
margin-left:0cm;
 
line-height:120%;
 
mso-pagination:widow-orphan;
 
font-size:12.0pt;
 
font-family:"Liberation Serif","serif";
 
mso-fareast-font-family:"Noto Sans CJK SC Regular";
 
mso-hansi-font-family:"Liberation Serif";
 
mso-bidi-font-family:FreeSans;
 
mso-ansi-language:ES;
 
mso-fareast-language:ZH-CN;
 
mso-bidi-language:HI;}
 
a:link, span.MsoHyperlink
 
{mso-style-noshow:yes;
 
mso-style-priority:99;
 
color:blue;
 
text-decoration:underline;
 
text-underline:single;}
 
a:visited, span.MsoHyperlinkFollowed
 
{mso-style-noshow:yes;
 
mso-style-priority:99;
 
color:#954F72;
 
mso-themecolor:followedhyperlink;
 
text-decoration:underline;
 
text-underline:single;}
 
p
 
{mso-style-noshow:yes;
 
mso-style-priority:99;
 
mso-margin-top-alt:auto;
 
margin-right:0cm;
 
mso-margin-bottom-alt:auto;
 
margin-left:0cm;
 
mso-pagination:widow-orphan;
 
font-size:12.0pt;
 
font-family:"Times New Roman";
 
mso-fareast-font-family:"Noto Sans CJK SC Regular";}
 
pre
 
{mso-style-noshow:yes;
 
mso-style-priority:99;
 
mso-style-link:"HTML con formato previo Car";
 
margin:0cm;
 
margin-bottom:.0001pt;
 
mso-pagination:widow-orphan;
 
tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;
 
font-size:10.0pt;
 
font-family:"Courier New";
 
mso-fareast-font-family:"Noto Sans CJK SC Regular";}
 
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
 
{mso-style-priority:34;
 
mso-style-unhide:no;
 
mso-style-qformat:yes;
 
margin-top:0cm;
 
margin-right:0cm;
 
margin-bottom:0cm;
 
margin-left:36.0pt;
 
margin-bottom:.0001pt;
 
mso-add-space:auto;
 
mso-pagination:widow-orphan;
 
font-size:12.0pt;
 
mso-bidi-font-size:10.5pt;
 
font-family:"Liberation Serif","serif";
 
mso-fareast-font-family:"Noto Sans CJK SC Regular";
 
mso-hansi-font-family:"Liberation Serif";
 
mso-bidi-font-family:Mangal;
 
mso-ansi-language:ES;
 
mso-fareast-language:ZH-CN;
 
mso-bidi-language:HI;}
 
p.MsoListParagraphCxSpFirst, li.MsoListParagraphCxSpFirst, div.MsoListParagraphCxSpFirst
 
{mso-style-priority:34;
 
mso-style-unhide:no;
 
mso-style-qformat:yes;
 
mso-style-type:export-only;
 
margin-top:0cm;
 
margin-right:0cm;
 
margin-bottom:0cm;
 
margin-left:36.0pt;
 
margin-bottom:.0001pt;
 
mso-add-space:auto;
 
mso-pagination:widow-orphan;
 
font-size:12.0pt;
 
mso-bidi-font-size:10.5pt;
 
font-family:"Liberation Serif","serif";
 
mso-fareast-font-family:"Noto Sans CJK SC Regular";
 
mso-hansi-font-family:"Liberation Serif";
 
mso-bidi-font-family:Mangal;
 
mso-ansi-language:ES;
 
mso-fareast-language:ZH-CN;
 
mso-bidi-language:HI;}
 
p.MsoListParagraphCxSpMiddle, li.MsoListParagraphCxSpMiddle, div.MsoListParagraphCxSpMiddle
 
{mso-style-priority:34;
 
mso-style-unhide:no;
 
mso-style-qformat:yes;
 
mso-style-type:export-only;
 
margin-top:0cm;
 
margin-right:0cm;
 
margin-bottom:0cm;
 
margin-left:36.0pt;
 
margin-bottom:.0001pt;
 
mso-add-space:auto;
 
mso-pagination:widow-orphan;
 
font-size:12.0pt;
 
mso-bidi-font-size:10.5pt;
 
font-family:"Liberation Serif","serif";
 
mso-fareast-font-family:"Noto Sans CJK SC Regular";
 
mso-hansi-font-family:"Liberation Serif";
 
mso-bidi-font-family:Mangal;
 
mso-ansi-language:ES;
 
mso-fareast-language:ZH-CN;
 
mso-bidi-language:HI;}
 
p.MsoListParagraphCxSpLast, li.MsoListParagraphCxSpLast, div.MsoListParagraphCxSpLast
 
{mso-style-priority:34;
 
mso-style-unhide:no;
 
mso-style-qformat:yes;
 
mso-style-type:export-only;
 
margin-top:0cm;
 
margin-right:0cm;
 
margin-bottom:0cm;
 
margin-left:36.0pt;
 
margin-bottom:.0001pt;
 
mso-add-space:auto;
 
mso-pagination:widow-orphan;
 
font-size:12.0pt;
 
mso-bidi-font-size:10.5pt;
 
font-family:"Liberation Serif","serif";
 
mso-fareast-font-family:"Noto Sans CJK SC Regular";
 
mso-hansi-font-family:"Liberation Serif";
 
mso-bidi-font-family:Mangal;
 
mso-ansi-language:ES;
 
mso-fareast-language:ZH-CN;
 
mso-bidi-language:HI;}
 
span.SourceText
 
{mso-style-name:"Source Text";
 
mso-style-unhide:no;
 
mso-style-qformat:yes;
 
mso-style-parent:"";
 
font-family:"Liberation Mono";
 
mso-ascii-font-family:"Liberation Mono";
 
mso-fareast-font-family:"Courier New";
 
mso-hansi-font-family:"Liberation Mono";
 
mso-bidi-font-family:"Liberation Mono";}
 
span.InternetLink
 
{mso-style-name:"Internet Link";
 
mso-style-unhide:no;
 
mso-style-parent:"";
 
color:navy;
 
text-decoration:underline;
 
text-underline:single;}
 
p.Heading, li.Heading, div.Heading
 
{mso-style-name:Heading;
 
mso-style-unhide:no;
 
mso-style-qformat:yes;
 
mso-style-next:"Texto independiente";
 
margin-top:12.0pt;
 
margin-right:0cm;
 
margin-bottom:6.0pt;
 
margin-left:0cm;
 
mso-pagination:widow-orphan;
 
page-break-after:avoid;
 
font-size:14.0pt;
 
font-family:"Liberation Sans","sans-serif";
 
mso-fareast-font-family:"Noto Sans CJK SC Regular";
 
mso-hansi-font-family:"Liberation Sans";
 
mso-bidi-font-family:FreeSans;
 
mso-ansi-language:ES;
 
mso-fareast-language:ZH-CN;
 
mso-bidi-language:HI;}
 
p.Index, li.Index, div.Index
 
{mso-style-name:Index;
 
mso-style-unhide:no;
 
mso-style-qformat:yes;
 
margin:0cm;
 
margin-bottom:.0001pt;
 
mso-pagination:widow-orphan no-line-numbers;
 
font-size:12.0pt;
 
font-family:"Liberation Serif","serif";
 
mso-fareast-font-family:"Noto Sans CJK SC Regular";
 
mso-hansi-font-family:"Liberation Serif";
 
mso-bidi-font-family:FreeSans;
 
mso-ansi-language:ES;
 
mso-fareast-language:ZH-CN;
 
mso-bidi-language:HI;}
 
p.PreformattedText, li.PreformattedText, div.PreformattedText
 
{mso-style-name:"Preformatted Text";
 
mso-style-unhide:no;
 
mso-style-qformat:yes;
 
margin:0cm;
 
margin-bottom:.0001pt;
 
mso-pagination:widow-orphan;
 
font-size:10.0pt;
 
font-family:"Liberation Mono";
 
mso-fareast-font-family:"Courier New";
 
mso-bidi-font-family:"Liberation Mono";
 
mso-ansi-language:ES;
 
mso-fareast-language:ZH-CN;
 
mso-bidi-language:HI;}
 
span.HTMLconformatoprevioCar
 
{mso-style-name:"HTML con formato previo Car";
 
mso-style-noshow:yes;
 
mso-style-priority:99;
 
mso-style-unhide:no;
 
mso-style-locked:yes;
 
mso-style-link:"HTML con formato previo";
 
mso-ansi-font-size:10.0pt;
 
mso-bidi-font-size:10.0pt;
 
font-family:"Courier New";
 
mso-ascii-font-family:"Courier New";
 
mso-hansi-font-family:"Courier New";
 
mso-bidi-font-family:"Courier New";
 
mso-ansi-language:ES-TRAD;
 
mso-fareast-language:ES-TRAD;
 
mso-bidi-language:AR-SA;}
 
span.pln
 
{mso-style-name:pln;
 
mso-style-unhide:no;}
 
span.pun
 
{mso-style-name:pun;
 
mso-style-unhide:no;}
 
span.Ttulo2Car
 
{mso-style-name:"T’tulo 2 Car";
 
mso-style-priority:9;
 
mso-style-unhide:no;
 
mso-style-locked:yes;
 
mso-style-link:"T’tulo 2";
 
mso-ansi-font-size:18.0pt;
 
mso-bidi-font-size:18.0pt;
 
font-weight:bold;}
 
span.crayon-p
 
{mso-style-name:crayon-p;
 
mso-style-unhide:no;}
 
span.crayon-e
 
{mso-style-name:crayon-e;
 
mso-style-unhide:no;}
 
span.crayon-v
 
{mso-style-name:crayon-v;
 
mso-style-unhide:no;}
 
span.crayon-i
 
{mso-style-name:crayon-i;
 
mso-style-unhide:no;}
 
span.crayon-h
 
{mso-style-name:crayon-h;
 
mso-style-unhide:no;}
 
span.crayon-cn
 
{mso-style-name:crayon-cn;
 
mso-style-unhide:no;}
 
span.crayon-o
 
{mso-style-name:crayon-o;
 
mso-style-unhide:no;}
 
span.crayon-s
 
{mso-style-name:crayon-s;
 
mso-style-unhide:no;}
 
span.crayon-sy
 
{mso-style-name:crayon-sy;
 
mso-style-unhide:no;}
 
span.SpellE
 
{mso-style-name:"";
 
mso-spl-e:yes;}
 
span.GramE
 
{mso-style-name:"";
 
mso-gram-e:yes;}
 
.MsoChpDefault
 
{mso-style-type:export-only;
 
mso-default-props:yes;
 
font-family:"Liberation Serif","serif";
 
mso-ascii-font-family:"Liberation Serif";
 
mso-fareast-font-family:"Noto Sans CJK SC Regular";
 
mso-hansi-font-family:"Liberation Serif";
 
mso-bidi-font-family:FreeSans;
 
mso-ansi-language:ES;
 
mso-fareast-language:ZH-CN;
 
mso-bidi-language:HI;}
 
@page WordSection1
 
{size:595.3pt 841.9pt;
 
margin:2.0cm 2.0cm 2.0cm 2.0cm;
 
mso-header-margin:0cm;
 
mso-footer-margin:0cm;
 
mso-forms-protection:no;
 
mso-paper-source:0;}
 
div.WordSection1
 
{page:WordSection1;}
 
/* List Definitions */
 
@list l0
 
{mso-list-id:5258670;
 
mso-list-template-ids:458920206;}
 
@list l0:level1
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:36.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l0:level2
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:72.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l0:level3
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:108.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l0:level4
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:144.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l0:level5
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:180.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l0:level6
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:216.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l0:level7
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:252.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l0:level8
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:288.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l0:level9
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:324.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l1
 
{mso-list-id:407728816;
 
mso-list-template-ids:1102223040;}
 
@list l1:level1
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:36.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l1:level2
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:72.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l1:level3
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:108.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l1:level4
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:144.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l1:level5
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:180.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l1:level6
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:216.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l1:level7
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:252.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l1:level8
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:288.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l1:level9
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:324.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l2
 
{mso-list-id:442263736;
 
mso-list-type:hybrid;
 
mso-list-template-ids:1385458520 67764239 67764249 67764251 67764239 67764249 67764251 67764239 67764249 67764251;}
 
@list l2:level1
 
{mso-level-tab-stop:none;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;}
 
@list l2:level2
 
{mso-level-number-format:alpha-lower;
 
mso-level-tab-stop:none;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;}
 
@list l2:level3
 
{mso-level-number-format:roman-lower;
 
mso-level-tab-stop:none;
 
mso-level-number-position:right;
 
text-indent:-9.0pt;}
 
@list l2:level4
 
{mso-level-tab-stop:none;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;}
 
@list l2:level5
 
{mso-level-number-format:alpha-lower;
 
mso-level-tab-stop:none;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;}
 
@list l2:level6
 
{mso-level-number-format:roman-lower;
 
mso-level-tab-stop:none;
 
mso-level-number-position:right;
 
text-indent:-9.0pt;}
 
@list l2:level7
 
{mso-level-tab-stop:none;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;}
 
@list l2:level8
 
{mso-level-number-format:alpha-lower;
 
mso-level-tab-stop:none;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;}
 
@list l2:level9
 
{mso-level-number-format:roman-lower;
 
mso-level-tab-stop:none;
 
mso-level-number-position:right;
 
text-indent:-9.0pt;}
 
@list l3
 
{mso-list-id:878318861;
 
mso-list-template-ids:-1959331376;}
 
@list l3:level1
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:36.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l3:level2
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:72.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l3:level3
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:108.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l3:level4
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:144.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l3:level5
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:180.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l3:level6
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:216.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l3:level7
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:252.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l3:level8
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:288.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l3:level9
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:324.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l4
 
{mso-list-id:934022336;
 
mso-list-template-ids:-1736297786;}
 
@list l4:level1
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:36.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l4:level2
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:72.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l4:level3
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:108.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l4:level4
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:144.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l4:level5
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:180.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l4:level6
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:216.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l4:level7
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:252.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l4:level8
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:288.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l4:level9
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:324.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l5
 
{mso-list-id:1865749801;
 
mso-list-type:hybrid;
 
mso-list-template-ids:-1803366268 2036620954 67764249 67764251 67764239 67764249 67764251 67764239 67764249 67764251;}
 
@list l5:level1
 
{mso-level-tab-stop:none;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:13.0pt;}
 
@list l5:level2
 
{mso-level-number-format:alpha-lower;
 
mso-level-tab-stop:none;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;}
 
@list l5:level3
 
{mso-level-number-format:roman-lower;
 
mso-level-tab-stop:none;
 
mso-level-number-position:right;
 
text-indent:-9.0pt;}
 
@list l5:level4
 
{mso-level-tab-stop:none;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;}
 
@list l5:level5
 
{mso-level-number-format:alpha-lower;
 
mso-level-tab-stop:none;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;}
 
@list l5:level6
 
{mso-level-number-format:roman-lower;
 
mso-level-tab-stop:none;
 
mso-level-number-position:right;
 
text-indent:-9.0pt;}
 
@list l5:level7
 
{mso-level-tab-stop:none;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;}
 
@list l5:level8
 
{mso-level-number-format:alpha-lower;
 
mso-level-tab-stop:none;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;}
 
@list l5:level9
 
{mso-level-number-format:roman-lower;
 
mso-level-tab-stop:none;
 
mso-level-number-position:right;
 
text-indent:-9.0pt;}
 
@list l6
 
{mso-list-id:1870676312;
 
mso-list-template-ids:-5346756;}
 
@list l6:level1
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:36.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l6:level2
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:72.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l6:level3
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:108.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l6:level4
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:144.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l6:level5
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:180.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l6:level6
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:216.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l6:level7
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:252.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l6:level8
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:288.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
@list l6:level9
 
{mso-level-number-format:bullet;
 
mso-level-text:_;
 
mso-level-tab-stop:324.0pt;
 
mso-level-number-position:left;
 
text-indent:-18.0pt;
 
mso-ansi-font-size:10.0pt;
 
font-family:Wingdings;}
 
ol
 
{margin-bottom:0cm;}
 
ul
 
{margin-bottom:0cm;}
 
-->
 
</style>
 
<!--[if gte mso 10]>
 
<style>
 
/* Style Definitions */
 
table.MsoNormalTable
 
{mso-style-name:"Tabla normal";
 
mso-tstyle-rowband-size:0;
 
mso-tstyle-colband-size:0;
 
mso-style-noshow:yes;
 
mso-style-priority:99;
 
mso-style-parent:"";
 
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
 
mso-para-margin:0cm;
 
mso-para-margin-bottom:.0001pt;
 
mso-pagination:widow-orphan;
 
font-size:12.0pt;
 
font-family:"Liberation Serif","serif";
 
mso-fareast-font-family:"Noto Sans CJK SC Regular";
 
mso-ansi-language:ES;
 
mso-fareast-language:ZH-CN;
 
mso-bidi-language:HI;}
 
</style>
 
<![endif]-->
 
</head>
 
  
<body bgcolor=white lang=ES-TRAD link=blue vlink="#954F72" style='tab-interval:
+
2. Allow Remote Access
35.45pt'>
 
  
<div class=WordSection1>
+
3. Run as a Service
  
<h1><span lang=EN-US style='font-size:15.0pt;mso-bidi-font-size:24.0pt;
+
4. Access PGAdmin 4
font-family:Arial;color:#111111;mso-ansi-language:EN-US'>PGADMIN4 ON UBUNTU
 
16.04<o:p></o:p></span></h1>
 
  
<h1 style='margin-left:36.0pt;text-indent:-18.0pt;mso-list:l2 level1 lfo1'><![if !supportLists]><span
+
5. Enable Postgresql remote Access
lang=EN-US style='font-size:14.0pt;mso-bidi-font-size:24.0pt;font-family:Arial;
+
===
mso-fareast-font-family:Arial;color:#111111;mso-ansi-language:EN-US'><span
 
style='mso-list:Ignore'>1.<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 
</span></span></span><![endif]><span lang=EN-US style='font-size:14.0pt;
 
mso-bidi-font-size:24.0pt;font-family:Arial;color:#111111;mso-ansi-language:
 
EN-US'>Install<o:p></o:p></span></h1>
 
  
<p class=MsoBodyText style='margin-left:36.0pt;text-indent:-18.0pt;mso-list:
+
1. Install dependencies, create a virtual environment, download, install & configure
l2 level1 lfo1'><![if !supportLists]><b style='mso-bidi-font-weight:normal'><span
+
Using Python2.x
lang=EN-US style='font-size:13.0pt;mso-bidi-font-size:12.0pt;line-height:120%;
+
sudo apt-get install virtualenv python-pip libpq-dev python-dev
font-family:Arial;mso-fareast-font-family:Arial;mso-ansi-language:EN-US'><span
 
style='mso-list:Ignore'>2.<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 
</span></span></span></b><![endif]><b style='mso-bidi-font-weight:normal'><span
 
lang=EN-US style='font-size:13.0pt;mso-bidi-font-size:12.0pt;line-height:120%;
 
font-family:Arial;mso-ansi-language:EN-US'>Allow Remote Access<o:p></o:p></span></b></p>
 
  
<p class=MsoBodyText style='margin-left:36.0pt;text-indent:-18.0pt;mso-list:
+
cd
l2 level1 lfo1'><![if !supportLists]><b style='mso-bidi-font-weight:normal'><span
+
virtualenv pgadmin4
lang=EN-US style='font-size:13.0pt;mso-bidi-font-size:12.0pt;line-height:120%;
+
cd pgadmin4
font-family:Arial;mso-fareast-font-family:Arial;mso-ansi-language:EN-US'><span
+
source bin/activate
style='mso-list:Ignore'>3.<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 
</span></span></span></b><![endif]><b style='mso-bidi-font-weight:normal'><span
 
lang=EN-US style='font-size:13.0pt;mso-bidi-font-size:12.0pt;line-height:120%;
 
font-family:Arial;mso-ansi-language:EN-US'>Run as a Service<o:p></o:p></span></b></p>
 
  
<p style='margin-top:0cm;margin-right:0cm;margin-bottom:12.0pt;margin-left:
+
pip install https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v2.1/pip/pgadmin4-2.1-py2.py3-none-any.whl
36.0pt;text-indent:-18.0pt;mso-list:l2 level1 lfo1;background:white;vertical-align:
+
Using Python3.x (Preferred to avoid encoding related issues)
baseline'><![if !supportLists]><b style='mso-bidi-font-weight:normal'><span
+
sudo apt-get install virtualenv python3-pip libpq-dev python3-dev
lang=EN-US style='font-size:14.0pt;mso-bidi-font-size:11.5pt;font-family:Arial;
 
mso-fareast-font-family:Arial;color:#242729;mso-ansi-language:EN-US'><span
 
style='mso-list:Ignore'>4.<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 
</span></span></span></b><![endif]><b style='mso-bidi-font-weight:normal'><span
 
lang=EN-US style='font-size:14.0pt;mso-bidi-font-size:11.5pt;font-family:Arial;
 
color:#242729;mso-ansi-language:EN-US'>Access <span class=SpellE>PGAdmin</span>
 
4<o:p></o:p></span></b></p>
 
  
<p style='margin-top:0cm;margin-right:0cm;margin-bottom:12.0pt;margin-left:
+
cd
36.0pt;text-indent:-18.0pt;mso-list:l2 level1 lfo1;background:white;vertical-align:
+
virtualenv -p python3 pgadmin4
baseline'><![if !supportLists]><b style='mso-bidi-font-weight:normal'><span
+
cd pgadmin4
lang=EN-US style='font-size:14.0pt;mso-bidi-font-size:11.5pt;font-family:Arial;
+
source bin/activate
mso-fareast-font-family:Arial;color:#242729;mso-ansi-language:EN-US'><span
 
style='mso-list:Ignore'>5.<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 
</span></span></span></b><![endif]><b style='mso-bidi-font-weight:normal'><span
 
lang=EN-US style='font-size:14.0pt;mso-bidi-font-size:11.5pt;font-family:Arial;
 
color:#242729;mso-ansi-language:EN-US'>Enable <span class=SpellE>Postgresql</span>
 
remote Access<o:p></o:p></span></b></p>
 
  
<p class=MsoBodyText style='margin-left:36.0pt'><b style='mso-bidi-font-weight:
+
pip3 install https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v2.1/pip/pgadmin4-2.1-py2.py3-none-any.whl
normal'><span lang=EN-US style='font-size:13.0pt;mso-bidi-font-size:12.0pt;
+
Configure
line-height:120%;font-family:Arial;mso-ansi-language:EN-US'><o:p>&nbsp;</o:p></span></b></p>
+
Override default paths and set it to single-user mode in the local configuration file:
 +
nano lib/python2.7/site-packages/pgadmin4/config_local.py
 +
For Python3.x:
 +
nano lib/python3.x/site-packages/pgadmin4/config_local.py
 +
Write:
 +
import os
 +
DATA_DIR = os.path.realpath(os.path.expanduser(u'~/.pgadmin/'))
 +
LOG_FILE = os.path.join(DATA_DIR, 'pgadmin4.log')
 +
SQLITE_PATH = os.path.join(DATA_DIR, 'pgadmin4.db')
 +
SESSION_DB_PATH = os.path.join(DATA_DIR, 'sessions')
 +
STORAGE_DIR = os.path.join(DATA_DIR, 'storage')
 +
SERVER_MODE = False
 +
Run
 +
python lib/python2.7/site-packages/pgadmin4/pgAdmin4.py
 +
For Python3.x:
 +
python3 lib/python3.x/site-packages/pgadmin4/pgAdmin4.py
 +
Access
 +
Access at http://localhost:5050
 +
Exit
 +
Exit with Ctrl-C
 +
Run again
 +
cd ~/pgadmin4
 +
source bin/activate
 +
python lib/python2.7/site-packages/pgadmin4/pgAdmin4.py
 +
For Python3.x
 +
#!/bin/bash
 +
cd ~/pgadmin4
 +
source bin/activate
 +
python3 lib/python3.x/site-packages/pgadmin4/pgAdmin4.py
 +
Make a shortcut
 +
touch ~/pgadmin4/pgadmin4
 +
chmod +x ~/pgadmin4/pgadmin4
 +
nano ~/pgadmin4/pgadmin4
 +
Write:
 +
#!/bin/bash
 +
cd ~/pgadmin4
 +
source bin/activate
 +
python lib/python2.7/site-packages/pgadmin4/pgAdmin4.py
 +
For Python3.x
 +
#!/bin/bash
 +
cd ~/pgadmin4
 +
source bin/activate
 +
python3 lib/python3.x/site-packages/pgadmin4/pgAdmin4.py
 +
Now you can just run it with a simpler command:
 +
~/pgadmin4/pgadmin4
 +
Python3 users
 +
Replace [x] in Python3.x with your respective version.
 +
Conflict with pgAdmin 3 configuration
 +
pgAdmin 4 will not start in the environment where pgAdmin 3 was previously installed and used because of incompatible configuration in the .pgadmin directory. The simplest solution is to either clear that directory or tweak config_local.py to point to a clean new .pgadmin4directory.
  
<h1 style='margin-left:0cm;text-indent:0cm;mso-list:l5 level1 lfo2'><![if !supportLists]><span
+
2. REMOTE ACCESS (For CLOUD Install)
lang=EN-US style='font-size:13.0pt;mso-bidi-font-size:14.0pt;font-family:Arial;
+
PGAdmin4 Folder: ~/pgadmin4/lib/python3.X/site-packages/pgadmin4
mso-fareast-font-family:Arial;color:#111111;mso-ansi-language:EN-US'><span
+
(Replace 3.X with your Python Version)
style='mso-list:Ignore'>1.<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
+
You need to add below config options,
</span></span></span><![endif]><span lang=EN-US style='font-size:14.0pt;
+
DEFAULT_SERVER = '0.0.0.0'
font-family:Arial;color:#111111;mso-ansi-language:EN-US'>Install dependencies,
+
in config_local.py (in "pgAdmin4" folder).
create a virtual environment, download, install &amp; configure<o:p></o:p></span></h1>
+
If also want to change default port then also add
 +
DEFAULT_SERVER_PORT = 5050
  
<h3 style='margin:0cm;margin-bottom:.0001pt;line-height:130%'><span lang=EN-US
 
style='font-size:13.0pt;mso-bidi-font-size:14.0pt;line-height:130%;font-family:
 
inherit;color:#111111;mso-ansi-language:EN-US;font-weight:normal;mso-bidi-font-weight:
 
bold'>Using Python2.x<o:p></o:p></span></h3>
 
  
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
+
3. RUN as a Service
class=SpellE><span class=SourceText><span lang=EN-US style='font-family:inherit;
+
Python file:  ~/pgadmin4/lib/python3.x/site-packages/pgadmin4/pgAdmin4.py
color:#303336;background:white;mso-highlight:white;mso-ansi-language:EN-US'>sudo</span></span></span><span
+
PGAdmin4 Folder: ~/pgadmin4/lib/python3.X/site-packages/pgadmin4
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
+
(Replace 3.X with your Python Version)
background:white;mso-highlight:white;mso-ansi-language:EN-US'> apt-get install <span
+
Before we start let’s exit the virtual enviroment using the follwoing command:
class=SpellE>virtualenv</span> python-pip <span class=SpellE>libpq-dev</span>
+
# deactivate
python-<span class=SpellE>dev</span></span></span><span lang=EN-US
+
– To make PgAdmin 4 we need to make some extra modification, Open the pgAdmin4.py file and insert the following line in the begin of the file:
style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
+
# vi ~/pgadmin4/lib/python3.x/site-packages/pgadmin4/pgAdmin4.py
 +
#!/usr/bin/env python3
 +
[...]
 +
– Make it executable by doing:
 +
# chmod +x  ~/pgadmin4/lib/python3.x/site-packages/pgadmin4/pgAdmin4.py
 +
– Now create a /etc/systemd/system/pgadmin4.service service file containing:
 +
# vi /etc/systemd/system/pgadmin4.service
 +
[Unit]
 +
Description=Pgadmin4 Service
 +
After=network.target
  
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
+
[Service]
lang=EN-US style='mso-ansi-language:EN-US'><o:p>&nbsp;</o:p></span></p>
+
User=root
 +
Group=root
 +
# Point to the virtual environment directory
 +
WorkingDirectory=/root/pgadmin4
 +
# Point to the bin folder of your virtual environment
 +
# Environment="PATH=/home/qgis/Downloads/pgadmin4/bin"
 +
Environment="PATH=/root/pgadmin4/bin"
 +
# ExecStart=/home/qgis/Downloads/pgadmin4/bin/python /home/web/Downloads/pgadmin4/lib/python3.6/site-packages/pgadmin4/pgAdmin4.py
 +
ExecStart="/root/pgadmin4/lib/python3.5/site-packages/pgadmin4/pgAdmin4.py"
 +
PrivateTmp=true
  
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
+
[Install]
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
+
WantedBy=multi-user.target
background:white;mso-highlight:white;mso-ansi-language:EN-US'>cd</span></span><span
+
– Enable and start PgAdmin Service at system boot:
lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
+
# sudo systemctl daemon-reload
 +
# sudo systemctl enable pgadmin4
 +
# sudo systemctl start pgadmin4
 +
# sudo systemctl status  pgadmin4
  
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
+
4. Access PGAdmin 4
class=SpellE><span class=SourceText><span lang=EN-US style='font-family:inherit;
+
– Open http://Server_ip:5050 and logon to the PgAdmin using your credentials.
color:#303336;background:white;mso-highlight:white;mso-ansi-language:EN-US'>virtualenv</span></span></span><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'> pgadmin4</span></span><span
 
lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
 
  
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>cd pgadmin4</span></span><span
 
lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
 
  
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
+
5. Enable Postgresql Remote Access.
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>source
 
bin/activate</span></span><span lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
 
  
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
+
5.1. Permitir conexiones de clientes desde un determinado rango
lang=EN-US style='mso-ansi-language:EN-US'><o:p>&nbsp;</o:p></span></p>
+
Llegamos a uno de los puntos importantes de la cuestión, el fichero pg_hba.conf. Su situación exacta dependerá de vuestra instalación, pero lo encontraréis en una de estas dos rutas:
 
+
 /var/lib/pgsql/data/pg_hba.conf (en mi instalación lo tengo ahí, utilizo Scientific Linux, una distribución derivada de Red Hat)
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
+
 /etc/postgresql/main/pg_hba.conf
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
+
Dentro de este fichero, al final del mismo, veremos algo así:
background:white;mso-highlight:white;mso-ansi-language:EN-US'>pip install
+
1
https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v2.</span></span><span
+
2
class=SourceText><span lang=EN-US style='font-family:inherit;color:#7D2727;
+
3
background:white;mso-highlight:white;mso-ansi-language:EN-US'>1</span></span><span
+
4
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
+
5
background:white;mso-highlight:white;mso-ansi-language:EN-US'>/pip/pgadmin4-</span></span><span
+
6
class=SourceText><span lang=EN-US style='font-family:inherit;color:#7D2727;
+
7
background:white;mso-highlight:white;mso-ansi-language:EN-US'>2.1</span></span><span
+
8 # TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
+
background:white;mso-highlight:white;mso-ansi-language:EN-US'>-py2.py3-none-any.whl</span></span><span
+
# "local" is for Unix domain socket connections only
lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
+
local  all        all                              ident
 
+
# IPv4 local connections:
<h3 style='margin:0cm;margin-bottom:.0001pt;line-height:130%'><span lang=EN-US
+
host    all        all        127.0.0.1/32          ident
style='font-size:13.0pt;mso-bidi-font-size:14.0pt;line-height:130%;font-family:
+
# IPv6 local connections:
inherit;color:#111111;mso-ansi-language:EN-US;font-weight:normal;mso-bidi-font-weight:
+
host    all        all        ::1/128              password
bold'>Using Python3.x (Preferred to avoid encoding related issues)<o:p></o:p></span></h3>
+
¿Qué significa esto? Veamos columna a columna:
 
+
 Tipo: básicamente conexión local o conexión remota (host).
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
+
 Base de datos: base de datos a las que afecta la regla. Si queremos todas, usamos el comodín all.
class=SpellE><span class=SourceText><span lang=EN-US style='font-family:inherit;
+
 Usuario: usuarios a los que afecta la regla, si queremos que afecte a todos, usamos también all.
color:#303336;background:white;mso-highlight:white;mso-ansi-language:EN-US'>sudo</span></span></span><span
+
Nos paramos ahora en los dos apartados que más atención requieren.
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
+
5.2. Dirección
background:white;mso-highlight:white;mso-ansi-language:EN-US'> apt-get install <span
+
En esta columna definimos, las direcciones IP (podemos también usar IPv6), desde las que podremos conectarnos a PostgreSQL. Usaremos la fórmula dirección/máscara:
class=SpellE>virtualenv</span> python3-pip <span class=SpellE>libpq-dev</span>
+
 Una sola dirección: 150.100.100.100/32
python3-dev</span></span><span lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
+
 O un rango (ampliemos el mismo de antes): 150.100.100.0/24 (256 direcciones)
 
+
5.3. Método
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
+
Aunque hay multitud de métodos para utilizar (incluyendo conexiones LDAP, Kerberos o PAM), explico los tres más básicos:
lang=EN-US style='mso-ansi-language:EN-US'><o:p>&nbsp;</o:p></span></p>
+
 ident: utiliza el usuario del sistema desde el que se está intentado conectar.
 
+
 trust: deja todos los accesos sin necesidad de autenticarse (sólo recomendable para conexiones desde el equipo local).
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
+
 password: identificación con usuario/contraseña, es la más típica y es la recomendable para conexiones desde clientes como EMS PostgreSQL Manager.
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
+
Una línea de ejemplo, para darle acceso a todos los usuarios, a todas las base de datos, desde el rango de IP explicado antes, usando autenticación con usuario y contraseña, sería la siguiente:
background:white;mso-highlight:white;mso-ansi-language:EN-US'>cd</span></span><span
+
1 host    all        all        150.100.100.0/24          password
lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
+
5.4. Habilitar conexiones al socket desde clientes que no sean el host local
 
+
Al igual que en MySQL hay que configurar el bind-adress en my.conf, en PostgreSQL tenemos que hacer algo análogo.
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
+
Para versiones 8.x en adelante el procedimiento es el siguiente. Buscamos el ficheropostgresql.conf en:
class=SpellE><span class=SourceText><span lang=EN-US style='font-family:inherit;
+
 /var/lib/pgsql/data/postgresql.conf
color:#303336;background:white;mso-highlight:white;mso-ansi-language:EN-US'>virtualenv</span></span></span><span
+
 /etc/postgresql/8.2/main/postgresql.conf
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
+
Y buscar dentro del mismo la siguiente línea:
background:white;mso-highlight:white;mso-ansi-language:EN-US'> -p python3
+
1 listen_addresses='localhost'
pgadmin4</span></span><span lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
+
Para sustituirla, por el comodín (para todas las IP, es una opción segura, tened en cuenta que tenemos también un filtro en el fichero pg_hba.conf.
 
+
1 listen_addresses='*'
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
+
O definir algunas direcciones IP en concreto:
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
+
1 listen_addresses='150.100.100.100 150.100.100.101'
background:white;mso-highlight:white;mso-ansi-language:EN-US'>cd pgadmin4</span></span><span
+
5.5. Reiniciar servicio
lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
+
Reiniciamos el servicio para que el servidor cargue los nuevos valores (como root):
 
+
1 $ service postgresql restart
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>source
 
bin/activate</span></span><span lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
 
 
 
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
 
lang=EN-US style='mso-ansi-language:EN-US'><o:p>&nbsp;</o:p></span></p>
 
 
 
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>pip3 install
 
https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v2.</span></span><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#7D2727;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>1</span></span><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>/pip/pgadmin4-</span></span><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#7D2727;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>2.1</span></span><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>-py2.py3-none-any.whl</span></span><span
 
lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
 
 
 
<h2 style='margin:0cm;margin-bottom:.0001pt;line-height:130%'><span lang=EN-US
 
style='font-size:14.5pt;mso-bidi-font-size:18.0pt;line-height:130%;font-family:
 
inherit;color:#111111;mso-ansi-language:EN-US;font-weight:normal;mso-bidi-font-weight:
 
bold'>Configure<o:p></o:p></span></h2>
 
 
 
<p class=MsoBodyText style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
 
130%'><span lang=EN-US style='font-size:11.5pt;mso-bidi-font-size:12.0pt;
 
line-height:130%;font-family:inherit;color:#111111;mso-ansi-language:EN-US'>Override
 
default paths and set it to single-user mode in the&nbsp;</span><span lang=ES><a
 
href="https://www.pgadmin.org/docs/pgadmin4/dev/server_deployment.html"><span
 
class=InternetLink><span lang=EN-US style='font-size:11.5pt;mso-bidi-font-size:
 
12.0pt;line-height:130%;font-family:inherit;color:#962D0C;mso-ansi-language:
 
EN-US;text-decoration:none;text-underline:none'>local configuration file</span></span></a></span><span
 
lang=EN-US style='font-size:11.5pt;mso-bidi-font-size:12.0pt;line-height:130%;
 
font-family:inherit;color:#111111;mso-ansi-language:EN-US'>:</span><span
 
lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
 
 
 
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
 
class=SpellE><span class=SourceText><span lang=EN-US style='font-family:inherit;
 
color:#303336;background:white;mso-highlight:white;mso-ansi-language:EN-US'>nano</span></span></span><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'> lib/python2.</span></span><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#7D2727;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>7</span></span><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>/site-packages/pgadmin4/config_local.py</span></span><span
 
lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
 
 
 
<p class=MsoBodyText style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
 
130%'><span lang=EN-US style='font-size:11.5pt;mso-bidi-font-size:12.0pt;
 
line-height:130%;font-family:inherit;color:#111111;mso-ansi-language:EN-US'>For
 
Python3.x:<o:p></o:p></span></p>
 
 
 
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
 
class=SpellE><span class=SourceText><span lang=EN-US style='font-family:inherit;
 
color:#303336;background:white;mso-highlight:white;mso-ansi-language:EN-US'>nano</span></span></span><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'> lib/python3.x/site-packages/pgadmin4/config_local.py</span></span><span
 
lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
 
 
 
<p class=MsoBodyText style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
 
130%'><span lang=EN-US style='font-size:11.5pt;mso-bidi-font-size:12.0pt;
 
line-height:130%;font-family:inherit;color:#111111;mso-ansi-language:EN-US'>Write:<o:p></o:p></span></p>
 
 
 
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>import <span
 
class=SpellE>os</span></span></span><span lang=EN-US style='mso-ansi-language:
 
EN-US'><o:p></o:p></span></p>
 
 
 
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>DATA_DIR =</span></span><span
 
class=SourceText><span lang=EN-US style='font-family:"Consolas;Menlo;Monaco;Lucida Co","serif";
 
color:#303336;background:white;mso-highlight:white;mso-ansi-language:EN-US'> </span></span><span
 
class=SpellE><span class=GramE><span class=SourceText><span lang=EN-US
 
style='font-family:inherit;color:#303336;background:white;mso-highlight:white;
 
mso-ansi-language:EN-US'>os.path</span></span></span><span class=SourceText><span
 
lang=EN-US style='font-family:inherit;color:#303336;background:white;
 
mso-highlight:white;mso-ansi-language:EN-US'>.realpath</span></span></span><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>(<span
 
class=SpellE>os.path.expanduser</span>(u</span></span><span class=SourceText><span
 
lang=EN-US style='font-family:inherit;color:#7D2727;background:white;
 
mso-highlight:white;mso-ansi-language:EN-US'>'~/.<span class=SpellE>pgadmin</span>/'</span></span><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>))</span></span><span
 
lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
 
 
 
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>LOG_FILE =</span></span><span
 
class=SourceText><span lang=EN-US style='font-family:"Consolas;Menlo;Monaco;Lucida Co","serif";
 
color:#303336;background:white;mso-highlight:white;mso-ansi-language:EN-US'> </span></span><span
 
class=SpellE><span class=GramE><span class=SourceText><span lang=EN-US
 
style='font-family:inherit;color:#303336;background:white;mso-highlight:white;
 
mso-ansi-language:EN-US'>os.path</span></span></span><span class=SourceText><span
 
lang=EN-US style='font-family:inherit;color:#303336;background:white;
 
mso-highlight:white;mso-ansi-language:EN-US'>.join</span></span></span><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>(DATA_DIR,</span></span><span
 
class=SourceText><span lang=EN-US style='font-family:"Consolas;Menlo;Monaco;Lucida Co","serif";
 
color:#303336;background:white;mso-highlight:white;mso-ansi-language:EN-US'> </span></span><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#7D2727;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>'pgadmin4.log'</span></span><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>)</span></span><span
 
lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
 
 
 
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>SQLITE_PATH =</span></span><span
 
class=SourceText><span lang=EN-US style='font-family:"Consolas;Menlo;Monaco;Lucida Co","serif";
 
color:#303336;background:white;mso-highlight:white;mso-ansi-language:EN-US'> </span></span><span
 
class=SpellE><span class=GramE><span class=SourceText><span lang=EN-US
 
style='font-family:inherit;color:#303336;background:white;mso-highlight:white;
 
mso-ansi-language:EN-US'>os.path</span></span></span><span class=SourceText><span
 
lang=EN-US style='font-family:inherit;color:#303336;background:white;
 
mso-highlight:white;mso-ansi-language:EN-US'>.join</span></span></span><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>(DATA_DIR,</span></span><span
 
class=SourceText><span lang=EN-US style='font-family:"Consolas;Menlo;Monaco;Lucida Co","serif";
 
color:#303336;background:white;mso-highlight:white;mso-ansi-language:EN-US'> </span></span><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#7D2727;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>'pgadmin4.db'</span></span><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>)</span></span><span
 
lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
 
 
 
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>SESSION_DB_PATH =</span></span><span
 
class=SourceText><span lang=EN-US style='font-family:"Consolas;Menlo;Monaco;Lucida Co","serif";
 
color:#303336;background:white;mso-highlight:white;mso-ansi-language:EN-US'> </span></span><span
 
class=SpellE><span class=GramE><span class=SourceText><span lang=EN-US
 
style='font-family:inherit;color:#303336;background:white;mso-highlight:white;
 
mso-ansi-language:EN-US'>os.path</span></span></span><span class=SourceText><span
 
lang=EN-US style='font-family:inherit;color:#303336;background:white;
 
mso-highlight:white;mso-ansi-language:EN-US'>.join</span></span></span><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>(DATA_DIR,</span></span><span
 
class=SourceText><span lang=EN-US style='font-family:"Consolas;Menlo;Monaco;Lucida Co","serif";
 
color:#303336;background:white;mso-highlight:white;mso-ansi-language:EN-US'> </span></span><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#7D2727;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>'sessions'</span></span><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>)</span></span><span
 
lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
 
 
 
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>STORAGE_DIR =</span></span><span
 
class=SourceText><span lang=EN-US style='font-family:"Consolas;Menlo;Monaco;Lucida Co","serif";
 
color:#303336;background:white;mso-highlight:white;mso-ansi-language:EN-US'> </span></span><span
 
class=SpellE><span class=GramE><span class=SourceText><span lang=EN-US
 
style='font-family:inherit;color:#303336;background:white;mso-highlight:white;
 
mso-ansi-language:EN-US'>os.path</span></span></span><span class=SourceText><span
 
lang=EN-US style='font-family:inherit;color:#303336;background:white;
 
mso-highlight:white;mso-ansi-language:EN-US'>.join</span></span></span><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>(DATA_DIR,</span></span><span
 
class=SourceText><span lang=EN-US style='font-family:"Consolas;Menlo;Monaco;Lucida Co","serif";
 
color:#303336;background:white;mso-highlight:white;mso-ansi-language:EN-US'> </span></span><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#7D2727;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>'storage'</span></span><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>)</span></span><span
 
lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
 
 
 
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>SERVER_MODE =</span></span><span
 
class=SourceText><span lang=EN-US style='font-family:"Consolas;Menlo;Monaco;Lucida Co","serif";
 
color:#303336;background:white;mso-highlight:white;mso-ansi-language:EN-US'> </span></span><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#2B91AF;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>False</span></span><span
 
lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
 
 
 
<h2 style='margin:0cm;margin-bottom:.0001pt;line-height:130%'><span lang=EN-US
 
style='font-size:14.5pt;mso-bidi-font-size:18.0pt;line-height:130%;font-family:
 
inherit;color:#111111;mso-ansi-language:EN-US;font-weight:normal;mso-bidi-font-weight:
 
bold'>Run<o:p></o:p></span></h2>
 
 
 
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>python
 
lib/python2.</span></span><span class=SourceText><span lang=EN-US
 
style='font-family:inherit;color:#7D2727;background:white;mso-highlight:white;
 
mso-ansi-language:EN-US'>7</span></span><span class=SourceText><span
 
lang=EN-US style='font-family:inherit;color:#303336;background:white;
 
mso-highlight:white;mso-ansi-language:EN-US'>/site-packages/pgadmin4/pgAdmin4.py</span></span><span
 
lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
 
 
 
<p class=MsoBodyText style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
 
130%'><span lang=EN-US style='font-size:11.5pt;mso-bidi-font-size:12.0pt;
 
line-height:130%;font-family:inherit;color:#111111;mso-ansi-language:EN-US'>For
 
Python3.x:<o:p></o:p></span></p>
 
 
 
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>python3
 
lib/python3.x/site-packages/pgadmin4/pgAdmin4.py</span></span><span lang=EN-US
 
style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
 
 
 
<h2 style='margin:0cm;margin-bottom:.0001pt;line-height:130%'><span lang=EN-US
 
style='font-size:14.5pt;mso-bidi-font-size:18.0pt;line-height:130%;font-family:
 
inherit;color:#111111;mso-ansi-language:EN-US;font-weight:normal;mso-bidi-font-weight:
 
bold'>Access<o:p></o:p></span></h2>
 
 
 
<p class=MsoBodyText style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
 
130%'><span lang=EN-US style='font-size:11.5pt;mso-bidi-font-size:12.0pt;
 
line-height:130%;font-family:inherit;color:#111111;mso-ansi-language:EN-US'>Access
 
at&nbsp;</span><span lang=ES><a href="http://localhost:5050/"><span
 
class=InternetLink><span lang=EN-US style='font-size:11.5pt;mso-bidi-font-size:
 
12.0pt;line-height:130%;font-family:inherit;color:#962D0C;mso-ansi-language:
 
EN-US;text-decoration:none;text-underline:none'>http://localhost:5050</span></span></a></span><span
 
lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
 
 
 
<h2 style='margin:0cm;margin-bottom:.0001pt;line-height:130%'><span lang=EN-US
 
style='font-size:14.5pt;mso-bidi-font-size:18.0pt;line-height:130%;font-family:
 
inherit;color:#111111;mso-ansi-language:EN-US;font-weight:normal;mso-bidi-font-weight:
 
bold'>Exit<o:p></o:p></span></h2>
 
 
 
<p class=MsoBodyText style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
 
130%'><span lang=EN-US style='font-size:11.5pt;mso-bidi-font-size:12.0pt;
 
line-height:130%;font-family:inherit;color:#111111;mso-ansi-language:EN-US'>Exit
 
with Ctrl-C<o:p></o:p></span></p>
 
 
 
<h2 style='margin:0cm;margin-bottom:.0001pt;line-height:130%'><span lang=EN-US
 
style='font-size:14.5pt;mso-bidi-font-size:18.0pt;line-height:130%;font-family:
 
inherit;color:#111111;mso-ansi-language:EN-US;font-weight:normal;mso-bidi-font-weight:
 
bold'>Run again<o:p></o:p></span></h2>
 
 
 
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>cd ~/pgadmin4</span></span><span
 
lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
 
 
 
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>source
 
bin/activate</span></span><span lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
 
 
 
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>python
 
lib/python2.</span></span><span class=SourceText><span lang=EN-US
 
style='font-family:inherit;color:#7D2727;background:white;mso-highlight:white;
 
mso-ansi-language:EN-US'>7</span></span><span class=SourceText><span
 
lang=EN-US style='font-family:inherit;color:#303336;background:white;
 
mso-highlight:white;mso-ansi-language:EN-US'>/site-packages/pgadmin4/pgAdmin4.py</span></span><span
 
lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
 
 
 
<p class=MsoBodyText style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
 
130%'><span lang=EN-US style='font-size:11.5pt;mso-bidi-font-size:12.0pt;
 
line-height:130%;font-family:inherit;color:#111111;mso-ansi-language:EN-US'>For
 
Python3.x<o:p></o:p></span></p>
 
 
 
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
 
class=GramE><span class=SourceText><span lang=EN-US style='font-family:inherit;
 
color:#858C93;background:white;mso-highlight:white;mso-ansi-language:EN-US'>#!/</span></span></span><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#858C93;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>bin/bash</span></span><span
 
lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
 
 
 
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>cd ~/pgadmin4</span></span><span
 
lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
 
 
 
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>source
 
bin/activate</span></span><span lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
 
 
 
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>python3 lib/python3.x/site-packages/pgadmin4/pgAdmin4.py</span></span><span
 
lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
 
 
 
<h2 style='margin:0cm;margin-bottom:.0001pt;line-height:130%'><span lang=EN-US
 
style='font-size:14.5pt;mso-bidi-font-size:18.0pt;line-height:130%;font-family:
 
inherit;color:#111111;mso-ansi-language:EN-US;font-weight:normal;mso-bidi-font-weight:
 
bold'>Make a shortcut<o:p></o:p></span></h2>
 
 
 
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>touch
 
~/pgadmin4/pgadmin4</span></span><span lang=EN-US style='mso-ansi-language:
 
EN-US'><o:p></o:p></span></p>
 
 
 
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
 
class=SpellE><span class=SourceText><span lang=EN-US style='font-family:inherit;
 
color:#303336;background:white;mso-highlight:white;mso-ansi-language:EN-US'>chmod</span></span></span><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'> +x
 
~/pgadmin4/pgadmin4</span></span><span lang=EN-US style='mso-ansi-language:
 
EN-US'><o:p></o:p></span></p>
 
 
 
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
 
class=SpellE><span class=SourceText><span lang=EN-US style='font-family:inherit;
 
color:#303336;background:white;mso-highlight:white;mso-ansi-language:EN-US'>nano</span></span></span><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>
 
~/pgadmin4/pgadmin4</span></span><span lang=EN-US style='mso-ansi-language:
 
EN-US'><o:p></o:p></span></p>
 
 
 
<p class=MsoBodyText style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
 
130%'><span lang=EN-US style='font-size:11.5pt;mso-bidi-font-size:12.0pt;
 
line-height:130%;font-family:inherit;color:#111111;mso-ansi-language:EN-US'>Write:<o:p></o:p></span></p>
 
 
 
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
 
class=GramE><span class=SourceText><span lang=EN-US style='font-family:inherit;
 
color:#858C93;background:white;mso-highlight:white;mso-ansi-language:EN-US'>#!/</span></span></span><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#858C93;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>bin/bash</span></span><span
 
lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
 
 
 
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>cd ~/pgadmin4</span></span><span
 
lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
 
 
 
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>source
 
bin/activate</span></span><span lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
 
 
 
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>python
 
lib/python2.</span></span><span class=SourceText><span lang=EN-US
 
style='font-family:inherit;color:#7D2727;background:white;mso-highlight:white;
 
mso-ansi-language:EN-US'>7</span></span><span class=SourceText><span
 
lang=EN-US style='font-family:inherit;color:#303336;background:white;
 
mso-highlight:white;mso-ansi-language:EN-US'>/site-packages/pgadmin4/pgAdmin4.py</span></span><span
 
lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
 
 
 
<p class=MsoBodyText style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
 
130%'><span lang=EN-US style='font-size:11.5pt;mso-bidi-font-size:12.0pt;
 
line-height:130%;font-family:inherit;color:#111111;mso-ansi-language:EN-US'>For
 
Python3.x<o:p></o:p></span></p>
 
 
 
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
 
class=GramE><span class=SourceText><span lang=EN-US style='font-family:inherit;
 
color:#858C93;background:white;mso-highlight:white;mso-ansi-language:EN-US'>#!/</span></span></span><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#858C93;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>bin/bash</span></span><span
 
lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
 
 
 
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>cd ~/pgadmin4</span></span><span
 
lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
 
 
 
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>source
 
bin/activate</span></span><span lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
 
 
 
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>python3
 
lib/python3.x/site-packages/pgadmin4/pgAdmin4.py</span></span><span lang=EN-US
 
style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
 
 
 
<p class=MsoBodyText style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
 
130%'><span lang=EN-US style='font-size:11.5pt;mso-bidi-font-size:12.0pt;
 
line-height:130%;font-family:inherit;color:#111111;mso-ansi-language:EN-US'>Now
 
you can just run it with a simpler command:<o:p></o:p></span></p>
 
 
 
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
 
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
 
background:white;mso-highlight:white;mso-ansi-language:EN-US'>~/pgadmin4/pgadmin4</span></span><span
 
lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
 
 
 
<h2 style='margin:0cm;margin-bottom:.0001pt;line-height:130%'><span lang=EN-US
 
style='font-size:14.5pt;mso-bidi-font-size:18.0pt;line-height:130%;font-family:
 
inherit;color:#111111;mso-ansi-language:EN-US;font-weight:normal;mso-bidi-font-weight:
 
bold'>Python3 users<o:p></o:p></span></h2>
 
 
 
<p class=MsoBodyText style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
 
130%'><span lang=EN-US style='font-size:11.5pt;mso-bidi-font-size:12.0pt;
 
line-height:130%;font-family:inherit;color:#111111;mso-ansi-language:EN-US'>Replace
 
[x] in Python3.x with your respective version.<o:p></o:p></span></p>
 
 
 
<h2 style='margin:0cm;margin-bottom:.0001pt;line-height:130%'><span lang=EN-US
 
style='font-size:14.5pt;mso-bidi-font-size:18.0pt;line-height:130%;font-family:
 
inherit;color:#111111;mso-ansi-language:EN-US;font-weight:normal;mso-bidi-font-weight:
 
bold'>Conflict with <span class=SpellE>pgAdmin</span> 3 configuration<o:p></o:p></span></h2>
 
 
 
<p class=MsoBodyText style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
 
130%'><span class=SpellE><span class=SourceText><span lang=EN-US
 
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;line-height:130%;font-family:
 
"Consolas;Menlo;Monaco;Lucida Co","serif";color:#111111;background:white;
 
mso-highlight:white;mso-ansi-language:EN-US'>pgAdmin</span></span></span><span
 
class=SourceText><span lang=EN-US style='font-size:10.0pt;mso-bidi-font-size:
 
12.0pt;line-height:130%;font-family:"Consolas;Menlo;Monaco;Lucida Co","serif";
 
color:#111111;background:white;mso-highlight:white;mso-ansi-language:EN-US'> 4</span></span><span
 
lang=EN-US style='font-size:11.5pt;mso-bidi-font-size:12.0pt;line-height:130%;
 
font-family:inherit;color:#111111;mso-ansi-language:EN-US'>&nbsp;will not start
 
in the environment where&nbsp;</span><span class=SpellE><span class=SourceText><span
 
lang=EN-US style='font-size:10.0pt;mso-bidi-font-size:12.0pt;line-height:130%;
 
font-family:"Consolas;Menlo;Monaco;Lucida Co","serif";color:#111111;background:
 
white;mso-highlight:white;mso-ansi-language:EN-US'>pgAdmin</span></span></span><span
 
class=SourceText><span lang=EN-US style='font-size:10.0pt;mso-bidi-font-size:
 
12.0pt;line-height:130%;font-family:"Consolas;Menlo;Monaco;Lucida Co","serif";
 
color:#111111;background:white;mso-highlight:white;mso-ansi-language:EN-US'> 3</span></span><span
 
lang=EN-US style='font-size:11.5pt;mso-bidi-font-size:12.0pt;line-height:130%;
 
font-family:inherit;color:#111111;mso-ansi-language:EN-US'>&nbsp;was previously
 
installed and used because of incompatible configuration in <span class=GramE>the&nbsp;<span
 
class=SourceText><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
 
line-height:130%;font-family:"Consolas;Menlo;Monaco;Lucida Co","serif";
 
background:white;mso-highlight:white'>.<span class=SpellE>pgadmin</span></span></span></span>&nbsp;directory.
 
The simplest solution is to either clear that directory or tweak&nbsp;</span><span
 
class=SourceText><span lang=EN-US style='font-size:10.0pt;mso-bidi-font-size:
 
12.0pt;line-height:130%;font-family:"Consolas;Menlo;Monaco;Lucida Co","serif";
 
color:#111111;background:white;mso-highlight:white;mso-ansi-language:EN-US'>config_local.py</span></span><span
 
lang=EN-US style='font-size:11.5pt;mso-bidi-font-size:12.0pt;line-height:130%;
 
font-family:inherit;color:#111111;mso-ansi-language:EN-US'>&nbsp;to point to a
 
clean <span class=GramE>new&nbsp;<span class=SourceText><span style='font-size:
 
10.0pt;mso-bidi-font-size:12.0pt;line-height:130%;font-family:"Consolas;Menlo;Monaco;Lucida Co","serif";
 
background:white;mso-highlight:white'>.pgadmin</span></span></span></span><span
 
class=SourceText><span lang=EN-US style='font-size:10.0pt;mso-bidi-font-size:
 
12.0pt;line-height:130%;font-family:"Consolas;Menlo;Monaco;Lucida Co","serif";
 
color:#111111;background:white;mso-highlight:white;mso-ansi-language:EN-US'>4</span></span><span
 
lang=EN-US style='font-size:11.5pt;mso-bidi-font-size:12.0pt;line-height:130%;
 
font-family:inherit;color:#111111;mso-ansi-language:EN-US'>directory.</span><span
 
lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
 
 
 
<p class=MsoBodyText style='margin-top:3.05pt;margin-right:0cm;margin-bottom:
 
3.05pt;margin-left:0cm'><span lang=EN-US style='font-family:inherit;mso-ansi-language:
 
EN-US'><o:p>&nbsp;</o:p></span></p>
 
 
 
<p style='margin-top:0cm;margin-right:0cm;margin-bottom:12.0pt;margin-left:
 
36.0pt;text-indent:-18.0pt;mso-list:l5 level1 lfo2;background:white;vertical-align:
 
baseline'><![if !supportLists]><b style='mso-bidi-font-weight:normal'><span
 
lang=EN-US style='font-size:13.0pt;mso-bidi-font-size:11.5pt;font-family:Arial;
 
mso-fareast-font-family:Arial;color:#242729;mso-ansi-language:EN-US'><span
 
style='mso-list:Ignore'>2.<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 
</span></span></span></b><![endif]><b style='mso-bidi-font-weight:normal'><span
 
lang=EN-US style='font-size:14.0pt;mso-bidi-font-size:11.5pt;font-family:Arial;
 
color:#242729;mso-ansi-language:EN-US'>REMOTE ACCESS (For CLOUD Install)<o:p></o:p></span></b></p>
 
 
 
<p style='margin-top:0cm;margin-right:0cm;margin-bottom:12.0pt;margin-left:
 
0cm;background:white;vertical-align:baseline'><b style='mso-bidi-font-weight:
 
normal'><span lang=EN-US style='font-size:11.5pt;font-family:Arial;color:#242729;
 
mso-ansi-language:EN-US'>PGAdmin4 Folder:
 
~/pgadmin4/lib/python3.X/site-packages/pgadmin4<o:p></o:p></span></b></p>
 
 
 
<p style='margin-top:0cm;margin-right:0cm;margin-bottom:12.0pt;margin-left:
 
0cm;background:white;vertical-align:baseline'><span lang=EN-US
 
style='font-size:11.5pt;font-family:Arial;color:#242729;mso-ansi-language:EN-US'>(Replace
 
3.X with your Python Version)<o:p></o:p></span></p>
 
 
 
<p style='margin-top:0cm;margin-right:0cm;margin-bottom:12.0pt;margin-left:
 
0cm;background:white;vertical-align:baseline'><span lang=EN-US
 
style='font-size:11.5pt;font-family:Arial;color:#242729;mso-ansi-language:EN-US'>You
 
need to add below <span class=SpellE>config</span> options,<o:p></o:p></span></p>
 
 
 
<p style='margin:0cm;margin-bottom:.0001pt;background:white;vertical-align:
 
baseline'><strong><span lang=EN-US style='font-size:11.5pt;font-family:inherit;
 
mso-bidi-font-family:Arial;color:#242729;border:none windowtext 1.0pt;
 
mso-border-alt:none windowtext 0cm;padding:0cm;mso-ansi-language:EN-US'>DEFAULT_SERVER
 
= '0.0.0.0'</span></strong><span lang=EN-US style='font-size:11.5pt;font-family:
 
Arial;color:#242729;mso-ansi-language:EN-US'><o:p></o:p></span></p>
 
 
 
<p style='margin:0cm;margin-bottom:.0001pt;background:white;vertical-align:
 
baseline'><span lang=EN-US style='font-size:11.5pt;font-family:Arial;
 
color:#242729;mso-ansi-language:EN-US'>in&nbsp;</span><strong><span lang=EN-US
 
style='font-size:11.5pt;font-family:inherit;mso-bidi-font-family:Arial;
 
color:#242729;border:none windowtext 1.0pt;mso-border-alt:none windowtext 0cm;
 
padding:0cm;mso-ansi-language:EN-US'>config_local.py</span></strong><span
 
lang=EN-US style='font-size:11.5pt;font-family:Arial;color:#242729;mso-ansi-language:
 
EN-US'>&nbsp;(in &quot;pgAdmin4&quot; folder).<o:p></o:p></span></p>
 
 
 
<p style='margin-top:0cm;margin-right:0cm;margin-bottom:12.0pt;margin-left:
 
0cm;background:white;vertical-align:baseline'><span lang=EN-US
 
style='font-size:11.5pt;font-family:Arial;color:#242729;mso-ansi-language:EN-US'>If
 
also want to change default <span class=GramE>port</span> then also add<o:p></o:p></span></p>
 
 
 
<p style='margin:0cm;margin-bottom:.0001pt;background:white;vertical-align:
 
baseline'><strong><span lang=EN-US style='font-size:11.5pt;font-family:inherit;
 
mso-bidi-font-family:Arial;color:#242729;border:none windowtext 1.0pt;
 
mso-border-alt:none windowtext 0cm;padding:0cm;mso-ansi-language:EN-US'>DEFAULT_SERVER_PORT
 
= 5050<o:p></o:p></span></strong></p>
 
 
 
<p style='margin:0cm;margin-bottom:.0001pt;background:white;vertical-align:
 
baseline'><strong><span lang=EN-US style='font-size:11.5pt;font-family:inherit;
 
mso-bidi-font-family:Arial;color:#242729;border:none windowtext 1.0pt;
 
mso-border-alt:none windowtext 0cm;padding:0cm;mso-ansi-language:EN-US'><o:p>&nbsp;</o:p></span></strong></p>
 
 
 
<p style='margin:0cm;margin-bottom:.0001pt;background:white;vertical-align:
 
baseline'><span lang=EN-US style='font-size:11.5pt;font-family:Arial;
 
color:#242729;mso-ansi-language:EN-US'><o:p>&nbsp;</o:p></span></p>
 
 
 
<p style='margin-top:0cm;margin-right:0cm;margin-bottom:12.0pt;margin-left:
 
36.0pt;text-indent:-18.0pt;mso-list:l5 level1 lfo2;background:white;vertical-align:
 
baseline'><![if !supportLists]><b style='mso-bidi-font-weight:normal'><span
 
lang=EN-US style='font-size:13.0pt;mso-bidi-font-size:11.5pt;font-family:Arial;
 
mso-fareast-font-family:Arial;color:#242729;mso-ansi-language:EN-US'><span
 
style='mso-list:Ignore'>3.<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 
</span></span></span></b><![endif]><b style='mso-bidi-font-weight:normal'><span
 
lang=EN-US style='font-size:14.0pt;mso-bidi-font-size:11.5pt;font-family:Arial;
 
color:#242729;mso-ansi-language:EN-US'>RUN as a Service<o:p></o:p></span></b></p>
 
 
 
<p style='margin-top:0cm;margin-right:0cm;margin-bottom:12.0pt;margin-left:
 
0cm;background:white;vertical-align:baseline'><b style='mso-bidi-font-weight:
 
normal'><span lang=EN-US style='font-size:11.5pt;font-family:Arial;color:#242729;
 
mso-ansi-language:EN-US'>Python file:<span style='mso-spacerun:yes'>&nbsp;
 
</span>~/pgadmin4/lib/python3.x/site-packages/pgadmin4/pgAdmin4.py<o:p></o:p></span></b></p>
 
 
 
<p style='margin-top:0cm;margin-right:0cm;margin-bottom:12.0pt;margin-left:
 
0cm;background:white;vertical-align:baseline'><b style='mso-bidi-font-weight:
 
normal'><span lang=EN-US style='font-size:11.5pt;font-family:Arial;color:#242729;
 
mso-ansi-language:EN-US'>PGAdmin4 Folder:
 
~/pgadmin4/lib/python3.X/site-packages/pgadmin4<o:p></o:p></span></b></p>
 
 
 
<p align=center style='margin-top:0cm;margin-right:0cm;margin-bottom:12.0pt;
 
margin-left:0cm;text-align:center;background:white;vertical-align:baseline'><span
 
lang=EN-US style='font-size:10.5pt;mso-bidi-font-size:11.5pt;font-family:Arial;
 
color:#242729;mso-ansi-language:EN-US'>(Replace 3.X with your Python Version)<o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='margin-bottom:12.75pt;line-height:21.0pt;background:
 
white'><span lang=EN-US style='font-size:10.5pt;font-family:Arial;color:#313131;
 
mso-ansi-language:EN-US;mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>Before
 
we start letÕs exit the virtual <span class=SpellE>enviroment</span> using the <span
 
class=SpellE>follwoing</span> command:<o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='margin-bottom:15.0pt;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;
 
background:#F4F4F4;word-break:break-all'><span lang=EN-US style='font-size:
 
10.5pt;font-family:Arial;color:#313131;mso-ansi-language:EN-US;mso-fareast-language:
 
ES-TRAD;mso-bidi-language:AR-SA'># deactivate<o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='line-height:21.0pt;background:white'><span
 
lang=EN-US style='font-size:10.5pt;font-family:Arial;color:#313131;mso-ansi-language:
 
EN-US;mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>Ð To make&nbsp;<span
 
class=SpellE><b>PgAdmin</b></span><b> 4</b>&nbsp;we need to make some extra
 
modification, Open the&nbsp;<b>pgAdmin4.py</b>&nbsp;file and insert the
 
following line in the begin of the file:<o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='margin-bottom:15.0pt;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;
 
background:#F4F4F4;word-break:break-all'><span lang=EN-US style='font-size:
 
10.5pt;font-family:Arial;color:#313131;mso-ansi-language:EN-US;mso-fareast-language:
 
ES-TRAD;mso-bidi-language:AR-SA'># vi
 
~/pgadmin4/lib/python3.x/site-packages/pgadmin4/pgAdmin4.py<o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;
 
background:#F4F4F4;word-break:break-all'><span class=GramE><span lang=EN-US
 
style='font-size:10.5pt;font-family:Arial;color:red;mso-ansi-language:EN-US;
 
mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>#!/</span></span><span
 
class=SpellE><span lang=EN-US style='font-size:10.5pt;font-family:Arial;
 
color:red;mso-ansi-language:EN-US;mso-fareast-language:ES-TRAD;mso-bidi-language:
 
AR-SA'>usr</span></span><span lang=EN-US style='font-size:10.5pt;font-family:
 
Arial;color:red;mso-ansi-language:EN-US;mso-fareast-language:ES-TRAD;
 
mso-bidi-language:AR-SA'>/bin/<span class=SpellE>env</span> python3</span><span
 
lang=EN-US style='font-size:10.5pt;font-family:Arial;color:#313131;mso-ansi-language:
 
EN-US;mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'><o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;
 
background:#F4F4F4;word-break:break-all'><span lang=EN-US style='font-size:
 
10.5pt;font-family:Arial;color:#313131;mso-ansi-language:EN-US;mso-fareast-language:
 
ES-TRAD;mso-bidi-language:AR-SA'>[...]<o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='margin-bottom:12.75pt;line-height:21.0pt;background:
 
white'><span lang=EN-US style='font-size:10.5pt;font-family:Arial;color:#313131;
 
mso-ansi-language:EN-US;mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>Ð
 
Make it executable by doing:<o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='margin-bottom:15.0pt;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;
 
background:#F4F4F4;word-break:break-all'><span lang=EN-US style='font-size:
 
10.5pt;font-family:Arial;color:#313131;mso-ansi-language:EN-US;mso-fareast-language:
 
ES-TRAD;mso-bidi-language:AR-SA'># <span class=SpellE>chmod</span> +<span
 
class=GramE>x<span style='mso-spacerun:yes'>&nbsp; </span>~</span>/pgadmin4/lib/python3.x/site-packages/pgadmin4/pgAdmin4.py<o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='line-height:21.0pt;background:white'><span
 
lang=EN-US style='font-size:10.5pt;font-family:Times;mso-bidi-font-family:"Times New Roman";
 
color:#313131;mso-ansi-language:EN-US;mso-fareast-language:ES-TRAD;mso-bidi-language:
 
AR-SA'>Ð Now create a&nbsp;<b>/<span class=SpellE>etc</span>/<span
 
class=SpellE>systemd</span>/system/pgadmin4.service</b>&nbsp;service file
 
containing:<o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='margin-bottom:15.0pt;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;
 
background:#F4F4F4;word-break:break-all'><span lang=EN-US style='font-size:
 
10.5pt;font-family:"Courier New";color:#313131;mso-ansi-language:EN-US;
 
mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'># vi /<span class=SpellE>etc</span>/<span
 
class=SpellE>systemd</span>/system/pgadmin4.service<o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt;
 
mso-layout-grid-align:none;text-autospace:none'><span style='font-size:11.0pt;
 
font-family:Menlo;color:#A100A3;mso-ansi-language:ES-TRAD;mso-bidi-language:
 
AR-SA'>[</span><span class=SpellE><span style='font-size:11.0pt;font-family:
 
Menlo;color:#C814C9;mso-ansi-language:ES-TRAD;mso-bidi-language:AR-SA'>Unit</span></span><span
 
style='font-size:11.0pt;font-family:Menlo;color:#A100A3;mso-ansi-language:ES-TRAD;
 
mso-bidi-language:AR-SA'>]</span><span style='font-size:11.0pt;font-family:
 
Menlo;color:black;mso-ansi-language:ES-TRAD;mso-bidi-language:AR-SA'><o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt;
 
mso-layout-grid-align:none;text-autospace:none'><span class=SpellE><span
 
style='font-size:11.0pt;font-family:Menlo;color:#2FB41D;mso-ansi-language:ES-TRAD;
 
mso-bidi-language:AR-SA'>Description</span></span><span style='font-size:11.0pt;
 
font-family:Menlo;color:#2FB41D;mso-ansi-language:ES-TRAD;mso-bidi-language:
 
AR-SA'>=</span><span style='font-size:11.0pt;font-family:Menlo;color:black;
 
mso-ansi-language:ES-TRAD;mso-bidi-language:AR-SA'>Pgadmin4 <span class=SpellE>Service</span><o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt;
 
mso-layout-grid-align:none;text-autospace:none'><span class=SpellE><span
 
style='font-size:11.0pt;font-family:Menlo;color:#2FB41D;mso-ansi-language:ES-TRAD;
 
mso-bidi-language:AR-SA'>After</span></span><span style='font-size:11.0pt;
 
font-family:Menlo;color:#2FB41D;mso-ansi-language:ES-TRAD;mso-bidi-language:
 
AR-SA'>=</span><span class=SpellE><span style='font-size:11.0pt;font-family:
 
Menlo;color:black;mso-ansi-language:ES-TRAD;mso-bidi-language:AR-SA'>network.target</span></span><span
 
style='font-size:11.0pt;font-family:Menlo;color:black;mso-ansi-language:ES-TRAD;
 
mso-bidi-language:AR-SA'><o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt;
 
mso-layout-grid-align:none;text-autospace:none'><span style='font-size:11.0pt;
 
font-family:Menlo;color:black;mso-ansi-language:ES-TRAD;mso-bidi-language:AR-SA'><o:p>&nbsp;</o:p></span></p>
 
 
 
<p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt;
 
mso-layout-grid-align:none;text-autospace:none'><span style='font-size:11.0pt;
 
font-family:Menlo;color:#C814C9;mso-ansi-language:ES-TRAD;mso-bidi-language:
 
AR-SA'>[<span class=SpellE>Service</span>]</span><span style='font-size:11.0pt;
 
font-family:Menlo;color:black;mso-ansi-language:ES-TRAD;mso-bidi-language:AR-SA'><o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt;
 
mso-layout-grid-align:none;text-autospace:none'><span class=SpellE><span
 
style='font-size:11.0pt;font-family:Menlo;color:#2FB41D;mso-ansi-language:ES-TRAD;
 
mso-bidi-language:AR-SA'>User</span></span><span style='font-size:11.0pt;
 
font-family:Menlo;color:#2FB41D;mso-ansi-language:ES-TRAD;mso-bidi-language:
 
AR-SA'>=</span><span class=SpellE><span style='font-size:11.0pt;font-family:
 
Menlo;color:black;mso-ansi-language:ES-TRAD;mso-bidi-language:AR-SA'>root</span></span><span
 
style='font-size:11.0pt;font-family:Menlo;color:black;mso-ansi-language:ES-TRAD;
 
mso-bidi-language:AR-SA'><o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt;
 
mso-layout-grid-align:none;text-autospace:none'><span class=SpellE><span
 
style='font-size:11.0pt;font-family:Menlo;color:#2FB41D;mso-ansi-language:ES-TRAD;
 
mso-bidi-language:AR-SA'>Group</span></span><span style='font-size:11.0pt;
 
font-family:Menlo;color:#2FB41D;mso-ansi-language:ES-TRAD;mso-bidi-language:
 
AR-SA'>=</span><span class=SpellE><span style='font-size:11.0pt;font-family:
 
Menlo;color:black;mso-ansi-language:ES-TRAD;mso-bidi-language:AR-SA'>root</span></span><span
 
style='font-size:11.0pt;font-family:Menlo;color:black;mso-ansi-language:ES-TRAD;
 
mso-bidi-language:AR-SA'><o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt;
 
mso-layout-grid-align:none;text-autospace:none'><span style='font-size:11.0pt;
 
font-family:Menlo;color:#400BD9;mso-ansi-language:ES-TRAD;mso-bidi-language:
 
AR-SA'># Point to <span class=SpellE>the</span> virtual <span class=SpellE>environment</span>
 
<span class=SpellE>directory</span></span><span style='font-size:11.0pt;
 
font-family:Menlo;color:black;mso-ansi-language:ES-TRAD;mso-bidi-language:AR-SA'><o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt;
 
mso-layout-grid-align:none;text-autospace:none'><span class=SpellE><span
 
style='font-size:11.0pt;font-family:Menlo;color:#2FB41D;mso-ansi-language:ES-TRAD;
 
mso-bidi-language:AR-SA'>WorkingDirectory</span></span><span style='font-size:
 
11.0pt;font-family:Menlo;color:#2FB41D;mso-ansi-language:ES-TRAD;mso-bidi-language:
 
AR-SA'>=</span><span style='font-size:11.0pt;font-family:Menlo;color:black;
 
mso-ansi-language:ES-TRAD;mso-bidi-language:AR-SA'>/<span class=SpellE>root</span>/pgadmin4<o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt;
 
mso-layout-grid-align:none;text-autospace:none'><span style='font-size:11.0pt;
 
font-family:Menlo;color:#400BD9;mso-ansi-language:ES-TRAD;mso-bidi-language:
 
AR-SA'># Point to <span class=SpellE>the</span> <span class=SpellE>bin</span>
 
folder of <span class=SpellE>your</span> virtual <span class=SpellE>environment</span></span><span
 
style='font-size:11.0pt;font-family:Menlo;color:black;mso-ansi-language:ES-TRAD;
 
mso-bidi-language:AR-SA'><o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt;
 
mso-layout-grid-align:none;text-autospace:none'><span style='font-size:11.0pt;
 
font-family:Menlo;color:#400BD9;mso-ansi-language:ES-TRAD;mso-bidi-language:
 
AR-SA'># <span class=SpellE>Environment</span>=&quot;PATH=/home/<span
 
class=SpellE>qgis</span>/<span class=SpellE>Downloads</span>/pgadmin4/<span
 
class=SpellE>bin</span>&quot;</span><span style='font-size:11.0pt;font-family:
 
Menlo;color:black;mso-ansi-language:ES-TRAD;mso-bidi-language:AR-SA'><o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt;
 
mso-layout-grid-align:none;text-autospace:none'><span class=SpellE><span
 
style='font-size:11.0pt;font-family:Menlo;color:#2FB41D;mso-ansi-language:ES-TRAD;
 
mso-bidi-language:AR-SA'>Environment</span></span><span style='font-size:11.0pt;
 
font-family:Menlo;color:#2FB41D;mso-ansi-language:ES-TRAD;mso-bidi-language:
 
AR-SA'>=</span><span style='font-size:11.0pt;font-family:Menlo;color:black;
 
mso-ansi-language:ES-TRAD;mso-bidi-language:AR-SA'>&quot;PATH=/<span
 
class=SpellE>root</span>/pgadmin4/<span class=SpellE>bin</span>&quot;<o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt;
 
mso-layout-grid-align:none;text-autospace:none'><span style='font-size:11.0pt;
 
font-family:Menlo;color:#400BD9;mso-ansi-language:ES-TRAD;mso-bidi-language:
 
AR-SA'># <span class=SpellE>ExecStart</span>=/home/<span class=SpellE>qgis</span>/<span
 
class=SpellE>Downloads</span>/pgadmin4/<span class=SpellE>bin</span>/<span
 
class=SpellE>python</span>
 
/home/web/Downloads/pgadmin4/lib/python3.6/site-packages/pgadmin4/pgAdmin4.py</span><span
 
style='font-size:11.0pt;font-family:Menlo;color:black;mso-ansi-language:ES-TRAD;
 
mso-bidi-language:AR-SA'><o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt;
 
mso-layout-grid-align:none;text-autospace:none'><span style='font-size:11.0pt;
 
font-family:Menlo;color:#2FB41D;mso-ansi-language:ES-TRAD;mso-bidi-language:
 
AR-SA'>ExecStart=</span><span style='font-size:11.0pt;font-family:Menlo;
 
color:black;mso-ansi-language:ES-TRAD;mso-bidi-language:AR-SA'>&quot;/root/pgadmin4/lib/python3.</span><span
 
style='font-size:11.0pt;font-family:Menlo;color:#B42419;mso-ansi-language:ES-TRAD;
 
mso-bidi-language:AR-SA'>5</span><span style='font-size:11.0pt;font-family:
 
Menlo;color:black;mso-ansi-language:ES-TRAD;mso-bidi-language:AR-SA'>/site-packages/pgadmin4/pgAdmin4.py&quot;<o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt;
 
mso-layout-grid-align:none;text-autospace:none'><span class=SpellE><span
 
style='font-size:11.0pt;font-family:Menlo;color:#2FB41D;mso-ansi-language:ES-TRAD;
 
mso-bidi-language:AR-SA'>PrivateTmp</span></span><span style='font-size:11.0pt;
 
font-family:Menlo;color:#2FB41D;mso-ansi-language:ES-TRAD;mso-bidi-language:
 
AR-SA'>=</span><span style='font-size:11.0pt;font-family:Menlo;color:black;
 
mso-ansi-language:ES-TRAD;mso-bidi-language:AR-SA'>true<o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt;
 
mso-layout-grid-align:none;text-autospace:none'><span style='font-size:11.0pt;
 
font-family:Menlo;color:black;mso-ansi-language:ES-TRAD;mso-bidi-language:AR-SA'><o:p>&nbsp;</o:p></span></p>
 
 
 
<p class=MsoNormal style='mso-pagination:none;tab-stops:28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt;
 
mso-layout-grid-align:none;text-autospace:none'><span style='font-size:11.0pt;
 
font-family:Menlo;color:#C814C9;mso-ansi-language:ES-TRAD;mso-bidi-language:
 
AR-SA'>[<span class=SpellE>Install</span>]</span><span style='font-size:11.0pt;
 
font-family:Menlo;color:black;mso-ansi-language:ES-TRAD;mso-bidi-language:AR-SA'><o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='margin-bottom:12.75pt;line-height:21.0pt;background:
 
white'><span class=SpellE><span style='font-size:11.0pt;font-family:Menlo;
 
color:#2FB41D;mso-ansi-language:ES-TRAD;mso-bidi-language:AR-SA'>WantedBy</span></span><span
 
style='font-size:11.0pt;font-family:Menlo;color:#2FB41D;mso-ansi-language:ES-TRAD;
 
mso-bidi-language:AR-SA'>=</span><span class=SpellE><span style='font-size:
 
11.0pt;font-family:Menlo;color:black;mso-ansi-language:ES-TRAD;mso-bidi-language:
 
AR-SA'>multi-user.target</span></span><span style='font-size:11.0pt;font-family:
 
Menlo;color:black;mso-ansi-language:ES-TRAD;mso-bidi-language:AR-SA'><o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='margin-bottom:12.75pt;line-height:21.0pt;background:
 
white'><span lang=EN-US style='font-size:10.5pt;font-family:Times;mso-bidi-font-family:
 
"Times New Roman";color:#313131;mso-ansi-language:EN-US;mso-fareast-language:
 
ES-TRAD;mso-bidi-language:AR-SA'>Ð Enable and start <span class=SpellE>PgAdmin</span>
 
Service at system boot:<o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='margin-bottom:15.0pt;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;
 
background:#F4F4F4;word-break:break-all'><span lang=EN-US style='font-size:
 
10.5pt;font-family:"Courier New";color:#313131;mso-ansi-language:EN-US;
 
mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'># <span class=SpellE>sudo</span>
 
<span class=SpellE>systemctl</span> daemon-reload<o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='margin-bottom:15.0pt;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;
 
background:#F4F4F4;word-break:break-all'><span lang=EN-US style='font-size:
 
10.5pt;font-family:"Courier New";color:#313131;mso-ansi-language:EN-US;
 
mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'># <span class=SpellE>sudo</span>
 
<span class=SpellE>systemctl</span> enable pgadmin4<o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='margin-bottom:15.0pt;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;
 
background:#F4F4F4;word-break:break-all'><span lang=EN-US style='font-size:
 
10.5pt;font-family:"Courier New";color:#313131;mso-ansi-language:EN-US;
 
mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'># <span class=SpellE>sudo</span>
 
<span class=SpellE>systemctl</span> start pgadmin4<o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='margin-bottom:15.0pt;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;
 
background:#F4F4F4;word-break:break-all'><span lang=EN-US style='font-size:
 
10.5pt;font-family:"Courier New";color:#313131;mso-ansi-language:EN-US;
 
mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'># <span class=SpellE>sudo</span>
 
<span class=SpellE>systemctl</span> <span class=GramE>status<span
 
style='mso-spacerun:yes'>&nbsp; </span>pgadmin</span>4<o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='margin-bottom:12.75pt;mso-line-height-alt:15.6pt;
 
mso-outline-level:2;background:white'><b><span lang=EN-US style='font-size:
 
16.5pt;font-family:Helvetica;mso-fareast-font-family:"Times New Roman";
 
mso-bidi-font-family:"Times New Roman";color:#313131;mso-ansi-language:EN-US;
 
mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'><o:p>&nbsp;</o:p></span></b></p>
 
 
 
<p style='margin-top:0cm;margin-right:0cm;margin-bottom:12.0pt;margin-left:
 
36.0pt;text-indent:-18.0pt;mso-list:l5 level1 lfo2;background:white;vertical-align:
 
baseline'><![if !supportLists]><b style='mso-bidi-font-weight:normal'><span
 
lang=EN-US style='font-size:13.0pt;mso-bidi-font-size:11.5pt;font-family:Arial;
 
mso-fareast-font-family:Arial;color:#242729;mso-ansi-language:EN-US'><span
 
style='mso-list:Ignore'>4.<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 
</span></span></span></b><![endif]><b style='mso-bidi-font-weight:normal'><span
 
lang=EN-US style='font-size:14.0pt;mso-bidi-font-size:11.5pt;font-family:Arial;
 
color:#242729;mso-ansi-language:EN-US'>Access <span class=SpellE>PGAdmin</span>
 
4<o:p></o:p></span></b></p>
 
 
 
<p class=MsoNormal style='line-height:21.0pt;background:white'><span
 
lang=EN-US style='font-size:10.5pt;font-family:Times;mso-bidi-font-family:"Times New Roman";
 
color:#313131;mso-ansi-language:EN-US;mso-fareast-language:ES-TRAD;mso-bidi-language:
 
AR-SA'>Ð Open&nbsp;<b>http://Server_ip:5050</b>&nbsp;and logon to the <span
 
class=SpellE>PgAdmin</span> using your credentials.<o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='line-height:21.0pt;background:white'><span
 
lang=EN-US style='font-size:10.5pt;font-family:Times;mso-bidi-font-family:"Times New Roman";
 
color:#313131;mso-ansi-language:EN-US;mso-fareast-language:ES-TRAD;mso-bidi-language:
 
AR-SA'><o:p>&nbsp;</o:p></span></p>
 
 
 
<p class=MsoNormal style='line-height:21.0pt;background:white'><span
 
lang=EN-US style='font-size:10.5pt;font-family:Times;mso-bidi-font-family:"Times New Roman";
 
color:#313131;mso-ansi-language:EN-US;mso-fareast-language:ES-TRAD;mso-bidi-language:
 
AR-SA'><o:p>&nbsp;</o:p></span></p>
 
 
 
<p style='margin-top:0cm;margin-right:0cm;margin-bottom:12.0pt;margin-left:
 
36.0pt;text-indent:-18.0pt;mso-list:l5 level1 lfo2;background:white;vertical-align:
 
baseline'><![if !supportLists]><b style='mso-bidi-font-weight:normal'><span
 
lang=EN-US style='font-size:13.0pt;mso-bidi-font-size:11.5pt;font-family:Arial;
 
mso-fareast-font-family:Arial;color:#242729;mso-ansi-language:EN-US'><span
 
style='mso-list:Ignore'>5.<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 
</span></span></span></b><![endif]><b style='mso-bidi-font-weight:normal'><span
 
lang=EN-US style='font-size:14.0pt;mso-bidi-font-size:11.5pt;font-family:Arial;
 
color:#242729;mso-ansi-language:EN-US'>Enable <span class=SpellE>Postgresql</span>
 
Remote Access.<o:p></o:p></span></b></p>
 
 
 
<p class=MsoNormal style='margin-bottom:7.5pt'><b><span style='font-family:
 
"Playfair Display","serif";mso-bidi-font-family:"Times New Roman";color:#525252;
 
mso-ansi-language:ES-TRAD;mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'><o:p>&nbsp;</o:p></span></b></p>
 
 
 
<p class=MsoNormal style='margin-bottom:7.5pt'><b><span style='font-family:
 
"Playfair Display","serif";mso-bidi-font-family:"Times New Roman";color:#525252;
 
mso-ansi-language:ES-TRAD;mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>5.1.
 
Permitir conexiones de clientes desde un determinado rango</span></b><span
 
style='font-family:"Playfair Display","serif";mso-bidi-font-family:"Times New Roman";
 
color:#525252;mso-ansi-language:ES-TRAD;mso-fareast-language:ES-TRAD;
 
mso-bidi-language:AR-SA'><o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='margin-bottom:7.5pt'><span style='font-family:"Playfair Display","serif";
 
mso-bidi-font-family:"Times New Roman";color:#525252;mso-ansi-language:ES-TRAD;
 
mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>Llegamos a uno de los
 
puntos importantes de la cuesti—n, el fichero&nbsp;<span class=SpellE><i>pg_hba.conf</i></span>.
 
Su situaci—n exacta depender‡ de vuestra instalaci—n, pero lo encontrarŽis en
 
una de estas dos rutas:<o:p></o:p></span></p>
 
 
 
<ul type=square>
 
<li class=MsoNormal style='color:#525252;mso-margin-top-alt:auto;mso-margin-bottom-alt:
 
    auto;mso-list:l4 level1 lfo3;tab-stops:list 36.0pt'><i><span
 
    style='font-family:"Playfair Display","serif";mso-fareast-font-family:
 
    "Times New Roman";mso-bidi-font-family:"Times New Roman";mso-ansi-language:
 
    ES-TRAD;mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>/<span
 
    class=SpellE>var</span>/<span class=SpellE>lib</span>/<span class=SpellE>pgsql</span>/data/<span
 
    class=SpellE>pg_hba.conf</span>&nbsp;</span></i><span style='font-family:
 
    "Playfair Display","serif";mso-fareast-font-family:"Times New Roman";
 
    mso-bidi-font-family:"Times New Roman";mso-ansi-language:ES-TRAD;
 
    mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>(en mi instalaci—n
 
    lo tengo ah’, utilizo&nbsp;</span><span lang=ES style='color:windowtext'><a
 
    href="http://es.wikipedia.org/wiki/Scientific_Linux" target="_blank"><span
 
    class=SpellE><span lang=ES-TRAD style='font-family:"Playfair Display","serif";
 
    mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:"Times New Roman";
 
    color:#EFA48D;mso-ansi-language:ES-TRAD;mso-fareast-language:ES-TRAD;
 
    mso-bidi-language:AR-SA;text-decoration:none;text-underline:none'>Scientific</span></span><span
 
    lang=ES-TRAD style='font-family:"Playfair Display","serif";mso-fareast-font-family:
 
    "Times New Roman";mso-bidi-font-family:"Times New Roman";color:#EFA48D;
 
    mso-ansi-language:ES-TRAD;mso-fareast-language:ES-TRAD;mso-bidi-language:
 
    AR-SA;text-decoration:none;text-underline:none'> Linux</span></a></span><span
 
    style='font-family:"Playfair Display","serif";mso-fareast-font-family:
 
    "Times New Roman";mso-bidi-font-family:"Times New Roman";mso-ansi-language:
 
    ES-TRAD;mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>, una
 
    distribuci—n derivada de&nbsp;</span><span lang=ES style='color:windowtext'><a
 
    href="http://es.wikipedia.org/wiki/Red_Hat_Enterprise_Linux"
 
    target="_blank"><span lang=ES-TRAD style='font-family:"Playfair Display","serif";
 
    mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:"Times New Roman";
 
    color:#EFA48D;mso-ansi-language:ES-TRAD;mso-fareast-language:ES-TRAD;
 
    mso-bidi-language:AR-SA;text-decoration:none;text-underline:none'>Red <span
 
    class=SpellE>Hat</span></span></a></span><span style='font-family:"Playfair Display","serif";
 
    mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:"Times New Roman";
 
    mso-ansi-language:ES-TRAD;mso-fareast-language:ES-TRAD;mso-bidi-language:
 
    AR-SA'>)<o:p></o:p></span></li>
 
<li class=MsoNormal style='color:#525252;mso-margin-top-alt:auto;mso-margin-bottom-alt:
 
    auto;mso-list:l4 level1 lfo3;tab-stops:list 36.0pt'><i><span
 
    style='font-family:"Playfair Display","serif";mso-fareast-font-family:
 
    "Times New Roman";mso-bidi-font-family:"Times New Roman";mso-ansi-language:
 
    ES-TRAD;mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>/<span
 
    class=SpellE>etc</span>/<span class=SpellE>postgresql</span>/<span
 
    class=SpellE>main</span>/<span class=SpellE>pg_hba.conf</span></span></i><span
 
    style='font-family:"Playfair Display","serif";mso-fareast-font-family:
 
    "Times New Roman";mso-bidi-font-family:"Times New Roman";mso-ansi-language:
 
    ES-TRAD;mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'><o:p></o:p></span></li>
 
</ul>
 
 
 
<p class=MsoNormal style='margin-bottom:7.5pt'><span style='font-family:"Playfair Display","serif";
 
mso-bidi-font-family:"Times New Roman";color:#525252;mso-ansi-language:ES-TRAD;
 
mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>Dentro de este fichero,
 
al final del mismo, veremos algo as’:<o:p></o:p></span></p>
 
 
 
<table class=MsoNormalTable border=0 cellpadding=0 style='mso-cellspacing:1.5pt;
 
mso-yfti-tbllook:1184'>
 
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes'>
 
  <td style='padding:.75pt .75pt .75pt .75pt'>
 
  <p class=MsoNormal align=center style='text-align:center'><span
 
  style='font-size:9.0pt;font-family:inherit;mso-fareast-font-family:"Times New Roman";
 
  mso-bidi-font-family:"Times New Roman";mso-ansi-language:ES-TRAD;mso-fareast-language:
 
  ES-TRAD;mso-bidi-language:AR-SA'>1<o:p></o:p></span></p>
 
  <p class=MsoNormal align=center style='text-align:center'><span
 
  style='font-size:9.0pt;font-family:inherit;mso-fareast-font-family:"Times New Roman";
 
  mso-bidi-font-family:"Times New Roman";mso-ansi-language:ES-TRAD;mso-fareast-language:
 
  ES-TRAD;mso-bidi-language:AR-SA'>2<o:p></o:p></span></p>
 
  <p class=MsoNormal align=center style='text-align:center'><span
 
  style='font-size:9.0pt;font-family:inherit;mso-fareast-font-family:"Times New Roman";
 
  mso-bidi-font-family:"Times New Roman";mso-ansi-language:ES-TRAD;mso-fareast-language:
 
  ES-TRAD;mso-bidi-language:AR-SA'>3<o:p></o:p></span></p>
 
  <p class=MsoNormal align=center style='text-align:center'><span
 
  style='font-size:9.0pt;font-family:inherit;mso-fareast-font-family:"Times New Roman";
 
  mso-bidi-font-family:"Times New Roman";mso-ansi-language:ES-TRAD;mso-fareast-language:
 
  ES-TRAD;mso-bidi-language:AR-SA'>4<o:p></o:p></span></p>
 
  <p class=MsoNormal align=center style='text-align:center'><span
 
  style='font-size:9.0pt;font-family:inherit;mso-fareast-font-family:"Times New Roman";
 
  mso-bidi-font-family:"Times New Roman";mso-ansi-language:ES-TRAD;mso-fareast-language:
 
  ES-TRAD;mso-bidi-language:AR-SA'>5<o:p></o:p></span></p>
 
  <p class=MsoNormal align=center style='text-align:center'><span
 
  style='font-size:9.0pt;font-family:inherit;mso-fareast-font-family:"Times New Roman";
 
  mso-bidi-font-family:"Times New Roman";mso-ansi-language:ES-TRAD;mso-fareast-language:
 
  ES-TRAD;mso-bidi-language:AR-SA'>6<o:p></o:p></span></p>
 
  <p class=MsoNormal align=center style='text-align:center'><span
 
  style='font-size:9.0pt;font-family:inherit;mso-fareast-font-family:"Times New Roman";
 
  mso-bidi-font-family:"Times New Roman";mso-ansi-language:ES-TRAD;mso-fareast-language:
 
  ES-TRAD;mso-bidi-language:AR-SA'>7<o:p></o:p></span></p>
 
  <p class=MsoNormal align=center style='text-align:center'><span
 
  style='font-size:9.0pt;font-family:inherit;mso-fareast-font-family:"Times New Roman";
 
  mso-bidi-font-family:"Times New Roman";mso-ansi-language:ES-TRAD;mso-fareast-language:
 
  ES-TRAD;mso-bidi-language:AR-SA'>8<o:p></o:p></span></p>
 
  </td>
 
  <td width=503 style='width:502.5pt;padding:.75pt .75pt .75pt .75pt'>
 
  <p class=MsoNormal><span style='font-size:9.0pt;font-family:inherit;
 
  mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:"Times New Roman";
 
  color:black;mso-ansi-language:ES-TRAD;mso-fareast-language:ES-TRAD;
 
  mso-bidi-language:AR-SA'># TYPE&nbsp;&nbsp;DATABASE&nbsp;&nbsp;&nbsp;&nbsp;USER&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CIDR-ADDRESS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;METHOD<o:p></o:p></span></p>
 
  <p class=MsoNormal><span style='font-size:9.0pt;font-family:inherit;
 
  mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:"Times New Roman";
 
  color:black;mso-ansi-language:ES-TRAD;mso-fareast-language:ES-TRAD;
 
  mso-bidi-language:AR-SA'>&nbsp;<o:p></o:p></span></p>
 
  <p class=MsoNormal><span style='font-size:9.0pt;font-family:inherit;
 
  mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:"Times New Roman";
 
  color:black;mso-ansi-language:ES-TRAD;mso-fareast-language:ES-TRAD;
 
  mso-bidi-language:AR-SA'># &quot;local&quot; <span class=SpellE>is</span> <span
 
  class=SpellE>for</span> Unix <span class=SpellE>domain</span> socket <span
 
  class=SpellE>connections</span> <span class=SpellE>only</span><o:p></o:p></span></p>
 
  <p class=MsoNormal><span style='font-size:9.0pt;font-family:inherit;
 
  mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:"Times New Roman";
 
  color:black;mso-ansi-language:ES-TRAD;mso-fareast-language:ES-TRAD;
 
  mso-bidi-language:AR-SA'>local&nbsp;&nbsp; <span class=SpellE>all</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 
  <span class=SpellE>all</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 
  <span class=SpellE>ident</span><o:p></o:p></span></p>
 
  <p class=MsoNormal><span style='font-size:9.0pt;font-family:inherit;
 
  mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:"Times New Roman";
 
  color:black;mso-ansi-language:ES-TRAD;mso-fareast-language:ES-TRAD;
 
  mso-bidi-language:AR-SA'># IPv4 local <span class=SpellE>connections</span>:<o:p></o:p></span></p>
 
  <p class=MsoNormal><span style='font-size:9.0pt;font-family:inherit;
 
  mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:"Times New Roman";
 
  color:black;mso-ansi-language:ES-TRAD;mso-fareast-language:ES-TRAD;
 
  mso-bidi-language:AR-SA'>host&nbsp;&nbsp;&nbsp;&nbsp;<span class=SpellE>all</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 
  <span class=SpellE>all</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 
  127.0.0.1/32&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span
 
  class=SpellE>ident</span><o:p></o:p></span></p>
 
  <p class=MsoNormal><span style='font-size:9.0pt;font-family:inherit;
 
  mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:"Times New Roman";
 
  color:black;mso-ansi-language:ES-TRAD;mso-fareast-language:ES-TRAD;
 
  mso-bidi-language:AR-SA'># IPv6 local <span class=SpellE>connections</span>:<o:p></o:p></span></p>
 
  <p class=MsoNormal><span style='font-size:9.0pt;font-family:inherit;
 
  mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:"Times New Roman";
 
  color:black;mso-ansi-language:ES-TRAD;mso-fareast-language:ES-TRAD;
 
  mso-bidi-language:AR-SA'>host&nbsp;&nbsp;&nbsp;&nbsp;<span class=SpellE>all</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 
  <span class=SpellE>all</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 
  ::1/128&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 
  <span class=SpellE>password</span><o:p></o:p></span></p>
 
  </td>
 
</tr>
 
</table>
 
 
 
<p class=MsoNormal style='margin-bottom:7.5pt'><span style='font-family:"Playfair Display","serif";
 
mso-bidi-font-family:"Times New Roman";color:#525252;mso-ansi-language:ES-TRAD;
 
mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>ÀQuŽ significa esto?
 
Veamos columna a columna:<o:p></o:p></span></p>
 
 
 
<ul type=square>
 
<li class=MsoNormal style='color:#525252;mso-margin-top-alt:auto;mso-margin-bottom-alt:
 
    auto;mso-list:l0 level1 lfo4;tab-stops:list 36.0pt'><span
 
    style='font-family:"Playfair Display","serif";mso-fareast-font-family:
 
    "Times New Roman";mso-bidi-font-family:"Times New Roman";mso-ansi-language:
 
    ES-TRAD;mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>Tipo:
 
    b‡sicamente conexi—n local o conexi—n remota (<i>host</i>).<o:p></o:p></span></li>
 
<li class=MsoNormal style='color:#525252;mso-margin-top-alt:auto;mso-margin-bottom-alt:
 
    auto;mso-list:l0 level1 lfo4;tab-stops:list 36.0pt'><span
 
    style='font-family:"Playfair Display","serif";mso-fareast-font-family:
 
    "Times New Roman";mso-bidi-font-family:"Times New Roman";mso-ansi-language:
 
    ES-TRAD;mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>Base de
 
    datos: base de datos a las que afecta la regla. Si queremos todas, usamos
 
    el comod’n&nbsp;<span class=SpellE><i>all</i></span><i>.</i><o:p></o:p></span></li>
 
<li class=MsoNormal style='color:#525252;mso-margin-top-alt:auto;mso-margin-bottom-alt:
 
    auto;mso-list:l0 level1 lfo4;tab-stops:list 36.0pt'><span
 
    style='font-family:"Playfair Display","serif";mso-fareast-font-family:
 
    "Times New Roman";mso-bidi-font-family:"Times New Roman";mso-ansi-language:
 
    ES-TRAD;mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>Usuario:
 
    usuarios a los que afecta la regla, si queremos que afecte a todos, usamos
 
    tambiŽn&nbsp;<span class=SpellE><i>all</i></span>.<o:p></o:p></span></li>
 
</ul>
 
 
 
<p class=MsoNormal style='margin-bottom:7.5pt'><span style='font-family:"Playfair Display","serif";
 
mso-bidi-font-family:"Times New Roman";color:#525252;mso-ansi-language:ES-TRAD;
 
mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>Nos paramos ahora en los
 
dos apartados que m‡s atenci—n requieren.<o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='margin-bottom:7.5pt'><b><span style='font-family:
 
"Playfair Display","serif";mso-bidi-font-family:"Times New Roman";color:#525252;
 
mso-ansi-language:ES-TRAD;mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>5.2.
 
Direcci—n</span></b><span style='font-family:"Playfair Display","serif";
 
mso-bidi-font-family:"Times New Roman";color:#525252;mso-ansi-language:ES-TRAD;
 
mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'><o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='margin-bottom:7.5pt'><span style='font-family:"Playfair Display","serif";
 
mso-bidi-font-family:"Times New Roman";color:#525252;mso-ansi-language:ES-TRAD;
 
mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>En esta columna
 
definimos, las direcciones IP (podemos tambiŽn usar IPv6), desde las que
 
podremos conectarnos a <span class=SpellE>PostgreSQL</span>. Usaremos la
 
f—rmula direcci—n/m‡scara:<o:p></o:p></span></p>
 
 
 
<ul type=square>
 
<li class=MsoNormal style='color:#525252;mso-margin-top-alt:auto;mso-margin-bottom-alt:
 
    auto;mso-list:l1 level1 lfo5;tab-stops:list 36.0pt'><span
 
    style='font-family:"Playfair Display","serif";mso-fareast-font-family:
 
    "Times New Roman";mso-bidi-font-family:"Times New Roman";mso-ansi-language:
 
    ES-TRAD;mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>Una sola
 
    direcci—n:&nbsp;<i>150.100.100.100/32</i><o:p></o:p></span></li>
 
<li class=MsoNormal style='color:#525252;mso-margin-top-alt:auto;mso-margin-bottom-alt:
 
    auto;mso-list:l1 level1 lfo5;tab-stops:list 36.0pt'><span
 
    style='font-family:"Playfair Display","serif";mso-fareast-font-family:
 
    "Times New Roman";mso-bidi-font-family:"Times New Roman";mso-ansi-language:
 
    ES-TRAD;mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>O un rango
 
    (ampliemos el mismo de antes):&nbsp;<i>150.100.100.0/24 (256 direcciones)</i><o:p></o:p></span></li>
 
</ul>
 
 
 
<p class=MsoNormal style='margin-bottom:7.5pt'><b><span style='font-family:
 
"Playfair Display","serif";mso-bidi-font-family:"Times New Roman";color:#525252;
 
mso-ansi-language:ES-TRAD;mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>5.3.
 
MŽtodo</span></b><span style='font-family:"Playfair Display","serif";
 
mso-bidi-font-family:"Times New Roman";color:#525252;mso-ansi-language:ES-TRAD;
 
mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'><o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='margin-bottom:7.5pt'><span style='font-family:"Playfair Display","serif";
 
mso-bidi-font-family:"Times New Roman";color:#525252;mso-ansi-language:ES-TRAD;
 
mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>Aunque hay&nbsp;</span><span
 
lang=ES><a
 
href="http://www.postgresql.org/docs/8.2/static/auth-pg-hba-conf.html"
 
target="_blank"><span lang=ES-TRAD style='font-family:"Playfair Display","serif";
 
mso-bidi-font-family:"Times New Roman";color:#EFA48D;mso-ansi-language:ES-TRAD;
 
mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA;text-decoration:none;
 
text-underline:none'>multitud de mŽtodos para utilizar</span></a></span><span
 
style='font-family:"Playfair Display","serif";mso-bidi-font-family:"Times New Roman";
 
color:#525252;mso-ansi-language:ES-TRAD;mso-fareast-language:ES-TRAD;
 
mso-bidi-language:AR-SA'>&nbsp;(incluyendo conexiones&nbsp;</span><span
 
lang=ES><a href="http://es.wikipedia.org/wiki/LDAP" target="_blank"><span
 
lang=ES-TRAD style='font-family:"Playfair Display","serif";mso-bidi-font-family:
 
"Times New Roman";color:#EFA48D;mso-ansi-language:ES-TRAD;mso-fareast-language:
 
ES-TRAD;mso-bidi-language:AR-SA;text-decoration:none;text-underline:none'>LDAP</span></a></span><span
 
style='font-family:"Playfair Display","serif";mso-bidi-font-family:"Times New Roman";
 
color:#525252;mso-ansi-language:ES-TRAD;mso-fareast-language:ES-TRAD;
 
mso-bidi-language:AR-SA'>,&nbsp;</span><span lang=ES><a
 
href="http://es.wikipedia.org/wiki/Kerberos" target="_blank"><span
 
class=SpellE><span lang=ES-TRAD style='font-family:"Playfair Display","serif";
 
mso-bidi-font-family:"Times New Roman";color:#EFA48D;mso-ansi-language:ES-TRAD;
 
mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA;text-decoration:none;
 
text-underline:none'>Kerberos</span></span><span lang=ES-TRAD style='font-family:
 
"Playfair Display","serif";mso-bidi-font-family:"Times New Roman";color:#EFA48D;
 
mso-ansi-language:ES-TRAD;mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA;
 
text-decoration:none;text-underline:none'>&nbsp;</span></a></span><span
 
style='font-family:"Playfair Display","serif";mso-bidi-font-family:"Times New Roman";
 
color:#525252;mso-ansi-language:ES-TRAD;mso-fareast-language:ES-TRAD;
 
mso-bidi-language:AR-SA'>o&nbsp;</span><span lang=ES><a
 
href="http://es.wikipedia.org/wiki/Pluggable_Authentication_Modules"
 
target="_blank"><span lang=ES-TRAD style='font-family:"Playfair Display","serif";
 
mso-bidi-font-family:"Times New Roman";color:#EFA48D;mso-ansi-language:ES-TRAD;
 
mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA;text-decoration:none;
 
text-underline:none'>PAM</span></a></span><span style='font-family:"Playfair Display","serif";
 
mso-bidi-font-family:"Times New Roman";color:#525252;mso-ansi-language:ES-TRAD;
 
mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>), explico los tres m‡s
 
b‡sicos:<o:p></o:p></span></p>
 
 
 
<ul type=square>
 
<li class=MsoNormal style='color:#525252;mso-margin-top-alt:auto;mso-margin-bottom-alt:
 
    auto;mso-list:l6 level1 lfo6;tab-stops:list 36.0pt'><span class=SpellE><i><span
 
    style='font-family:"Playfair Display","serif";mso-fareast-font-family:
 
    "Times New Roman";mso-bidi-font-family:"Times New Roman";mso-ansi-language:
 
    ES-TRAD;mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>ident</span></i></span><span
 
    style='font-family:"Playfair Display","serif";mso-fareast-font-family:
 
    "Times New Roman";mso-bidi-font-family:"Times New Roman";mso-ansi-language:
 
    ES-TRAD;mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>: utiliza el
 
    usuario del sistema desde el que se est‡ intentado conectar.<o:p></o:p></span></li>
 
<li class=MsoNormal style='color:#525252;mso-margin-top-alt:auto;mso-margin-bottom-alt:
 
    auto;mso-list:l6 level1 lfo6;tab-stops:list 36.0pt'><i><span
 
    style='font-family:"Playfair Display","serif";mso-fareast-font-family:
 
    "Times New Roman";mso-bidi-font-family:"Times New Roman";mso-ansi-language:
 
    ES-TRAD;mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>trust</span></i><span
 
    style='font-family:"Playfair Display","serif";mso-fareast-font-family:
 
    "Times New Roman";mso-bidi-font-family:"Times New Roman";mso-ansi-language:
 
    ES-TRAD;mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>: deja todos
 
    los accesos sin necesidad de autenticarse (s—lo recomendable para
 
    conexiones desde el equipo local).<o:p></o:p></span></li>
 
<li class=MsoNormal style='color:#525252;mso-margin-top-alt:auto;mso-margin-bottom-alt:
 
    auto;mso-list:l6 level1 lfo6;tab-stops:list 36.0pt'><span class=SpellE><i><span
 
    style='font-family:"Playfair Display","serif";mso-fareast-font-family:
 
    "Times New Roman";mso-bidi-font-family:"Times New Roman";mso-ansi-language:
 
    ES-TRAD;mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>password</span></i></span><span
 
    style='font-family:"Playfair Display","serif";mso-fareast-font-family:
 
    "Times New Roman";mso-bidi-font-family:"Times New Roman";mso-ansi-language:
 
    ES-TRAD;mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>:
 
    identificaci—n con usuario/contrase–a, es la m‡s t’pica y es la
 
    recomendable para conexiones desde clientes como&nbsp;</span><span
 
    lang=ES style='color:windowtext'><a
 
    href="http://www.sqlmanager.net/products/postgresql/manager"
 
    target="_blank"><span lang=ES-TRAD style='font-family:"Playfair Display","serif";
 
    mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:"Times New Roman";
 
    color:#EFA48D;mso-ansi-language:ES-TRAD;mso-fareast-language:ES-TRAD;
 
    mso-bidi-language:AR-SA;text-decoration:none;text-underline:none'>EMS <span
 
    class=SpellE>PostgreSQL</span> Manager</span></a></span><span
 
    style='font-family:"Playfair Display","serif";mso-fareast-font-family:
 
    "Times New Roman";mso-bidi-font-family:"Times New Roman";mso-ansi-language:
 
    ES-TRAD;mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>.<o:p></o:p></span></li>
 
</ul>
 
 
 
<p class=MsoNormal style='margin-bottom:7.5pt'><span style='font-family:"Playfair Display","serif";
 
mso-bidi-font-family:"Times New Roman";color:#525252;mso-ansi-language:ES-TRAD;
 
mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>Una l’nea de ejemplo,
 
para darle acceso a todos los usuarios, a todas las base de datos, desde el
 
rango de IP explicado antes, usando autenticaci—n con usuario y contrase–a,
 
ser’a la siguiente:<o:p></o:p></span></p>
 
 
 
<table class=MsoNormalTable border=0 cellpadding=0 style='mso-cellspacing:1.5pt;
 
mso-yfti-tbllook:1184'>
 
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes'>
 
  <td style='padding:.75pt .75pt .75pt .75pt'>
 
  <p class=MsoNormal align=center style='text-align:center'><span
 
  style='font-size:9.0pt;font-family:inherit;mso-fareast-font-family:"Times New Roman";
 
  mso-bidi-font-family:"Times New Roman";mso-ansi-language:ES-TRAD;mso-fareast-language:
 
  ES-TRAD;mso-bidi-language:AR-SA'>1<o:p></o:p></span></p>
 
  </td>
 
  <td width=503 style='width:502.5pt;padding:.75pt .75pt .75pt .75pt'>
 
  <p class=MsoNormal><span style='font-size:9.0pt;font-family:inherit;
 
  mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:"Times New Roman";
 
  color:black;mso-ansi-language:ES-TRAD;mso-fareast-language:ES-TRAD;
 
  mso-bidi-language:AR-SA'>host&nbsp;&nbsp;&nbsp;&nbsp;<span class=SpellE>all</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 
  <span class=SpellE>all</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 
  150.100.100.0/24&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span
 
  class=SpellE>password</span><o:p></o:p></span></p>
 
  </td>
 
</tr>
 
</table>
 
 
 
<p class=MsoNormal style='margin-bottom:7.5pt'><b><span style='font-family:
 
"Playfair Display","serif";mso-bidi-font-family:"Times New Roman";color:#525252;
 
mso-ansi-language:ES-TRAD;mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>5.4.
 
Habilitar conexiones al socket desde clientes que no sean el&nbsp;<i>host&nbsp;</i>local</span></b><span
 
style='font-family:"Playfair Display","serif";mso-bidi-font-family:"Times New Roman";
 
color:#525252;mso-ansi-language:ES-TRAD;mso-fareast-language:ES-TRAD;
 
mso-bidi-language:AR-SA'><o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='margin-bottom:7.5pt'><span style='font-family:"Playfair Display","serif";
 
mso-bidi-font-family:"Times New Roman";color:#525252;mso-ansi-language:ES-TRAD;
 
mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>Al igual que en <span
 
class=SpellE>MySQL</span> hay que configurar el&nbsp;</span><span lang=ES><a
 
href="http://dev.mysql.com/doc/refman/5.5/en/can-not-connect-to-server.html"
 
target="_blank"><span class=SpellE><span lang=ES-TRAD style='font-family:"Playfair Display","serif";
 
mso-bidi-font-family:"Times New Roman";color:#EFA48D;mso-ansi-language:ES-TRAD;
 
mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA;text-decoration:none;
 
text-underline:none'>bind-adress</span></span></a></span><span
 
style='font-family:"Playfair Display","serif";mso-bidi-font-family:"Times New Roman";
 
color:#525252;mso-ansi-language:ES-TRAD;mso-fareast-language:ES-TRAD;
 
mso-bidi-language:AR-SA'>&nbsp;en&nbsp;<span class=SpellE><i>my.conf</i></span>,
 
en <span class=SpellE>PostgreSQL</span> tenemos que hacer algo an‡logo.<o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='margin-bottom:7.5pt'><span style='font-family:"Playfair Display","serif";
 
mso-bidi-font-family:"Times New Roman";color:#525252;mso-ansi-language:ES-TRAD;
 
mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>Para versiones 8.x en
 
adelante el procedimiento es el siguiente. Buscamos el <span class=SpellE>fichero<i>postgresql.conf</i></span>&nbsp;en:<o:p></o:p></span></p>
 
 
 
<ul type=square>
 
<li class=MsoNormal style='color:#525252;mso-margin-top-alt:auto;mso-margin-bottom-alt:
 
    auto;mso-list:l3 level1 lfo7;tab-stops:list 36.0pt'><i><span
 
    style='font-family:"Playfair Display","serif";mso-fareast-font-family:
 
    "Times New Roman";mso-bidi-font-family:"Times New Roman";mso-ansi-language:
 
    ES-TRAD;mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>/<span
 
    class=SpellE>var</span>/<span class=SpellE>lib</span>/<span class=SpellE>pgsql</span>/data/<span
 
    class=SpellE>postgresql.conf</span></span></i><span style='font-family:
 
    "Playfair Display","serif";mso-fareast-font-family:"Times New Roman";
 
    mso-bidi-font-family:"Times New Roman";mso-ansi-language:ES-TRAD;
 
    mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'><o:p></o:p></span></li>
 
<li class=MsoNormal style='color:#525252;mso-margin-top-alt:auto;mso-margin-bottom-alt:
 
    auto;mso-list:l3 level1 lfo7;tab-stops:list 36.0pt'><i><span
 
    style='font-family:"Playfair Display","serif";mso-fareast-font-family:
 
    "Times New Roman";mso-bidi-font-family:"Times New Roman";mso-ansi-language:
 
    ES-TRAD;mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>/<span
 
    class=SpellE>etc</span>/<span class=SpellE>postgresql</span>/8.2/<span
 
    class=SpellE>main</span>/<span class=SpellE>postgresql.conf</span></span></i><span
 
    style='font-family:"Playfair Display","serif";mso-fareast-font-family:
 
    "Times New Roman";mso-bidi-font-family:"Times New Roman";mso-ansi-language:
 
    ES-TRAD;mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'><o:p></o:p></span></li>
 
</ul>
 
 
 
<p class=MsoNormal style='margin-bottom:7.5pt'><span style='font-family:"Playfair Display","serif";
 
mso-bidi-font-family:"Times New Roman";color:#525252;mso-ansi-language:ES-TRAD;
 
mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>Y buscar dentro del mismo
 
la siguiente l’nea:<o:p></o:p></span></p>
 
 
 
<table class=MsoNormalTable border=0 cellpadding=0 style='mso-cellspacing:1.5pt;
 
mso-yfti-tbllook:1184'>
 
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes'>
 
  <td style='padding:.75pt .75pt .75pt .75pt'>
 
  <p class=MsoNormal align=center style='text-align:center'><span
 
  style='font-size:9.0pt;font-family:inherit;mso-fareast-font-family:"Times New Roman";
 
  mso-bidi-font-family:"Times New Roman";mso-ansi-language:ES-TRAD;mso-fareast-language:
 
  ES-TRAD;mso-bidi-language:AR-SA'>1<o:p></o:p></span></p>
 
  </td>
 
  <td width=503 style='width:502.5pt;padding:.75pt .75pt .75pt .75pt'>
 
  <p class=MsoNormal><span class=SpellE><span style='font-size:9.0pt;
 
  font-family:inherit;mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:
 
  "Times New Roman";color:black;mso-ansi-language:ES-TRAD;mso-fareast-language:
 
  ES-TRAD;mso-bidi-language:AR-SA'>listen_addresses</span></span><span
 
  style='font-size:9.0pt;font-family:inherit;mso-fareast-font-family:"Times New Roman";
 
  mso-bidi-font-family:"Times New Roman";color:black;mso-ansi-language:ES-TRAD;
 
  mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>='<span class=SpellE>localhost</span>'<o:p></o:p></span></p>
 
  </td>
 
</tr>
 
</table>
 
 
 
<p class=MsoNormal style='margin-bottom:7.5pt'><span style='font-family:"Playfair Display","serif";
 
mso-bidi-font-family:"Times New Roman";color:#525252;mso-ansi-language:ES-TRAD;
 
mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>Para sustituirla, por el
 
comod’n (para todas las IP, es una opci—n segura, tened en cuenta que tenemos
 
tambiŽn un filtro en el fichero&nbsp;<span class=SpellE><i>pg_hba.conf</i></span>.<o:p></o:p></span></p>
 
 
 
<table class=MsoNormalTable border=0 cellpadding=0 style='mso-cellspacing:1.5pt;
 
mso-yfti-tbllook:1184'>
 
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes'>
 
  <td style='padding:.75pt .75pt .75pt .75pt'>
 
  <p class=MsoNormal align=center style='text-align:center'><span
 
  style='font-size:9.0pt;font-family:inherit;mso-fareast-font-family:"Times New Roman";
 
  mso-bidi-font-family:"Times New Roman";mso-ansi-language:ES-TRAD;mso-fareast-language:
 
  ES-TRAD;mso-bidi-language:AR-SA'>1<o:p></o:p></span></p>
 
  </td>
 
  <td width=503 style='width:502.5pt;padding:.75pt .75pt .75pt .75pt'>
 
  <p class=MsoNormal><span class=SpellE><span style='font-size:9.0pt;
 
  font-family:inherit;mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:
 
  "Times New Roman";color:black;mso-ansi-language:ES-TRAD;mso-fareast-language:
 
  ES-TRAD;mso-bidi-language:AR-SA'>listen_addresses</span></span><span
 
  style='font-size:9.0pt;font-family:inherit;mso-fareast-font-family:"Times New Roman";
 
  mso-bidi-font-family:"Times New Roman";color:black;mso-ansi-language:ES-TRAD;
 
  mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>='*'<o:p></o:p></span></p>
 
  </td>
 
</tr>
 
</table>
 
 
 
<p class=MsoNormal style='margin-bottom:7.5pt'><span style='font-family:"Playfair Display","serif";
 
mso-bidi-font-family:"Times New Roman";color:#525252;mso-ansi-language:ES-TRAD;
 
mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>O definir algunas
 
direcciones IP en concreto:<o:p></o:p></span></p>
 
 
 
<table class=MsoNormalTable border=0 cellpadding=0 style='mso-cellspacing:1.5pt;
 
mso-yfti-tbllook:1184'>
 
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes'>
 
  <td style='padding:.75pt .75pt .75pt .75pt'>
 
  <p class=MsoNormal align=center style='text-align:center'><span
 
  style='font-size:9.0pt;font-family:inherit;mso-fareast-font-family:"Times New Roman";
 
  mso-bidi-font-family:"Times New Roman";mso-ansi-language:ES-TRAD;mso-fareast-language:
 
  ES-TRAD;mso-bidi-language:AR-SA'>1<o:p></o:p></span></p>
 
  </td>
 
  <td width=503 style='width:502.5pt;padding:.75pt .75pt .75pt .75pt'>
 
  <p class=MsoNormal><span class=SpellE><span style='font-size:9.0pt;
 
  font-family:inherit;mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:
 
  "Times New Roman";color:black;mso-ansi-language:ES-TRAD;mso-fareast-language:
 
  ES-TRAD;mso-bidi-language:AR-SA'>listen_addresses</span></span><span
 
  style='font-size:9.0pt;font-family:inherit;mso-fareast-font-family:"Times New Roman";
 
  mso-bidi-font-family:"Times New Roman";color:black;mso-ansi-language:ES-TRAD;
 
  mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>='150.100.100.100
 
  150.100.100.101'<o:p></o:p></span></p>
 
  </td>
 
</tr>
 
</table>
 
 
 
<p class=MsoNormal style='margin-bottom:7.5pt'><b><span style='font-family:
 
"Playfair Display","serif";mso-bidi-font-family:"Times New Roman";color:#525252;
 
mso-ansi-language:ES-TRAD;mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>5.5.
 
Reiniciar servicio</span></b><span style='font-family:"Playfair Display","serif";
 
mso-bidi-font-family:"Times New Roman";color:#525252;mso-ansi-language:ES-TRAD;
 
mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'><o:p></o:p></span></p>
 
 
 
<p class=MsoNormal style='margin-bottom:7.5pt'><span style='font-family:"Playfair Display","serif";
 
mso-bidi-font-family:"Times New Roman";color:#525252;mso-ansi-language:ES-TRAD;
 
mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'>Reiniciamos el servicio
 
para que el servidor cargue los nuevos valores (como&nbsp;<span class=SpellE><i>root</i></span>):<o:p></o:p></span></p>
 
 
 
<table class=MsoNormalTable border=0 cellpadding=0 style='mso-cellspacing:1.5pt;
 
mso-yfti-tbllook:1184'>
 
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes'>
 
  <td style='padding:.75pt .75pt .75pt .75pt'>
 
  <p class=MsoNormal align=center style='text-align:center'><span
 
  style='font-size:9.0pt;font-family:inherit;mso-fareast-font-family:"Times New Roman";
 
  mso-bidi-font-family:"Times New Roman";mso-ansi-language:ES-TRAD;mso-fareast-language:
 
  ES-TRAD;mso-bidi-language:AR-SA'>1<o:p></o:p></span></p>
 
  </td>
 
  <td width=503 style='width:502.5pt;padding:.75pt .75pt .75pt .75pt'>
 
  <p class=MsoNormal><span style='font-size:9.0pt;font-family:inherit;
 
  mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:"Times New Roman";
 
  color:black;mso-ansi-language:ES-TRAD;mso-fareast-language:ES-TRAD;
 
  mso-bidi-language:AR-SA'>$ <span class=SpellE>service</span> <span
 
  class=SpellE>postgresql</span> <span class=SpellE>restart</span><o:p></o:p></span></p>
 
  </td>
 
</tr>
 
</table>
 
 
 
<p class=MsoListParagraphCxSpFirst style='line-height:21.0pt;background:white'><span
 
lang=ES><a
 
href="http://yallalabs.com/wp-content/uploads/2017/07/How-to-Install-pgAdmin-4-in-Server-mode-on-Ubuntu-16-LTS_1.png"><span
 
lang=EN-US style='font-size:10.5pt;font-family:Times;mso-bidi-font-family:"Times New Roman";
 
color:#6EB48C;mso-ansi-language:EN-US;mso-fareast-language:ES-TRAD;mso-bidi-language:
 
AR-SA;text-decoration:none;text-underline:none'><br>
 
</span></a></span><span lang=EN-US style='font-size:10.5pt;font-family:Times;
 
mso-bidi-font-family:"Times New Roman";color:#313131;mso-ansi-language:EN-US;
 
mso-fareast-language:ES-TRAD;mso-bidi-language:AR-SA'><o:p></o:p></span></p>
 
 
 
<p class=MsoListParagraphCxSpLast><span lang=EN-US style='mso-ansi-language:
 
EN-US'><o:p>&nbsp;</o:p></span></p>
 
 
 
</div>
 
 
 
</body>
 
 
 
</html>
 

Revision as of 11:34, 8 April 2018

PGADMIN4 ON UBUNTU 16.04

=== 1. Install

2. Allow Remote Access

3. Run as a Service

4. Access PGAdmin 4

5. Enable Postgresql remote Access

===

1. Install dependencies, create a virtual environment, download, install & configure Using Python2.x sudo apt-get install virtualenv python-pip libpq-dev python-dev

cd virtualenv pgadmin4 cd pgadmin4 source bin/activate

pip install https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v2.1/pip/pgadmin4-2.1-py2.py3-none-any.whl Using Python3.x (Preferred to avoid encoding related issues) sudo apt-get install virtualenv python3-pip libpq-dev python3-dev

cd virtualenv -p python3 pgadmin4 cd pgadmin4 source bin/activate

pip3 install https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v2.1/pip/pgadmin4-2.1-py2.py3-none-any.whl Configure Override default paths and set it to single-user mode in the local configuration file: nano lib/python2.7/site-packages/pgadmin4/config_local.py For Python3.x: nano lib/python3.x/site-packages/pgadmin4/config_local.py Write: import os DATA_DIR = os.path.realpath(os.path.expanduser(u'~/.pgadmin/')) LOG_FILE = os.path.join(DATA_DIR, 'pgadmin4.log') SQLITE_PATH = os.path.join(DATA_DIR, 'pgadmin4.db') SESSION_DB_PATH = os.path.join(DATA_DIR, 'sessions') STORAGE_DIR = os.path.join(DATA_DIR, 'storage') SERVER_MODE = False Run python lib/python2.7/site-packages/pgadmin4/pgAdmin4.py For Python3.x: python3 lib/python3.x/site-packages/pgadmin4/pgAdmin4.py Access Access at http://localhost:5050 Exit Exit with Ctrl-C Run again cd ~/pgadmin4 source bin/activate python lib/python2.7/site-packages/pgadmin4/pgAdmin4.py For Python3.x

  1. !/bin/bash

cd ~/pgadmin4 source bin/activate python3 lib/python3.x/site-packages/pgadmin4/pgAdmin4.py Make a shortcut touch ~/pgadmin4/pgadmin4 chmod +x ~/pgadmin4/pgadmin4 nano ~/pgadmin4/pgadmin4 Write:

  1. !/bin/bash

cd ~/pgadmin4 source bin/activate python lib/python2.7/site-packages/pgadmin4/pgAdmin4.py For Python3.x

  1. !/bin/bash

cd ~/pgadmin4 source bin/activate python3 lib/python3.x/site-packages/pgadmin4/pgAdmin4.py Now you can just run it with a simpler command: ~/pgadmin4/pgadmin4 Python3 users Replace [x] in Python3.x with your respective version. Conflict with pgAdmin 3 configuration pgAdmin 4 will not start in the environment where pgAdmin 3 was previously installed and used because of incompatible configuration in the .pgadmin directory. The simplest solution is to either clear that directory or tweak config_local.py to point to a clean new .pgadmin4directory.

2. REMOTE ACCESS (For CLOUD Install) PGAdmin4 Folder: ~/pgadmin4/lib/python3.X/site-packages/pgadmin4 (Replace 3.X with your Python Version) You need to add below config options, DEFAULT_SERVER = '0.0.0.0' in config_local.py (in "pgAdmin4" folder). If also want to change default port then also add DEFAULT_SERVER_PORT = 5050


3. RUN as a Service Python file: ~/pgadmin4/lib/python3.x/site-packages/pgadmin4/pgAdmin4.py PGAdmin4 Folder: ~/pgadmin4/lib/python3.X/site-packages/pgadmin4 (Replace 3.X with your Python Version) Before we start let’s exit the virtual enviroment using the follwoing command:

  1. deactivate

– To make PgAdmin 4 we need to make some extra modification, Open the pgAdmin4.py file and insert the following line in the begin of the file:

  1. vi ~/pgadmin4/lib/python3.x/site-packages/pgadmin4/pgAdmin4.py
  2. !/usr/bin/env python3

[...] – Make it executable by doing:

  1. chmod +x ~/pgadmin4/lib/python3.x/site-packages/pgadmin4/pgAdmin4.py

– Now create a /etc/systemd/system/pgadmin4.service service file containing:

  1. vi /etc/systemd/system/pgadmin4.service

[Unit] Description=Pgadmin4 Service After=network.target

[Service] User=root Group=root

  1. Point to the virtual environment directory

WorkingDirectory=/root/pgadmin4

  1. Point to the bin folder of your virtual environment
  2. Environment="PATH=/home/qgis/Downloads/pgadmin4/bin"

Environment="PATH=/root/pgadmin4/bin"

  1. ExecStart=/home/qgis/Downloads/pgadmin4/bin/python /home/web/Downloads/pgadmin4/lib/python3.6/site-packages/pgadmin4/pgAdmin4.py

ExecStart="/root/pgadmin4/lib/python3.5/site-packages/pgadmin4/pgAdmin4.py" PrivateTmp=true

[Install] WantedBy=multi-user.target – Enable and start PgAdmin Service at system boot:

  1. sudo systemctl daemon-reload
  2. sudo systemctl enable pgadmin4
  3. sudo systemctl start pgadmin4
  4. sudo systemctl status pgadmin4

4. Access PGAdmin 4 – Open http://Server_ip:5050 and logon to the PgAdmin using your credentials.


5. Enable Postgresql Remote Access.

5.1. Permitir conexiones de clientes desde un determinado rango Llegamos a uno de los puntos importantes de la cuestión, el fichero pg_hba.conf. Su situación exacta dependerá de vuestra instalación, pero lo encontraréis en una de estas dos rutas:  /var/lib/pgsql/data/pg_hba.conf (en mi instalación lo tengo ahí, utilizo Scientific Linux, una distribución derivada de Red Hat)  /etc/postgresql/main/pg_hba.conf Dentro de este fichero, al final del mismo, veremos algo así: 1 2 3 4 5 6 7 8 # TYPE DATABASE USER CIDR-ADDRESS METHOD

  1. "local" is for Unix domain socket connections only

local all all ident

  1. IPv4 local connections:

host all all 127.0.0.1/32 ident

  1. IPv6 local connections:

host all all ::1/128 password ¿Qué significa esto? Veamos columna a columna:  Tipo: básicamente conexión local o conexión remota (host).  Base de datos: base de datos a las que afecta la regla. Si queremos todas, usamos el comodín all.  Usuario: usuarios a los que afecta la regla, si queremos que afecte a todos, usamos también all. Nos paramos ahora en los dos apartados que más atención requieren. 5.2. Dirección En esta columna definimos, las direcciones IP (podemos también usar IPv6), desde las que podremos conectarnos a PostgreSQL. Usaremos la fórmula dirección/máscara:  Una sola dirección: 150.100.100.100/32  O un rango (ampliemos el mismo de antes): 150.100.100.0/24 (256 direcciones) 5.3. Método Aunque hay multitud de métodos para utilizar (incluyendo conexiones LDAP, Kerberos o PAM), explico los tres más básicos:  ident: utiliza el usuario del sistema desde el que se está intentado conectar.  trust: deja todos los accesos sin necesidad de autenticarse (sólo recomendable para conexiones desde el equipo local).  password: identificación con usuario/contraseña, es la más típica y es la recomendable para conexiones desde clientes como EMS PostgreSQL Manager. Una línea de ejemplo, para darle acceso a todos los usuarios, a todas las base de datos, desde el rango de IP explicado antes, usando autenticación con usuario y contraseña, sería la siguiente: 1 host all all 150.100.100.0/24 password 5.4. Habilitar conexiones al socket desde clientes que no sean el host local Al igual que en MySQL hay que configurar el bind-adress en my.conf, en PostgreSQL tenemos que hacer algo análogo. Para versiones 8.x en adelante el procedimiento es el siguiente. Buscamos el ficheropostgresql.conf en:  /var/lib/pgsql/data/postgresql.conf  /etc/postgresql/8.2/main/postgresql.conf Y buscar dentro del mismo la siguiente línea: 1 listen_addresses='localhost' Para sustituirla, por el comodín (para todas las IP, es una opción segura, tened en cuenta que tenemos también un filtro en el fichero pg_hba.conf. 1 listen_addresses='*' O definir algunas direcciones IP en concreto: 1 listen_addresses='150.100.100.100 150.100.100.101' 5.5. Reiniciar servicio Reiniciamos el servicio para que el servidor cargue los nuevos valores (como root): 1 $ service postgresql restart

Cookies help us deliver our services. By using our services, you agree to our use of cookies.