{"id":311,"date":"2016-05-05T18:02:17","date_gmt":"2016-05-05T18:02:17","guid":{"rendered":"http:\/\/www.copahost.com\/blog\/?p=311"},"modified":"2020-05-31T14:21:14","modified_gmt":"2020-05-31T14:21:14","slug":"install-postgresql-ubuntu-14","status":"publish","type":"post","link":"https:\/\/www.copahost.com\/blog\/install-postgresql-ubuntu-14\/","title":{"rendered":"Install PostgreSQL in Ubuntu 14"},"content":{"rendered":"

Databases are an important part of any website or software. With relatively large amount of data, all applications use one or the other database method to store data. PostgreSQL, commonly known as Postgres is an open source, object – relational database management system (RDBMS). It was originally designed for unix platforms, however it has been modified to run on all platforms now. Install PostgreSQL in Ubuntu<\/a> takes less than 5 minutes.<\/p>\n

This article explains how PostgreSQL can be installed and configured in an\u00a0Ubuntu 14.04 dedicated server<\/a>, or even a vps server<\/a>. The post is intended to help newbies who are starting with postgresql.<\/p>\n

Install\u00a0PostgreSQL in Ubuntu 14<\/h3>\n

Like any other OS, Ubuntu has its own package manager called apt, which helps in installing and updating any software in their repository. Before starting with any installation, it is always a good practice to make sure that the packages available are up-to-date. Assuming I have the root login, issue the following command to get updated packages.<\/p>\n

root@teste3:~# apt-get -y update<\/pre>\n
Now that the packages are updated, the installation is just a step away.<\/p>\n
root@teste3:~# apt-get -y install postgresql postgresql-contrib<\/pre>\n
The process of install<\/a> PostgreSQL should complete without errors, and once the process of install PostgreSQL in ubuntu\u00a0is done, you are ready to start using PostgreSQL. The installation by default creates a system user called postgres, which has default PostgreSQL roles. In Postgres, database access permissions are managed<\/a> by roles. A role may include a single user or multiple users and it specifies the privileges for these users based on how the role is setup. We will come into creating roles later in this post, meanwhile let us see how to get to the postgresql prompt.<\/p>\n
Gaining Access via command line<\/strong><\/p>\n
As mentioned, postgres is a system user with default postgresql role. We need to switch to that system user first to be able to connect to the postgres terminal.<\/p>\n
root@teste3:~# sudo -i -u postgres\r\n\r\npostgres@teste3:~$<\/pre>\n
Now we are logged in as postgres user. Now from this terminal issue the psql command and we will straight be taken to the psql prompt where we can manage the databases.<\/p>\n
postgres@teste3:~$  psql\r\npsql (9.3.12)\r\nType \"help\" for help.\r\n\r\npostgres=#<\/pre>\n
To quit from the psql prompt, you use \\q as follows. It will log you out of the psql prompt and return to the postgres user shell.<\/p>\n
postgres=# \\q\r\npostgres@teste3:~$<\/pre>\n
Creating Roles<\/strong><\/p>\n
Roles, as mentioned above, is the postgresql concept which manages the database access permission. A new role can be created easily from the command line after you install<\/a> PostgreSQL in ubuntu\u00a0or from the psql prompt as follows. For the first method, you need to quit from the psql prompt and return to the postgres user shell. You can create a role as shown below with the command createuser. It will ask you a few questions, on answering which the new role will be created.<\/p>\n
postgres@teste3:~$ createuser --interactive\r\nEnter name of role to add: prad\r\nShall the new role be a superuser? (y\/n) n\r\nShall the new role be allowed to create databases? (y\/n) y\r\nShall the new role be allowed to create more new roles? (y\/n) n<\/pre>\n
Roles can also be created from the psql prompt as follows.<\/p>\n
postgres=# create role prad1;\r\nCREATE ROLE<\/pre>\n
This will simply create a role named prad1 with no privileges, not even login privilege. There are various options available in the command prompt using which privileges can be assigned while creating a role or later. Another option which creates roles automatically with login privilege is create user<\/a>.<\/p>\n
postgres=# create user prad2;<\/pre>\n
Listing Roles<\/strong><\/p>\n
All roles in psql can be seen by typing the command \\du<\/p>\n
postgres=# \\du\r\n\r\n\r\nList of roles\r\nRole name |                   Attributes                   | Member of\r\n-----------+------------------------------------------------+-----------\r\npostgres  | Superuser, Create role, Create DB, Replication | {}\r\nprad      | Create DB                                      | {}\r\nprad1     | Cannot login                                   | {}\r\nprad2     |                                                | {}<\/pre>\n
The above output shows\u00a0four roles
\n1) The default postgres role with all permissions
\n2) The role prad which we created from postgres user shell using “createuser” command, with permission to create db
\n3) The role prad1 which we created from postgres prompt using “create role” command with no login privilege
\n4) The role prad2 which we created from postgres prompt using “create user” command which has login privilege enabled by default<\/p>\n
To remove a user or role created above, you can use the drop command.<\/p>\n
postgres=# drop user prad1;<\/pre>\n
Just like mysql, please note than any commands executed in the psql prompt should have a semicolon at the end. Unlike mysql, psql will not throw any error if you missed the semicolon, but the command will not be executed.<\/p>\n
Creating, Viewing and Deleting PostgreSQL Databases<\/strong><\/h3>\n
Like roles, databases also can be created in 2 ways<\/p>\n
a) Directly from the postgres user shell using createdb command<\/p>\n
postgres@teste3:~$ createdb test2<\/pre>\n
b) From the psql prompt using create database command<\/p>\n
postgres=# create database testdb;<\/pre>\n
c) To view the databases created, issue the following command.<\/p>\n
postgres=# \\l\r\nList of databases\r\nName    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges\r\n-----------+----------+----------+-------------+-------------+-----------------------\r\ntestdb | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |\r\npostgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |\r\ntemplate0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c\/postgres          +\r\n|          |          |             |             | postgres=CTc\/postgres\r\ntemplate1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c\/postgres          +\r\n|          |          |             |             | postgres=CTc\/postgres\r\ntest2     | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |\r\n(5 rows)<\/pre>\n
Assigning a user to a database<\/strong><\/p>\n
We have created a user ‘prad’ and database ‘testdb’ above. Now, we will see how to assign the user ‘prad’ to the database ‘testdb’. First, we need to set a password for the user and then grant privileges for the database to the user as follows.<\/p>\n
postgres=# alter user prad with encrypted password 'prad';\r\nALTER ROLE\r\n\r\npostgres=# grant all privileges on database testdb to prad;\r\nGRANT<\/pre>\n
Connecting to the Database<\/strong><\/p>\n
The database connection can be tested via command line interface as follows. We have the database ‘testdb’ with user ‘prad’ with password ‘prad’<\/p>\n
root@teste3:~# psql -U prad -d testdb\r\nPassword for user prad:\r\npsql (9.3.12)\r\nType \"help\" for help.\r\n\r\ntestdb=><\/pre>\n
If you are connecting to a remote database in a remote server, in addition to the above you need to specify the hostname and port as well. The port used my postgresql is 5432 by default. Suppose I am connecting to the remote database testdb on server 1.2.3.4 using username prad. The password for user prad is also ‘prad’. We will connect as follows<\/p>\n
root@teste3:~# psql -h 1.2.3.4 -p 5432 -U prad -W prad -d testdb\r\n\r\nwhere -h is for host,\r\n-p is for port\r\n-U is for username\r\n-W is for password\r\n-d for database<\/pre>\n
If you want to connect via a graphical interface, there are various options available both web based and software like postgresql\u00a0studio<\/a>\u00a0,\u00a0phppgadmin<\/a>\u00a0, postgresql management studio etc<\/p>\n
\"install<\/p>\n
Creating, Updating and Deleting PostgreSQL Tables<\/strong><\/h3>\n
The table creation, data insertion, select statements, deletion etc are pretty much the same as that in mysql. For example, below I am creating a table named test_table. It has three columns namely id, name and age. The field id will contain integer values, name will contain characters and age again will hold integer values. Postgresql allows a lot of data types which can be found here<\/a>. Given below is an example on how the table can be created, how data can be inserted into it, how the inserted data can be viewed and how the table can be deleted.<\/p>\n
root@teste3:~# psql -U prad -d testdb\r\nPassword for user prad:\r\npsql (9.3.12)\r\nType \"help\" for help.\r\n\r\ntestdb=> create table test_table (id int primary key, name varchar (50) not null, age int not null);\r\nCREATE TABLE\r\n\r\ntestdb=> insert into test_table(id, name, age) values (1,'prad',30);\r\nINSERT 0 1\r\n\r\ntestdb=> select * from test_table;\r\nid | name | age\r\n----+------+-----\r\n1 | prad |  30\r\n(1 row)\r\n\r\ntestdb=> drop table test_table;\r\nDROP TABLE\r\n\r\nThe table details can be found by executing \\d with table name on the psql prompt. For example,\r\n\r\ntestdb=> \\d test_table\r\nTable \"public.test_table\"\r\nColumn |         Type          | Modifiers\r\n--------+-----------------------+-----------\r\nid     | integer               | not null\r\nname   | character varying(50) | not null\r\nage    | integer               | not null\r\nIndexes:\r\n\"test_table_pkey\" PRIMARY KEY, btree (id)<\/pre>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
Databases are an important part of any website or software. With relatively large amount of data, all applications use one or the other database method to store data. PostgreSQL, commonly known as Postgres is an open source, object – relational database management system (RDBMS). It was originally designed for unix platforms, however it has been […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31,1],"tags":[104,92],"class_list":["post-311","post","type-post","status-publish","format-standard","hentry","category-linux-tutorials","category-uncategorized","tag-postgresql","tag-ubuntu"],"yoast_head":"\nInstall PostgreSQL in Ubuntu 14 - Copahost<\/title>\n<meta name=\"description\" content=\"Step by step guide about how to install PostgreSQL in Ubuntu 14. Covers also the initial PostgreSQL configuration, security and basic commands.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.copahost.com\/blog\/install-postgresql-ubuntu-14\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Install PostgreSQL in Ubuntu 14 - Copahost\" \/>\n<meta property=\"og:description\" content=\"Step by step guide about how to install PostgreSQL in Ubuntu 14. Covers also the initial PostgreSQL configuration, security and basic commands.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.copahost.com\/blog\/install-postgresql-ubuntu-14\/\" \/>\n<meta property=\"og:site_name\" content=\"Copahost\" \/>\n<meta property=\"article:published_time\" content=\"2016-05-05T18:02:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-05-31T14:21:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.copahost.com\/blog\/wp-content\/uploads\/2016\/05\/pgadmin2-300x92.png\" \/>\n<meta name=\"author\" content=\"Gustavo Bastos\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Gustavo Bastos\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.copahost.com\/blog\/install-postgresql-ubuntu-14\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.copahost.com\/blog\/install-postgresql-ubuntu-14\/\"},\"author\":{\"name\":\"Gustavo Bastos\",\"@id\":\"https:\/\/www.copahost.com\/blog\/#\/schema\/person\/79c41e5bdbfb917d1582160330fa0eca\"},\"headline\":\"Install PostgreSQL in Ubuntu 14\",\"datePublished\":\"2016-05-05T18:02:17+00:00\",\"dateModified\":\"2020-05-31T14:21:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.copahost.com\/blog\/install-postgresql-ubuntu-14\/\"},\"wordCount\":972,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.copahost.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.copahost.com\/blog\/install-postgresql-ubuntu-14\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.copahost.com\/blog\/wp-content\/uploads\/2016\/05\/pgadmin2-300x92.png\",\"keywords\":[\"postgresql\",\"ubuntu\"],\"articleSection\":[\"Linux tutorials\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.copahost.com\/blog\/install-postgresql-ubuntu-14\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.copahost.com\/blog\/install-postgresql-ubuntu-14\/\",\"url\":\"https:\/\/www.copahost.com\/blog\/install-postgresql-ubuntu-14\/\",\"name\":\"Install PostgreSQL in Ubuntu 14 - Copahost\",\"isPartOf\":{\"@id\":\"https:\/\/www.copahost.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.copahost.com\/blog\/install-postgresql-ubuntu-14\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.copahost.com\/blog\/install-postgresql-ubuntu-14\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.copahost.com\/blog\/wp-content\/uploads\/2016\/05\/pgadmin2-300x92.png\",\"datePublished\":\"2016-05-05T18:02:17+00:00\",\"dateModified\":\"2020-05-31T14:21:14+00:00\",\"description\":\"Step by step guide about how to install PostgreSQL in Ubuntu 14. Covers also the initial PostgreSQL configuration, security and basic commands.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.copahost.com\/blog\/install-postgresql-ubuntu-14\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.copahost.com\/blog\/install-postgresql-ubuntu-14\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.copahost.com\/blog\/install-postgresql-ubuntu-14\/#primaryimage\",\"url\":\"https:\/\/www.copahost.com\/blog\/wp-content\/uploads\/2016\/05\/pgadmin2.png\",\"contentUrl\":\"https:\/\/www.copahost.com\/blog\/wp-content\/uploads\/2016\/05\/pgadmin2.png\",\"width\":1237,\"height\":378},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.copahost.com\/blog\/install-postgresql-ubuntu-14\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.copahost.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Install PostgreSQL in Ubuntu 14\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.copahost.com\/blog\/#website\",\"url\":\"https:\/\/www.copahost.com\/blog\/\",\"name\":\"Copahost\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.copahost.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.copahost.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.copahost.com\/blog\/#organization\",\"name\":\"Copahost\",\"url\":\"https:\/\/www.copahost.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.copahost.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.copahost.com\/blog\/wp-content\/uploads\/2016\/03\/copahostlogo.png\",\"contentUrl\":\"https:\/\/www.copahost.com\/blog\/wp-content\/uploads\/2016\/03\/copahostlogo.png\",\"width\":223,\"height\":40,\"caption\":\"Copahost\"},\"image\":{\"@id\":\"https:\/\/www.copahost.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.copahost.com\/blog\/#\/schema\/person\/79c41e5bdbfb917d1582160330fa0eca\",\"name\":\"Gustavo Bastos\",\"url\":\"https:\/\/www.copahost.com\/blog\/author\/gbastos\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Install PostgreSQL in Ubuntu 14 - Copahost","description":"Step by step guide about how to install PostgreSQL in Ubuntu 14. Covers also the initial PostgreSQL configuration, security and basic commands.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.copahost.com\/blog\/install-postgresql-ubuntu-14\/","og_locale":"en_US","og_type":"article","og_title":"Install PostgreSQL in Ubuntu 14 - Copahost","og_description":"Step by step guide about how to install PostgreSQL in Ubuntu 14. Covers also the initial PostgreSQL configuration, security and basic commands.","og_url":"https:\/\/www.copahost.com\/blog\/install-postgresql-ubuntu-14\/","og_site_name":"Copahost","article_published_time":"2016-05-05T18:02:17+00:00","article_modified_time":"2020-05-31T14:21:14+00:00","og_image":[{"url":"https:\/\/www.copahost.com\/blog\/wp-content\/uploads\/2016\/05\/pgadmin2-300x92.png"}],"author":"Gustavo Bastos","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Gustavo Bastos","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.copahost.com\/blog\/install-postgresql-ubuntu-14\/#article","isPartOf":{"@id":"https:\/\/www.copahost.com\/blog\/install-postgresql-ubuntu-14\/"},"author":{"name":"Gustavo Bastos","@id":"https:\/\/www.copahost.com\/blog\/#\/schema\/person\/79c41e5bdbfb917d1582160330fa0eca"},"headline":"Install PostgreSQL in Ubuntu 14","datePublished":"2016-05-05T18:02:17+00:00","dateModified":"2020-05-31T14:21:14+00:00","mainEntityOfPage":{"@id":"https:\/\/www.copahost.com\/blog\/install-postgresql-ubuntu-14\/"},"wordCount":972,"commentCount":0,"publisher":{"@id":"https:\/\/www.copahost.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.copahost.com\/blog\/install-postgresql-ubuntu-14\/#primaryimage"},"thumbnailUrl":"https:\/\/www.copahost.com\/blog\/wp-content\/uploads\/2016\/05\/pgadmin2-300x92.png","keywords":["postgresql","ubuntu"],"articleSection":["Linux tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.copahost.com\/blog\/install-postgresql-ubuntu-14\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.copahost.com\/blog\/install-postgresql-ubuntu-14\/","url":"https:\/\/www.copahost.com\/blog\/install-postgresql-ubuntu-14\/","name":"Install PostgreSQL in Ubuntu 14 - Copahost","isPartOf":{"@id":"https:\/\/www.copahost.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.copahost.com\/blog\/install-postgresql-ubuntu-14\/#primaryimage"},"image":{"@id":"https:\/\/www.copahost.com\/blog\/install-postgresql-ubuntu-14\/#primaryimage"},"thumbnailUrl":"https:\/\/www.copahost.com\/blog\/wp-content\/uploads\/2016\/05\/pgadmin2-300x92.png","datePublished":"2016-05-05T18:02:17+00:00","dateModified":"2020-05-31T14:21:14+00:00","description":"Step by step guide about how to install PostgreSQL in Ubuntu 14. Covers also the initial PostgreSQL configuration, security and basic commands.","breadcrumb":{"@id":"https:\/\/www.copahost.com\/blog\/install-postgresql-ubuntu-14\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.copahost.com\/blog\/install-postgresql-ubuntu-14\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.copahost.com\/blog\/install-postgresql-ubuntu-14\/#primaryimage","url":"https:\/\/www.copahost.com\/blog\/wp-content\/uploads\/2016\/05\/pgadmin2.png","contentUrl":"https:\/\/www.copahost.com\/blog\/wp-content\/uploads\/2016\/05\/pgadmin2.png","width":1237,"height":378},{"@type":"BreadcrumbList","@id":"https:\/\/www.copahost.com\/blog\/install-postgresql-ubuntu-14\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.copahost.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Install PostgreSQL in Ubuntu 14"}]},{"@type":"WebSite","@id":"https:\/\/www.copahost.com\/blog\/#website","url":"https:\/\/www.copahost.com\/blog\/","name":"Copahost","description":"","publisher":{"@id":"https:\/\/www.copahost.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.copahost.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.copahost.com\/blog\/#organization","name":"Copahost","url":"https:\/\/www.copahost.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.copahost.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.copahost.com\/blog\/wp-content\/uploads\/2016\/03\/copahostlogo.png","contentUrl":"https:\/\/www.copahost.com\/blog\/wp-content\/uploads\/2016\/03\/copahostlogo.png","width":223,"height":40,"caption":"Copahost"},"image":{"@id":"https:\/\/www.copahost.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.copahost.com\/blog\/#\/schema\/person\/79c41e5bdbfb917d1582160330fa0eca","name":"Gustavo Bastos","url":"https:\/\/www.copahost.com\/blog\/author\/gbastos\/"}]}},"_links":{"self":[{"href":"https:\/\/www.copahost.com\/blog\/wp-json\/wp\/v2\/posts\/311","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.copahost.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.copahost.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.copahost.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.copahost.com\/blog\/wp-json\/wp\/v2\/comments?post=311"}],"version-history":[{"count":13,"href":"https:\/\/www.copahost.com\/blog\/wp-json\/wp\/v2\/posts\/311\/revisions"}],"predecessor-version":[{"id":2559,"href":"https:\/\/www.copahost.com\/blog\/wp-json\/wp\/v2\/posts\/311\/revisions\/2559"}],"wp:attachment":[{"href":"https:\/\/www.copahost.com\/blog\/wp-json\/wp\/v2\/media?parent=311"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.copahost.com\/blog\/wp-json\/wp\/v2\/categories?post=311"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.copahost.com\/blog\/wp-json\/wp\/v2\/tags?post=311"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}