{"id":1151,"date":"2014-11-04T22:40:39","date_gmt":"2014-11-04T22:40:39","guid":{"rendered":"https:\/\/www.bgeo.es\/?page_id=1151"},"modified":"2022-01-13T16:34:41","modified_gmt":"2022-01-13T16:34:41","slug":"postgresql","status":"publish","type":"page","link":"https:\/\/www.bgeo.es\/en\/postgresql\/","title":{"rendered":"PostgreSQL"},"content":{"rendered":"

[et_pb_section fb_built=”1″ fullwidth=”on” _builder_version=”4.9.0″ global_colors_info=”{}”][et_pb_fullwidth_header title=” PostgreSQL” text_orientation=”center” _builder_version=”4.9.0″ title_font=”|700||on|||||” title_text_align=”center” title_text_color=”#FFFFFF” title_font_size=”45px” title_letter_spacing=”5px” background_color=”#1A80B6″ background_image=”https:\/\/www.bgeo.es\/wp-content\/uploads\/2021\/07\/postgres_bgeo.jpg” background_layout=”light” custom_padding=”100px||100px|” title_text_shadow_style=”preset3″ title_text_shadow_color=”#000000″ global_colors_info=”{}” button_one_text_size__hover_enabled=”off” button_two_text_size__hover_enabled=”off” button_one_text_color__hover_enabled=”off” button_two_text_color__hover_enabled=”off” button_one_border_width__hover_enabled=”off” button_two_border_width__hover_enabled=”off” button_one_border_color__hover_enabled=”off” button_two_border_color__hover_enabled=”off” button_one_border_radius__hover_enabled=”off” button_two_border_radius__hover_enabled=”off” button_one_letter_spacing__hover_enabled=”off” button_two_letter_spacing__hover_enabled=”off” button_one_bg_color__hover_enabled=”off” button_two_bg_color__hover_enabled=”off”][\/et_pb_fullwidth_header][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.9.0″ custom_padding=”||||false|false” global_colors_info=”{}”][et_pb_row _builder_version=”4.9.0″ _module_preset=”default” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.9.0″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.9.0″ _module_preset=”default” text_font=”||||||||” global_colors_info=”{}”]<\/p>\n

Object-oriented and open source relational database management system<\/span> <\/span><\/span><\/span><\/h2>\n

PostgreSQL<\/strong> is an object-relational database management system, distributed under a BSD license and with its freely available source code. It is the most powerful open source database management system on the market, and in its latest versions has nothing to envy to other commercial databases. <\/span><\/span><\/span><\/p>\n

PostgreSQL<\/strong> uses a client \/ server model and uses multiprocessors to ensure system stability. This means that an error in one of the processes will not affect the rest and the system will continue to run. In fact, its technical characteristics make it as one of the most powerful and robust databases on the market. Stability, power, robustness, ease of administration and implementation of standards have been the features that have been most taken into account during its development. It works well with large amounts of data and a high turnout of users while accessing the system. <\/span><\/span><\/span><\/p>\n

This versatility, combined with its open and free structure, allows it to be perfectly associated and synchronized with the other solutions developed and implemented by BGEO<\/strong>, such as GIS tools<\/strong> or the water cycle management software, Giswater<\/strong>.\u00a0
<\/span><\/span><\/span><\/p>\n

[\/et_pb_text][et_pb_button button_url=”https:\/\/www.postgresql.org\/about\/featurematrix\/” url_new_window=”on” button_text=”View the full list of features available for all versions of PostgreSQL” button_alignment=”left” _builder_version=”4.13.1″ _module_preset=”default” locked=”off” global_colors_info=”{}”][\/et_pb_button][et_pb_image src=”https:\/\/www.bgeo.es\/wp-content\/uploads\/2021\/11\/postgresql-1-scaled.jpg” alt=”Postgresql” title_text=”Postgresql” _builder_version=”4.13.1″ _module_preset=”default” locked=”off” global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.9.0″ background_color=”#E8E8E8″ custom_padding=”||||false|false” locked=”off” global_colors_info=”{}”][et_pb_row _builder_version=”4.9.0″ _module_preset=”default” custom_padding=”||0px||false|false” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.9.0″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.9.0″ _module_preset=”default” text_font=”||||||||” text_text_color=”#000000″ custom_padding=”||5px||false|false” global_colors_info=”{}”]<\/p>\n

KEY FEATURES OF POSTGRESQL<\/h3>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”2_3,1_3″ _builder_version=”4.9.0″ _module_preset=”default” custom_padding=”0px||||false|false” global_colors_info=”{}”][et_pb_column type=”2_3″ _builder_version=”4.9.0″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.9.0″ _module_preset=”default” text_font=”||||||||” global_colors_info=”{}”]<\/p>\n

<\/strong>Open source Software:<\/strong> PostgreSQL software is free and free licensed. In addition to being able to associate and synchronize perfectly with other solutions such as GIS tools or water cycle management software, GISWATER.<\/span><\/span><\/span><\/p>\n

Client \/ Server Model:<\/strong> PostgreSQL uses the client \/ server and multiprocessor model to ensure system stability, so an error in one of the processes will not affect the rest and the system will continue to run.<\/span> <\/span><\/span><\/span><\/span><\/p>\n

Proper functionality:<\/strong> This software works well with large amounts of data and high user concurrences while accessing the system.<\/span> <\/span><\/span><\/span><\/span><\/p>\n

Highly extensible:<\/strong> With PostgreSQL you can define your own data types, create custom functions, you can even write code in different programming languages without having to recompile your database.<\/span> <\/span><\/span><\/span><\/span><\/p>\n

Features for developers and administrators:<\/strong> PostgreSQL incorporates many features designed to help developers build applications, and administrators to protect data integrity, create fault-tolerant environments, and help manage data whether they are large data sets or<\/span> small.<\/span> <\/span><\/span><\/span><\/p>\n

 <\/p>\n

[\/et_pb_text][et_pb_button button_url=”https:\/\/www.postgresql.org\/download\/” url_new_window=”on” button_text=”Download the PostgreSQL software” _builder_version=”4.9.0″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_button][\/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.9.0″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ module_id=”row-six” _builder_version=”4.9.0″ background_color=”gcid-d8eaa081-4be0-4518-bf91-03c8b6e95d5a” locked=”off” global_colors_info=”{%22gcid-d8eaa081-4be0-4518-bf91-03c8b6e95d5a%22:%91%22background_color%22%93}”][et_pb_row _builder_version=”4.9.0″ animation_direction=”top” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.9.0″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_cta title=”Contact us to learn more about POSTGRESQL” button_url=”@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF9saW5rX3VybF9wYWdlIiwic2V0dGluZ3MiOnsicG9zdF9pZCI6Ijk5In19@” url_new_window=”on” button_text=”Contact” _builder_version=”4.9.0″ _dynamic_attributes=”button_url” _module_preset=”default” background_enable_color=”off” custom_button=”on” button_text_color=”#0C71C3″ button_bg_color=”#FFFFFF” link_option_url_new_window=”on” global_colors_info=”{}”]<\/p>\n

Contact us<\/strong> and we will arrange a visit to show you the tool.<\/span><\/span><\/span><\/p>\n

[\/et_pb_cta][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

Object-oriented and open source relational database management system PostgreSQL is an object-relational database management system, distributed under a BSD license and with its freely available source code. It is the most powerful open source database management system on the market, and in its latest versions has nothing to envy to other commercial databases. PostgreSQL uses […]<\/p>\n","protected":false},"author":1,"featured_media":6479,"parent":0,"menu_order":4,"comment_status":"open","ping_status":"open","template":"","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"[separator top=\"-20\"]\r\n[two_third]\r\n

PostgreSQL:<\/h2>\r\n