{"id":9905,"date":"2017-03-31T17:59:32","date_gmt":"2017-03-31T15:59:32","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/can-i-do-it-with-postgresql-12-dbca-database-configuration-assistant\/"},"modified":"2017-03-31T17:59:32","modified_gmt":"2017-03-31T15:59:32","slug":"can-i-do-it-with-postgresql-12-dbca-database-configuration-assistant","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/can-i-do-it-with-postgresql-12-dbca-database-configuration-assistant\/","title":{"rendered":"Can I do it with PostgreSQL? \u2013 12 \u2013 dbca (database configuration assistant)"},"content":{"rendered":"

Short answer: No. Long answer: No. Every other possible answer: No. There is no such tool in PostgreSQL.
\nIn Oracle you can use the database configuration assistant<\/a> to create your Oracle database. But this is not a must, you can do the same using scripts. Either you use dbca to generate scripts based on the questions you answered in the several screens or you use your own set of scripts to create an Oracle database (You can use dbca templates<\/a> in addition or you invoke dbca in silent mode and pass your options on the command line). In PostgreSQL the steps to create a PostgreSQL instance are totally different, no surprise here. It already starts with the wording: In PostgreSQL you do not create a database you create a database cluster<\/a>. Confused? This has nothing to do with multiple nodes are multiple instances as you know it from Oracle (e.g. Real Application Clusters<\/a>). What a database cluster means are the files on disk (a collection of databases) that are managed by a set of background processes. Cluster just means: belonging together (there are many of types clusters<\/a>, actually). I’ll use the term database instance from now on. So how can you create a database instance after you installed the PostgreSQL binaries?<\/p>\n

<\/p>\n

When you use the graphical installer<\/a> provided to the community by EnterpriseDB a PostgreSQL instance will be created automatically after the binaries have been installed. This will create a service<\/a> on Windows and startup\/shutdown scripts on Linux based operating systems (not sure about Mac OS). On Linux when you install the standard way the installer will require root<\/a> privileges as it needs to add the scripts to startup and shutdown PostgreSQL automatically when then server starts up or does down to the system configuration. Once you started the installer it is just a matter of clicking through the screens:<\/p>\n

\"pg_install_1\"<\/a>
\n\"pg_install_2\"<\/a>
\n\"pg_install_3\"<\/a>
\n\"pg_install_4\"<\/a>
\n\"pg_install_5\"<\/a>
\n\"pg_install_6\"<\/a>
\n\"pg_install_7\"<\/a>
\n\"pg_install_8\"<\/a>
\n\"pg_install_9\"<\/a><\/p>\n

What happened in the background is that the PostgreSQL instance was created and started:<\/p>\n

\npostgres@pgbox:\/home\/postgres\/ [pg960final] ps -ef | grep postgres | egrep -v \"ssh|bash|ps\"\npostgres  3412     1  0 07:30 ?        00:00:00 \/opt\/PostgreSQL\/9.6\/bin\/postgres -D \/opt\/PostgreSQL\/9.6\/data\npostgres  3413  3412  0 07:30 ?        00:00:00 postgres: logger process   \npostgres  3415  3412  0 07:30 ?        00:00:00 postgres: checkpointer process   \npostgres  3416  3412  0 07:30 ?        00:00:00 postgres: writer process   \npostgres  3417  3412  0 07:30 ?        00:00:00 postgres: wal writer process   \npostgres  3418  3412  0 07:30 ?        00:00:00 postgres: autovacuum launcher process   \npostgres  3419  3412  0 07:30 ?        00:00:00 postgres: stats collector process   \npostgres  3805  3579  0 07:56 pts\/0    00:00:00 grep --color=auto postgres\n<\/pre>\n
In addition the installer created a systemd<\/a> service (I am on CentOS<\/a>) so your instance will start up and shutdown automatically (and a postgres user and group, of course):<\/p>\n
\npostgres@pgbox:\/home\/postgres\/ [pg960final] systemctl status postgresql-9.6.service\n\u25cf postgresql-9.6.service - PostgreSQL 9.6 database server\n   Loaded: loaded (\/usr\/lib\/systemd\/system\/postgresql-9.6.service; enabled; vendor preset: disabled)\n   Active: active (running) since Fri 2017-03-31 07:30:01 CEST; 28min ago\n  Process: 3410 ExecStart=\/opt\/PostgreSQL\/9.6\/bin\/pg_ctl start -w -t ${TimeoutSec} -D \/opt\/PostgreSQL\/9.6\/data -l \/opt\/PostgreSQL\/9.6\/data\/pg_log\/startup.log (code=exited, status=0\/SUCCESS)\n Main PID: 3412 (postgres)\n   CGroup: \/system.slice\/postgresql-9.6.service\n           \u251c\u25003412 \/opt\/PostgreSQL\/9.6\/bin\/postgres -D \/opt\/PostgreSQL\/9.6\/data\n           \u251c\u25003413 postgres: logger process   \n           \u251c\u25003415 postgres: checkpointer process   \n           \u251c\u25003416 postgres: writer process   \n           \u251c\u25003417 postgres: wal writer process   \n           \u251c\u25003418 postgres: autovacuum launcher process   \n           \u2514\u25003419 postgres: stats collector process   \n<\/pre>\n
From now on you can connect to the instance and start your journey:<\/p>\n
\npostgres@pgbox:\/home\/postgres\/ [pg960final] \/opt\/PostgreSQL\/9.6\/bin\/psql postgres\nPassword: \npsql.bin (9.6.2)\nType \"help\" for help.\n\npostgres= \\l\n                                  List of databases\n   Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges   \n-----------+----------+----------+-------------+-------------+-----------------------\n postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | \n template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c\/postgres          +\n           |          |          |             |             | postgres=CTc\/postgres\n template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c\/postgres          +\n           |          |          |             |             | postgres=CTc\/postgres\n(3 rows)\n\npostgres=\n<\/pre>\n
But this is not the only method for creating a PostgreSQL instance. On Linux most of the distributions provide PostgreSQL packages in their repositories which you then can install using yum (when you are on RedHat based systems)<\/a> or apt (when you are on Debian based systems<\/a> (There are others as well, such as YaST on SuSE<\/a> but yum and apt are the most popular, I believe). In my case, using the official CentOS repositories, I can use yum and check what CentOS provides:<\/p>\n
\npostgres@pgbox:\/home\/postgres\/ [pg960final] yum search postgresql\n...\npostgresql.i686 : PostgreSQL client programs\npostgresql.x86_64 : PostgreSQL client programs\npostgresql-contrib.x86_64 : Extension modules distributed with PostgreSQL\npostgresql-devel.i686 : PostgreSQL development header files and libraries\npostgresql-devel.x86_64 : PostgreSQL development header files and libraries\npostgresql-docs.x86_64 : Extra documentation for PostgreSQL\npostgresql-jdbc.noarch : JDBC driver for PostgreSQL\npostgresql-jdbc-javadoc.noarch : API docs for postgresql-jdbc\npostgresql-libs.i686 : The shared libraries required for any PostgreSQL clients\npostgresql-libs.x86_64 : The shared libraries required for any PostgreSQL clients\npostgresql-odbc.x86_64 : PostgreSQL ODBC driver\npostgresql-plperl.x86_64 : The Perl procedural language for PostgreSQL\npostgresql-plpython.x86_64 : The Python2 procedural language for PostgreSQL\npostgresql-pltcl.x86_64 : The Tcl procedural language for PostgreSQL\npostgresql-server.x86_64 : The programs needed to create and run a PostgreSQL server\npostgresql-test.x86_64 : The test suite distributed with PostgreSQL\npostgresql-upgrade.x86_64 : Support for upgrading from the previous major release of PostgreSQL\n...\n<\/pre>\n
The packagers decided to split PostgreSQL into several packages as you can see above. If you only want to install the core server you would:<\/p>\n
\n[root@centos7 ~] yum install postgresql-server.x86_64\n<\/pre>\n
In this case the instance will not be created automatically:<\/p>\n
\n[root@centos7 ~] ps -ef | grep postgres\nroot      9981  4558  0 08:18 pts\/0    00:00:00 grep --color=auto postgres\n<\/pre>\n
But, as with the graphical installer above, a systemd service was created for you:<\/p>\n
\n[root@centos7 ~] systemctl list-unit-files | grep postgres\npostgresql.service                            disabled\n<\/pre>\n
Then we can just enable and start the service?<\/p>\n
\n[root@centos7 ~] systemctl enable postgresql.service\nCreated symlink from \/etc\/systemd\/system\/multi-user.target.wants\/postgresql.service to \/usr\/lib\/systemd\/system\/postgresql.service.\n[root@centos7 ~] systemctl start postgresql.service\nJob for postgresql.service failed because the control process exited with error code. See \"systemctl status postgresql.service\" and \"journalctl -xe\" for details.\n<\/pre>\n
Not really. What the installation with yum did not do for you is to create the instance. The good thing with the CentOS provided packages is that you get helpers to create the instance which are not there by default. For creating the instance you would:<\/p>\n
\n-bash-4.2$ sudo postgresql-setup initdb\nInitializing database ... OK\n<\/pre>\n
… and your instance got created but not yet started. To start it:<\/p>\n
\n-bash-4.2$ sudo systemctl start postgresql.service\n-bash-4.2$ psql postgres\npsql (9.2.18)\nType \"help\" for help.\n\n<\/pre>\n
Quite easy. But here you can see one issue with the packages provided by the Linux distributions. What was installed in my case is PostgreSQL 9.2.18 and there are some points to consider with that: The latest PostgreSQL 9.2 release is 9.2.20 (as of today). So you miss 2 minor versions containing bug fixes. Even more important PostgreSQL 9.2 will go out of support<\/a> this September because it was released almost 5 years ago, the current release is 9.6.2 (supported until September 2021). Not a good choice for running a production server.<\/p>\n
Luckily there is another possibility: The PostgreSQL community provides repositories as well. There is one for yum based systems<\/a> and one for apt based systems<\/a>. For getting the yum based repositories into CentOS you would (for PostgreSQL 9.6):<\/p>\n
\n[root@centos7 ~] wget https:\/\/download.postgresql.org\/pub\/repos\/yum\/9.6\/redhat\/rhel-7-x86_64\/pgdg-centos96-9.6-3.noarch.rpm\n[root@centos7 ~] yum localinstall pgdg-centos96-9.6-3.noarch.rpm \n<\/pre>\n
When you check what is available now you’ll find this:<\/p>\n
\npostgresql96.x86_64 : PostgreSQL client programs and libraries\npostgresql96-contrib.x86_64 : Contributed source and binaries distributed with PostgreSQL\npostgresql96-debuginfo.x86_64 : Debug information for package postgresql96\npostgresql96-devel.x86_64 : PostgreSQL development header files and libraries\npostgresql96-docs.x86_64 : Extra documentation for PostgreSQL\npostgresql96-libs.x86_64 : The shared libraries required for any PostgreSQL clients\npostgresql96-odbc.x86_64 : PostgreSQL ODBC driver\npostgresql96-plperl.x86_64 : The Perl procedural language for PostgreSQL\npostgresql96-plpython.x86_64 : The Python procedural language for PostgreSQL\npostgresql96-pltcl.x86_64 : The Tcl procedural language for PostgreSQL\npostgresql96-server.x86_64 : The programs needed to create and run a PostgreSQL server\npostgresql96-tcl.x86_64 : A Tcl client library for PostgreSQL\npostgresql96-tcl-debuginfo.x86_64 : Debug information for package postgresql96-tcl\npostgresql96-test.x86_64 : The test suite distributed with PostgreSQL\n<\/pre>\n
Installation is the same as with the CentOS repositories above:<\/p>\n
\n[root@centos7 ~] yum install postgresql96-server.x86_64\n[root@centos7 ~] systemctl list-unit-files | grep postgres\npostgresql-9.6.service    \n[root@centos7 ~] systemctl enable postgresql-9.6.service\nCreated symlink from \/etc\/systemd\/system\/multi-user.target.wants\/postgresql-9.6.service to \/usr\/lib\/systemd\/system\/postgresql-9.6.service.\n[root@centos7 ~] ls \/usr\/pgsql-9.6\/bin\/initdb ^C\n[root@centos7 ~] su - postgres\nLast login: Fri Mar 31 08:29:10 CEST 2017 on pts\/1\n-bash-4.2$ \/usr\/pgsql-9.6\/bin\/initdb\nThe files belonging to this database system will be owned by user \"postgres\".\nThis user must also own the server process.\n\nThe database cluster will be initialized with locale \"en_US.UTF-8\".\nThe default database encoding has accordingly been set to \"UTF8\".\nThe default text search configuration will be set to \"english\".\n\nData page checksums are disabled.\n\nfixing permissions on existing directory \/var\/lib\/pgsql\/9.6\/data ... ok\ncreating subdirectories ... ok\nselecting default max_connections ... 100\nselecting default shared_buffers ... 128MB\nselecting dynamic shared memory implementation ... posix\ncreating configuration files ... ok\nrunning bootstrap script ... ok\nperforming post-bootstrap initialization ... ok\nsyncing data to disk ... ok\n\nWARNING: enabling \"trust\" authentication for local connections\nYou can change this by editing pg_hba.conf or using the option -A, or\n--auth-local and --auth-host, the next time you run initdb.\n\nSuccess. You can now start the database server using:\n\n    \/usr\/pgsql-9.6\/bin\/pg_ctl -D \/var\/lib\/pgsql\/9.6\/data -l logfile start\n\n-bash-4.2$ sudo systemctl start postgresql-9.6.service\n-bash-4.2$ \/usr\/pgsql-9.6\/bin\/psql postgres\npsql (9.6.2)\nType \"help\" for help.\n\npostgres= \\l\n                                  List of databases\n   Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges   \n-----------+----------+----------+-------------+-------------+-----------------------\n postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | \n template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c\/postgres          +\n           |          |          |             |             | postgres=CTc\/postgres\n template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c\/postgres          +\n           |          |          |             |             | postgres=CTc\/postgres\n(3 rows)\n<\/pre>\n
And ready. The packages provided by the PostgreSQL community are a much better choice than the ones provided by your distributions because here you get the latest ones.<\/p>\n
What we did above as an extra step was calling a utility which is named “initdb”. initdb<\/a> is the tool you use to create the PostgreSQL instance after you installed the binaries. The graphical installer uses initdb in the background as well as there is no other way to do it. When you compile and install PostgreSQL from source you would need to use initdb to create your PostgreSQL instance as well.<\/p>\n
Conclusion: Depending on how you install PostgreSQL onto your system the PostgreSQL instance is created automatically (when you use the installer provided by EnterpriseDB), almost automatically when you use the packages provided by your distribution and almost automatically when you use the packages provided directly by the PostgreSQL community. In the next post we’ll look at initdb in more detail.<\/p>\n","protected":false},"excerpt":{"rendered":"
Short answer: No. Long answer: No. Every other possible answer: No. There is no such tool in PostgreSQL. In Oracle you can use the database configuration assistant to create your Oracle database. But this is not a must, you can do the same using scripts. Either you use dbca to generate scripts based on the […]<\/p>\n","protected":false},"author":29,"featured_media":9906,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[77],"type_dbi":[],"class_list":["post-9905","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-postgresql"],"acf":[],"yoast_head":"\nCan I do it with PostgreSQL? \u2013 12 \u2013 dbca (database configuration assistant) - dbi Blog<\/title>\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.dbi-services.com\/blog\/can-i-do-it-with-postgresql-12-dbca-database-configuration-assistant\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Can I do it with PostgreSQL? \u2013 12 \u2013 dbca (database configuration assistant)\" \/>\n<meta property=\"og:description\" content=\"Short answer: No. Long answer: No. Every other possible answer: No. There is no such tool in PostgreSQL. In Oracle you can use the database configuration assistant to create your Oracle database. But this is not a must, you can do the same using scripts. Either you use dbca to generate scripts based on the […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/can-i-do-it-with-postgresql-12-dbca-database-configuration-assistant\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-03-31T15:59:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pg_install_1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"552\" \/>\n\t<meta property=\"og:image:height\" content=\"425\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Daniel Westermann\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@westermanndanie\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Daniel Westermann\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/can-i-do-it-with-postgresql-12-dbca-database-configuration-assistant\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/can-i-do-it-with-postgresql-12-dbca-database-configuration-assistant\\\/\"},\"author\":{\"name\":\"Daniel Westermann\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"headline\":\"Can I do it with PostgreSQL? \u2013 12 \u2013 dbca (database configuration assistant)\",\"datePublished\":\"2017-03-31T15:59:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/can-i-do-it-with-postgresql-12-dbca-database-configuration-assistant\\\/\"},\"wordCount\":882,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/can-i-do-it-with-postgresql-12-dbca-database-configuration-assistant\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/pg_install_1.png\",\"keywords\":[\"PostgreSQL\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/can-i-do-it-with-postgresql-12-dbca-database-configuration-assistant\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/can-i-do-it-with-postgresql-12-dbca-database-configuration-assistant\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/can-i-do-it-with-postgresql-12-dbca-database-configuration-assistant\\\/\",\"name\":\"Can I do it with PostgreSQL? \u2013 12 \u2013 dbca (database configuration assistant) - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/can-i-do-it-with-postgresql-12-dbca-database-configuration-assistant\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/can-i-do-it-with-postgresql-12-dbca-database-configuration-assistant\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/pg_install_1.png\",\"datePublished\":\"2017-03-31T15:59:32+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/can-i-do-it-with-postgresql-12-dbca-database-configuration-assistant\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/can-i-do-it-with-postgresql-12-dbca-database-configuration-assistant\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/can-i-do-it-with-postgresql-12-dbca-database-configuration-assistant\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/pg_install_1.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/pg_install_1.png\",\"width\":552,\"height\":425},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/can-i-do-it-with-postgresql-12-dbca-database-configuration-assistant\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Can I do it with PostgreSQL? \u2013 12 \u2013 dbca (database configuration assistant)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/8d08e9bd996a89bd75c0286cbabf3c66\",\"name\":\"Daniel Westermann\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"caption\":\"Daniel Westermann\"},\"description\":\"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\\\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.\",\"sameAs\":[\"https:\\\/\\\/x.com\\\/westermanndanie\"],\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/daniel-westermann\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Can I do it with PostgreSQL? \u2013 12 \u2013 dbca (database configuration assistant) - dbi Blog","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.dbi-services.com\/blog\/can-i-do-it-with-postgresql-12-dbca-database-configuration-assistant\/","og_locale":"en_US","og_type":"article","og_title":"Can I do it with PostgreSQL? \u2013 12 \u2013 dbca (database configuration assistant)","og_description":"Short answer: No. Long answer: No. Every other possible answer: No. There is no such tool in PostgreSQL. In Oracle you can use the database configuration assistant to create your Oracle database. But this is not a must, you can do the same using scripts. Either you use dbca to generate scripts based on the […]","og_url":"https:\/\/www.dbi-services.com\/blog\/can-i-do-it-with-postgresql-12-dbca-database-configuration-assistant\/","og_site_name":"dbi Blog","article_published_time":"2017-03-31T15:59:32+00:00","og_image":[{"width":552,"height":425,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pg_install_1.png","type":"image\/png"}],"author":"Daniel Westermann","twitter_card":"summary_large_image","twitter_creator":"@westermanndanie","twitter_misc":{"Written by":"Daniel Westermann","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/can-i-do-it-with-postgresql-12-dbca-database-configuration-assistant\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/can-i-do-it-with-postgresql-12-dbca-database-configuration-assistant\/"},"author":{"name":"Daniel Westermann","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"headline":"Can I do it with PostgreSQL? \u2013 12 \u2013 dbca (database configuration assistant)","datePublished":"2017-03-31T15:59:32+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/can-i-do-it-with-postgresql-12-dbca-database-configuration-assistant\/"},"wordCount":882,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/can-i-do-it-with-postgresql-12-dbca-database-configuration-assistant\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pg_install_1.png","keywords":["PostgreSQL"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/can-i-do-it-with-postgresql-12-dbca-database-configuration-assistant\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/can-i-do-it-with-postgresql-12-dbca-database-configuration-assistant\/","url":"https:\/\/www.dbi-services.com\/blog\/can-i-do-it-with-postgresql-12-dbca-database-configuration-assistant\/","name":"Can I do it with PostgreSQL? \u2013 12 \u2013 dbca (database configuration assistant) - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/can-i-do-it-with-postgresql-12-dbca-database-configuration-assistant\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/can-i-do-it-with-postgresql-12-dbca-database-configuration-assistant\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pg_install_1.png","datePublished":"2017-03-31T15:59:32+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/can-i-do-it-with-postgresql-12-dbca-database-configuration-assistant\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/can-i-do-it-with-postgresql-12-dbca-database-configuration-assistant\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/can-i-do-it-with-postgresql-12-dbca-database-configuration-assistant\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pg_install_1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pg_install_1.png","width":552,"height":425},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/can-i-do-it-with-postgresql-12-dbca-database-configuration-assistant\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Can I do it with PostgreSQL? \u2013 12 \u2013 dbca (database configuration assistant)"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66","name":"Daniel Westermann","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","caption":"Daniel Westermann"},"description":"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.","sameAs":["https:\/\/x.com\/westermanndanie"],"url":"https:\/\/www.dbi-services.com\/blog\/author\/daniel-westermann\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9905","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=9905"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9905\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/9906"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=9905"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=9905"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=9905"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=9905"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}