Difference between revisions of "Help:PGAdmin4 with python"

From iDempiere en
m
Line 1: Line 1:
−
'''<big>PGADMIN4 ON UBUNTU 16.04</big>'''
+
<html xmlns:o="urn:schemas-microsoft-com:office:office"
 +
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">
  
−
'''1. Install
+
<head>
 +
<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>
  
−
'''2. Allow Remote Access'''
+
<body bgcolor=white lang=ES-TRAD link=blue vlink="#954F72" style='tab-interval:
 +
35.45pt'>
  
−
'''3. Run as a Service'''
+
<div class=WordSection1>
  
−
'''4. Access PGAdmin 4'''
+
<h1><span lang=EN-US style='font-size:15.0pt;mso-bidi-font-size:24.0pt;
 +
font-family:Arial;color:#111111;mso-ansi-language:EN-US'>PGADMIN4 ON UBUNTU
 +
16.04<o:p></o:p></span></h1>
  
−
'''5. Enable Postgresql remote Access''''''
+
<h1 style='margin-left:36.0pt;text-indent:-18.0pt;mso-list:l2 level1 lfo1'><![if !supportLists]><span
 +
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:
 +
l2 level1 lfo1'><![if !supportLists]><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-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>
  
−
'''<big>1. Install</big>'''
+
<p class=MsoBodyText style='margin-left:36.0pt;text-indent:-18.0pt;mso-list:
 +
l2 level1 lfo1'><![if !supportLists]><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-fareast-font-family:Arial;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: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>
  
−
Install dependencies, create a virtual environment, download, install & configure
+
<p style='margin-top:0cm;margin-right:0cm;margin-bottom:12.0pt;margin-left:
−
Using Python2.x
+
36.0pt;text-indent:-18.0pt;mso-list:l2 level1 lfo1;background:white;vertical-align:
 +
baseline'><![if !supportLists]><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;
 +
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>
  
−
$ sudo apt-get install virtualenv python-pip libpq-dev python-dev
+
<p style='margin-top:0cm;margin-right:0cm;margin-bottom:12.0pt;margin-left:
 +
36.0pt;text-indent:-18.0pt;mso-list:l2 level1 lfo1;background:white;vertical-align:
 +
baseline'><![if !supportLists]><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;
 +
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>
  
−
$ cd
+
<p class=MsoBodyText style='margin-left:36.0pt'><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'><o:p>&nbsp;</o:p></span></b></p>
  
−
$ virtualenv pgadmin4
+
<h1 style='margin-left:0cm;text-indent:0cm;mso-list:l5 level1 lfo2'><![if !supportLists]><span
 +
lang=EN-US style='font-size:13.0pt;mso-bidi-font-size:14.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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 +
</span></span></span><![endif]><span lang=EN-US style='font-size:14.0pt;
 +
font-family:Arial;color:#111111;mso-ansi-language:EN-US'>Install dependencies,
 +
create a virtual environment, download, install &amp; configure<o:p></o:p></span></h1>
  
−
$ cd pgadmin4
+
<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>
  
−
$ source bin/activate
+
<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'>sudo</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'> apt-get install <span
 +
class=SpellE>virtualenv</span> python-pip <span class=SpellE>libpq-dev</span>
 +
python-<span class=SpellE>dev</span></span></span><span lang=EN-US
 +
style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
  
−
$ pip install https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v2.1/pip/pgadmin4-2.1-py2.py3-none-any.whl
+
<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>
  
−
Using Python3.x (Preferred to avoid encoding related issues)
+
<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</span></span><span
 +
lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
  
−
$ sudo apt-get install virtualenv python3-pip libpq-dev python3-dev
+
<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'>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>
  
−
$ cd
+
<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>
  
−
$ virtualenv -p python3 pgadmin4
+
<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>
  
−
$ cd pgadmin4
+
<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>
  
−
$ source bin/activate
+
<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'>pip 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>
  
−
$ pip3 install https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v2.1/pip/pgadmin4-2.1-py2.py3-none-any.whl
+
<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 Python3.x (Preferred to avoid encoding related issues)<o:p></o:p></span></h3>
  
−
Configure
+
<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'>sudo</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'> apt-get install <span
 +
class=SpellE>virtualenv</span> python3-pip <span class=SpellE>libpq-dev</span>
 +
python3-dev</span></span><span lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
  
−
Override default paths and set it to single-user mode in the local configuration file:
+
<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>
  
−
$ nano lib/python2.7/site-packages/pgadmin4/config_local.py
+
<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</span></span><span
 +
lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
  
−
For Python3.x:
+
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
−
$ nano lib/python3.x/site-packages/pgadmin4/config_local.py
+
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'>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'> -p python3
 +
pgadmin4</span></span><span lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
  
−
Write:
+
<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>
  
−
import os
+
<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>
  
−
DATA_DIR = os.path.realpath(os.path.expanduser(u'~/.pgadmin/'))
+
<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>
  
−
LOG_FILE = os.path.join(DATA_DIR, 'pgadmin4.log')
+
<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>
  
−
SQLITE_PATH = os.path.join(DATA_DIR, 'pgadmin4.db')
+
<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>
  
−
SESSION_DB_PATH = os.path.join(DATA_DIR, 'sessions')
+
<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>
  
−
STORAGE_DIR = os.path.join(DATA_DIR, 'storage')
+
<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>
  
−
SERVER_MODE = False
+
<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>
  
−
Run
+
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
−
python lib/python2.7/site-packages/pgadmin4/pgAdmin4.py
+
class=SpellE><span class=SourceText><span lang=EN-US style='font-family:inherit;
−
For Python3.x:
+
color:#303336;background:white;mso-highlight:white;mso-ansi-language:EN-US'>nano</span></span></span><span
−
python3 lib/python3.x/site-packages/pgadmin4/pgAdmin4.py
+
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
−
Access
+
background:white;mso-highlight:white;mso-ansi-language:EN-US'> lib/python3.x/site-packages/pgadmin4/config_local.py</span></span><span
−
Access at http://localhost:5050
+
lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
−
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.
 
  
−
2. REMOTE ACCESS (For CLOUD Install)
+
<p class=MsoBodyText style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
−
PGAdmin4 Folder: ~/pgadmin4/lib/python3.X/site-packages/pgadmin4
+
130%'><span lang=EN-US style='font-size:11.5pt;mso-bidi-font-size:12.0pt;
−
(Replace 3.X with your Python Version)
+
line-height:130%;font-family:inherit;color:#111111;mso-ansi-language:EN-US'>Write:<o:p></o:p></span></p>
−
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
 
  
 +
<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>
  
−
3. RUN as a Service
+
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
−
Python file: ~/pgadmin4/lib/python3.x/site-packages/pgadmin4/pgAdmin4.py
+
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
−
PGAdmin4 Folder: ~/pgadmin4/lib/python3.X/site-packages/pgadmin4
+
background:white;mso-highlight:white;mso-ansi-language:EN-US'>DATA_DIR =</span></span><span
−
(Replace 3.X with your Python Version)
+
class=SourceText><span lang=EN-US style='font-family:"Consolas;Menlo;Monaco;Lucida Co","serif";
−
Before we start let’s exit the virtual enviroment using the follwoing command:
+
color:#303336;background:white;mso-highlight:white;mso-ansi-language:EN-US'> </span></span><span
−
# deactivate
+
class=SpellE><span class=GramE><span class=SourceText><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='font-family:inherit;color:#303336;background:white;mso-highlight:white;
−
# vi ~/pgadmin4/lib/python3.x/site-packages/pgadmin4/pgAdmin4.py
+
mso-ansi-language:EN-US'>os.path</span></span></span><span class=SourceText><span
−
#!/usr/bin/env python3
+
lang=EN-US style='font-family:inherit;color:#303336;background:white;
−
[...]
+
mso-highlight:white;mso-ansi-language:EN-US'>.realpath</span></span></span><span
−
– Make it executable by doing:
+
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
−
# chmod +x  ~/pgadmin4/lib/python3.x/site-packages/pgadmin4/pgAdmin4.py
+
background:white;mso-highlight:white;mso-ansi-language:EN-US'>(<span
−
– Now create a /etc/systemd/system/pgadmin4.service service file containing:
+
class=SpellE>os.path.expanduser</span>(u</span></span><span class=SourceText><span
−
# vi /etc/systemd/system/pgadmin4.service
+
lang=EN-US style='font-family:inherit;color:#7D2727;background:white;
−
[Unit]
+
mso-highlight:white;mso-ansi-language:EN-US'>'~/.<span class=SpellE>pgadmin</span>/'</span></span><span
−
Description=Pgadmin4 Service
+
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
−
After=network.target
+
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>
  
−
[Service]
+
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
−
User=root
+
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
−
Group=root
+
background:white;mso-highlight:white;mso-ansi-language:EN-US'>LOG_FILE =</span></span><span
−
# Point to the virtual environment directory
+
class=SourceText><span lang=EN-US style='font-family:"Consolas;Menlo;Monaco;Lucida Co","serif";
−
WorkingDirectory=/root/pgadmin4
+
color:#303336;background:white;mso-highlight:white;mso-ansi-language:EN-US'> </span></span><span
−
# Point to the bin folder of your virtual environment
+
class=SpellE><span class=GramE><span class=SourceText><span lang=EN-US
−
# Environment="PATH=/home/qgis/Downloads/pgadmin4/bin"
+
style='font-family:inherit;color:#303336;background:white;mso-highlight:white;
−
Environment="PATH=/root/pgadmin4/bin"
+
mso-ansi-language:EN-US'>os.path</span></span></span><span class=SourceText><span
−
# ExecStart=/home/qgis/Downloads/pgadmin4/bin/python /home/web/Downloads/pgadmin4/lib/python3.6/site-packages/pgadmin4/pgAdmin4.py
+
lang=EN-US style='font-family:inherit;color:#303336;background:white;
−
ExecStart="/root/pgadmin4/lib/python3.5/site-packages/pgadmin4/pgAdmin4.py"
+
mso-highlight:white;mso-ansi-language:EN-US'>.join</span></span></span><span
−
PrivateTmp=true
+
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>
  
−
[Install]
+
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
−
WantedBy=multi-user.target
+
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
−
– Enable and start PgAdmin Service at system boot:
+
background:white;mso-highlight:white;mso-ansi-language:EN-US'>SQLITE_PATH =</span></span><span
−
# sudo systemctl daemon-reload
+
class=SourceText><span lang=EN-US style='font-family:"Consolas;Menlo;Monaco;Lucida Co","serif";
−
# sudo systemctl enable pgadmin4
+
color:#303336;background:white;mso-highlight:white;mso-ansi-language:EN-US'> </span></span><span
−
# sudo systemctl start pgadmin4
+
class=SpellE><span class=GramE><span class=SourceText><span lang=EN-US
−
# sudo systemctl status  pgadmin4
+
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>
  
−
4. Access PGAdmin 4
+
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
−
– Open http://Server_ip:5050 and logon to the PgAdmin using your credentials.
+
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>
  
−
5. Enable Postgresql Remote Access.
+
<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>
  
−
5.1. Permitir conexiones de clientes desde un determinado rango
+
<h2 style='margin:0cm;margin-bottom:.0001pt;line-height:130%'><span lang=EN-US
−
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:
+
style='font-size:14.5pt;mso-bidi-font-size:18.0pt;line-height:130%;font-family:
−
/var/lib/pgsql/data/pg_hba.conf (en mi instalación lo tengo ahí, utilizo Scientific Linux, una distribución derivada de Red Hat)
+
inherit;color:#111111;mso-ansi-language:EN-US;font-weight:normal;mso-bidi-font-weight:
−
 /etc/postgresql/main/pg_hba.conf
+
bold'>Run<o:p></o:p></span></h2>
−
Dentro de este fichero, al final del mismo, veremos algo así:
+
 
−
1
+
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
−
2
+
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
−
3
+
background:white;mso-highlight:white;mso-ansi-language:EN-US'>python
−
4
+
lib/python2.</span></span><span class=SourceText><span lang=EN-US
−
5
+
style='font-family:inherit;color:#7D2727;background:white;mso-highlight:white;
−
6
+
mso-ansi-language:EN-US'>7</span></span><span class=SourceText><span
−
7
+
lang=EN-US style='font-family:inherit;color:#303336;background:white;
−
8 # TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
+
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>
−
# "local" is for Unix domain socket connections only
+
 
−
local  all        all                              ident
+
<p class=MsoBodyText style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
−
# IPv4 local connections:
+
130%'><span lang=EN-US style='font-size:11.5pt;mso-bidi-font-size:12.0pt;
−
host    all        all        127.0.0.1/32          ident
+
line-height:130%;font-family:inherit;color:#111111;mso-ansi-language:EN-US'>For
−
# IPv6 local connections:
+
Python3.x:<o:p></o:p></span></p>
−
host    all        all        ::1/128              password
+
 
−
¿Qué significa esto? Veamos columna a columna:
+
<p class=PreformattedText style='line-height:130%;background:#EFF0F1'><span
−
 Tipo: básicamente conexión local o conexión remota (host).
+
class=SourceText><span lang=EN-US style='font-family:inherit;color:#303336;
−
 Base de datos: base de datos a las que afecta la regla. Si queremos todas, usamos el comodín all.
+
background:white;mso-highlight:white;mso-ansi-language:EN-US'>python3
−
 Usuario: usuarios a los que afecta la regla, si queremos que afecte a todos, usamos también all.
+
lib/python3.x/site-packages/pgadmin4/pgAdmin4.py</span></span><span lang=EN-US
−
Nos paramos ahora en los dos apartados que más atención requieren.
+
style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
−
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:
+
<h2 style='margin:0cm;margin-bottom:.0001pt;line-height:130%'><span lang=EN-US
−
 Una sola dirección: 150.100.100.100/32
+
style='font-size:14.5pt;mso-bidi-font-size:18.0pt;line-height:130%;font-family:
−
 O un rango (ampliemos el mismo de antes): 150.100.100.0/24 (256 direcciones)
+
inherit;color:#111111;mso-ansi-language:EN-US;font-weight:normal;mso-bidi-font-weight:
−
5.3. Método
+
bold'>Access<o:p></o:p></span></h2>
−
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.
+
<p class=MsoBodyText style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
−
 trust: deja todos los accesos sin necesidad de autenticarse (sólo recomendable para conexiones desde el equipo local).
+
130%'><span lang=EN-US style='font-size:11.5pt;mso-bidi-font-size:12.0pt;
−
 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.
+
line-height:130%;font-family:inherit;color:#111111;mso-ansi-language:EN-US'>Access
−
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:
+
at&nbsp;</span><span lang=ES><a href="http://localhost:5050/"><span
−
1 host    all        all        150.100.100.0/24          password
+
class=InternetLink><span lang=EN-US style='font-size:11.5pt;mso-bidi-font-size:
−
5.4. Habilitar conexiones al socket desde clientes que no sean el host local
+
12.0pt;line-height:130%;font-family:inherit;color:#962D0C;mso-ansi-language:
−
Al igual que en MySQL hay que configurar el bind-adress en my.conf, en PostgreSQL tenemos que hacer algo análogo.
+
EN-US;text-decoration:none;text-underline:none'>http://localhost:5050</span></span></a></span><span
−
Para versiones 8.x en adelante el procedimiento es el siguiente. Buscamos el ficheropostgresql.conf en:
+
lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
−
/var/lib/pgsql/data/postgresql.conf
+
 
−
 /etc/postgresql/8.2/main/postgresql.conf
+
<h2 style='margin:0cm;margin-bottom:.0001pt;line-height:130%'><span lang=EN-US
−
Y buscar dentro del mismo la siguiente línea:
+
style='font-size:14.5pt;mso-bidi-font-size:18.0pt;line-height:130%;font-family:
−
1 listen_addresses='localhost'
+
inherit;color:#111111;mso-ansi-language:EN-US;font-weight:normal;mso-bidi-font-weight:
−
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.
+
bold'>Exit<o:p></o:p></span></h2>
−
1 listen_addresses='*'
+
 
−
O definir algunas direcciones IP en concreto:
+
<p class=MsoBodyText style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
−
1 listen_addresses='150.100.100.100 150.100.100.101'
+
130%'><span lang=EN-US style='font-size:11.5pt;mso-bidi-font-size:12.0pt;
−
5.5. Reiniciar servicio
+
line-height:130%;font-family:inherit;color:#111111;mso-ansi-language:EN-US'>Exit
−
Reiniciamos el servicio para que el servidor cargue los nuevos valores (como root):
+
with Ctrl-C<o:p></o:p></span></p>
−
1 $ service postgresql restart
+
 
 +
<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:30, 8 April 2018

<html xmlns:o="urn:schemas-microsoft-com:office:office" 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> <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"> <link rel=themeData href="UBUNTU%2016.04%20-%20PGAdmin4%20with%20python%20.fld/themedata.thmx"> <style> </style> </head>

<body bgcolor=white lang=ES-TRAD link=blue vlink="#954F72" style='tab-interval: 35.45pt'>

PGADMIN4 ON UBUNTU 16.04<o:p></o:p>

<![if !supportLists]>1.        <![endif]>Install<o:p></o:p>

<![if !supportLists]>2.        <![endif]>Allow Remote Access<o:p></o:p>

<![if !supportLists]>3.        <![endif]>Run as a Service<o:p></o:p>

<![if !supportLists]>4.        <![endif]>Access PGAdmin 4<o:p></o:p>

<![if !supportLists]>5.        <![endif]>Enable Postgresql remote Access<o:p></o:p>

<o:p> </o:p>

<![if !supportLists]>1.                         <![endif]>Install dependencies, create a virtual environment, download, install & configure<o:p></o:p>

Using Python2.x<o:p></o:p>

sudo apt-get install virtualenv python-pip libpq-dev python-dev<o:p></o:p>

<o:p> </o:p>

cd<o:p></o:p>

virtualenv pgadmin4<o:p></o:p>

cd pgadmin4<o:p></o:p>

source bin/activate<o:p></o:p>

<o:p> </o:p>

pip install https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v2.1/pip/pgadmin4-2.1-py2.py3-none-any.whl<o:p></o:p>

Using Python3.x (Preferred to avoid encoding related issues)<o:p></o:p>

sudo apt-get install virtualenv python3-pip libpq-dev python3-dev<o:p></o:p>

<o:p> </o:p>

cd<o:p></o:p>

virtualenv -p python3 pgadmin4<o:p></o:p>

cd pgadmin4<o:p></o:p>

source bin/activate<o:p></o:p>

<o:p> </o:p>

pip3 install https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v2.1/pip/pgadmin4-2.1-py2.py3-none-any.whl<o:p></o:p>

Configure<o:p></o:p>

Override default paths and set it to single-user mode in the <a href="https://www.pgadmin.org/docs/pgadmin4/dev/server_deployment.html">local configuration file</a>:<o:p></o:p>

nano lib/python2.7/site-packages/pgadmin4/config_local.py<o:p></o:p>

For Python3.x:<o:p></o:p>

nano lib/python3.x/site-packages/pgadmin4/config_local.py<o:p></o:p>

Write:<o:p></o:p>

import os<o:p></o:p>

DATA_DIR = os.path.realpath(os.path.expanduser(u'~/.pgadmin/'))<o:p></o:p>

LOG_FILE = os.path.join(DATA_DIR, 'pgadmin4.log')<o:p></o:p>

SQLITE_PATH = os.path.join(DATA_DIR, 'pgadmin4.db')<o:p></o:p>

SESSION_DB_PATH = os.path.join(DATA_DIR, 'sessions')<o:p></o:p>

STORAGE_DIR = os.path.join(DATA_DIR, 'storage')<o:p></o:p>

SERVER_MODE = False<o:p></o:p>

Run<o:p></o:p>

python lib/python2.7/site-packages/pgadmin4/pgAdmin4.py<o:p></o:p>

For Python3.x:<o:p></o:p>

python3 lib/python3.x/site-packages/pgadmin4/pgAdmin4.py<o:p></o:p>

Access<o:p></o:p>

Access at <a href="http://localhost:5050/">http://localhost:5050</a><o:p></o:p>

Exit<o:p></o:p>

Exit with Ctrl-C<o:p></o:p>

Run again<o:p></o:p>

cd ~/pgadmin4<o:p></o:p>

source bin/activate<o:p></o:p>

python lib/python2.7/site-packages/pgadmin4/pgAdmin4.py<o:p></o:p>

For Python3.x<o:p></o:p>

#!/bin/bash<o:p></o:p>

cd ~/pgadmin4<o:p></o:p>

source bin/activate<o:p></o:p>

python3 lib/python3.x/site-packages/pgadmin4/pgAdmin4.py<o:p></o:p>

Make a shortcut<o:p></o:p>

touch ~/pgadmin4/pgadmin4<o:p></o:p>

chmod +x ~/pgadmin4/pgadmin4<o:p></o:p>

nano ~/pgadmin4/pgadmin4<o:p></o:p>

Write:<o:p></o:p>

#!/bin/bash<o:p></o:p>

cd ~/pgadmin4<o:p></o:p>

source bin/activate<o:p></o:p>

python lib/python2.7/site-packages/pgadmin4/pgAdmin4.py<o:p></o:p>

For Python3.x<o:p></o:p>

#!/bin/bash<o:p></o:p>

cd ~/pgadmin4<o:p></o:p>

source bin/activate<o:p></o:p>

python3 lib/python3.x/site-packages/pgadmin4/pgAdmin4.py<o:p></o:p>

Now you can just run it with a simpler command:<o:p></o:p>

~/pgadmin4/pgadmin4<o:p></o:p>

Python3 users<o:p></o:p>

Replace [x] in Python3.x with your respective version.<o:p></o:p>

Conflict with pgAdmin 3 configuration<o:p></o:p>

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.<o:p></o:p>

<o:p> </o:p>

<![if !supportLists]>2.        <![endif]>REMOTE ACCESS (For CLOUD Install)<o:p></o:p>

PGAdmin4 Folder: ~/pgadmin4/lib/python3.X/site-packages/pgadmin4<o:p></o:p>

(Replace 3.X with your Python Version)<o:p></o:p>

You need to add below config options,<o:p></o:p>

DEFAULT_SERVER = '0.0.0.0'<o:p></o:p>

in config_local.py (in "pgAdmin4" folder).<o:p></o:p>

If also want to change default port then also add<o:p></o:p>

DEFAULT_SERVER_PORT = 5050<o:p></o:p>

<o:p> </o:p>

<o:p> </o:p>

<![if !supportLists]>3.        <![endif]>RUN as a Service<o:p></o:p>

Python file:  ~/pgadmin4/lib/python3.x/site-packages/pgadmin4/pgAdmin4.py<o:p></o:p>

PGAdmin4 Folder: ~/pgadmin4/lib/python3.X/site-packages/pgadmin4<o:p></o:p>

(Replace 3.X with your Python Version)<o:p></o:p>

Before we start letÕs exit the virtual enviroment using the follwoing command:<o:p></o:p>

# deactivate<o:p></o:p>

Ð 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:<o:p></o:p>

# vi ~/pgadmin4/lib/python3.x/site-packages/pgadmin4/pgAdmin4.py<o:p></o:p>

#!/usr/bin/env python3<o:p></o:p>

[...]<o:p></o:p>

Ð Make it executable by doing:<o:p></o:p>

# chmod +x  ~/pgadmin4/lib/python3.x/site-packages/pgadmin4/pgAdmin4.py<o:p></o:p>

Ð Now create a /etc/systemd/system/pgadmin4.service service file containing:<o:p></o:p>

# vi /etc/systemd/system/pgadmin4.service<o:p></o:p>

[Unit]<o:p></o:p>

Description=Pgadmin4 Service<o:p></o:p>

After=network.target<o:p></o:p>

<o:p> </o:p>

[Service]<o:p></o:p>

User=root<o:p></o:p>

Group=root<o:p></o:p>

# Point to the virtual environment directory<o:p></o:p>

WorkingDirectory=/root/pgadmin4<o:p></o:p>

# Point to the bin folder of your virtual environment<o:p></o:p>

# Environment="PATH=/home/qgis/Downloads/pgadmin4/bin"<o:p></o:p>

Environment="PATH=/root/pgadmin4/bin"<o:p></o:p>

# ExecStart=/home/qgis/Downloads/pgadmin4/bin/python /home/web/Downloads/pgadmin4/lib/python3.6/site-packages/pgadmin4/pgAdmin4.py<o:p></o:p>

ExecStart="/root/pgadmin4/lib/python3.5/site-packages/pgadmin4/pgAdmin4.py"<o:p></o:p>

PrivateTmp=true<o:p></o:p>

<o:p> </o:p>

[Install]<o:p></o:p>

WantedBy=multi-user.target<o:p></o:p>

Ð Enable and start PgAdmin Service at system boot:<o:p></o:p>

# sudo systemctl daemon-reload<o:p></o:p>

# sudo systemctl enable pgadmin4<o:p></o:p>

# sudo systemctl start pgadmin4<o:p></o:p>

# sudo systemctl status  pgadmin4<o:p></o:p>

<o:p> </o:p>

<![if !supportLists]>4.        <![endif]>Access PGAdmin 4<o:p></o:p>

Ð Open http://Server_ip:5050 and logon to the PgAdmin using your credentials.<o:p></o:p>

<o:p> </o:p>

<o:p> </o:p>

<![if !supportLists]>5.        <![endif]>Enable Postgresql Remote Access.<o:p></o:p>

<o:p> </o:p>

5.1. Permitir conexiones de clientes desde un determinado rango<o:p></o: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:<o:p></o:p>

Dentro de este fichero, al final del mismo, veremos algo as’:<o:p></o:p>

1<o:p></o:p>

2<o:p></o:p>

3<o:p></o:p>

4<o:p></o:p>

5<o:p></o:p>

6<o:p></o:p>

7<o:p></o:p>

8<o:p></o:p>

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD<o:p></o:p>

 <o:p></o:p>

# "local" is for Unix domain socket connections only<o:p></o:p>

local   all         all                               ident<o:p></o:p>

# IPv4 local connections:<o:p></o:p>

host    all         all         127.0.0.1/32          ident<o:p></o:p>

# IPv6 local connections:<o:p></o:p>

host    all         all         ::1/128               password<o:p></o:p>

ÀQuŽ significa esto? Veamos columna a columna:<o:p></o:p>

  • Tipo: b‡sicamente conexi—n local o conexi—n remota (host).<o:p></o:p>
  • Base de datos: base de datos a las que afecta la regla. Si queremos todas, usamos el comod’n all.<o:p></o:p>
  • Usuario: usuarios a los que afecta la regla, si queremos que afecte a todos, usamos tambiŽn all.<o:p></o:p>

Nos paramos ahora en los dos apartados que m‡s atenci—n requieren.<o:p></o:p>

5.2. Direcci—n<o:p></o:p>

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:<o:p></o:p>

  • Una sola direcci—n: 150.100.100.100/32<o:p></o:p>
  • O un rango (ampliemos el mismo de antes): 150.100.100.0/24 (256 direcciones)<o:p></o:p>

5.3. MŽtodo<o:p></o:p>

Aunque hay <a href="http://www.postgresql.org/docs/8.2/static/auth-pg-hba-conf.html" target="_blank">multitud de mŽtodos para utilizar</a> (incluyendo conexiones <a href="http://es.wikipedia.org/wiki/LDAP" target="_blank">LDAP</a>, <a href="http://es.wikipedia.org/wiki/Kerberos" target="_blank">Kerberos </a>o <a href="http://es.wikipedia.org/wiki/Pluggable_Authentication_Modules" target="_blank">PAM</a>), explico los tres m‡s b‡sicos:<o:p></o:p>

  • ident: utiliza el usuario del sistema desde el que se est‡ intentado conectar.<o:p></o:p>
  • trust: deja todos los accesos sin necesidad de autenticarse (s—lo recomendable para conexiones desde el equipo local).<o:p></o:p>
  • password: identificaci—n con usuario/contrase–a, es la m‡s t’pica y es la recomendable para conexiones desde clientes como <a href="http://www.sqlmanager.net/products/postgresql/manager" target="_blank">EMS PostgreSQL Manager</a>.<o:p></o:p>

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>

1<o:p></o:p>

host    all         all         150.100.100.0/24          password<o:p></o:p>

5.4. Habilitar conexiones al socket desde clientes que no sean el host local<o:p></o:p>

Al igual que en MySQL hay que configurar el <a href="http://dev.mysql.com/doc/refman/5.5/en/can-not-connect-to-server.html" target="_blank">bind-adress</a> en my.conf, en PostgreSQL tenemos que hacer algo an‡logo.<o:p></o:p>

Para versiones 8.x en adelante el procedimiento es el siguiente. Buscamos el ficheropostgresql.conf en:<o:p></o:p>

  • /var/lib/pgsql/data/postgresql.conf<o:p></o:p>
  • /etc/postgresql/8.2/main/postgresql.conf<o:p></o:p>

Y buscar dentro del mismo la siguiente l’nea:<o:p></o:p>

1<o:p></o:p>

listen_addresses='localhost'<o:p></o: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.<o:p></o:p>

1<o:p></o:p>

listen_addresses='*'<o:p></o:p>

O definir algunas direcciones IP en concreto:<o:p></o:p>

1<o:p></o:p>

listen_addresses='150.100.100.100 150.100.100.101'<o:p></o:p>

5.5. Reiniciar servicio<o:p></o:p>

Reiniciamos el servicio para que el servidor cargue los nuevos valores (como root):<o:p></o:p>

1<o:p></o:p>

$ service postgresql restart<o:p></o:p>

<a href="http://yallalabs.com/wp-content/uploads/2017/07/How-to-Install-pgAdmin-4-in-Server-mode-on-Ubuntu-16-LTS_1.png">
</a><o:p></o:p>

<o:p> </o:p>

</body>

</html>

Retrieved from "https://wiki.idempiere.org/w-en/index.php?title=Help:PGAdmin4_with_python&oldid=14236"
Cookies help us deliver our services. By using our services, you agree to our use of cookies.
GNU-Lizenz für freie Dokumentation 1.3 oder höher
Powered by MediaWiki