Thread: Where is 'createdb'?
This is probably a question for the authors of a book I have been reading but it may be faster to get an answer here.
I was trying to follow along in a book ‘Seven Databases in Seven Weeks’ and chapter 2 deals with PostgreSQL. One of the first things it does is issue a command ‘createdb book’. The text before this command says, “Once you have Postgres installed, create a schema called book using the following command: $ createdb book’ But when I tried to issue this command (at a Linux command prompt) I get ‘createdb command not found’. Are the authors out of date? What is the current command?
Kevin
This is probably a question for the authors of a book I have been reading but it may be faster to get an answer here.
I was trying to follow along in a book ‘Seven Databases in Seven Weeks’ and chapter 2 deals with PostgreSQL. One of the first things it does is issue a command ‘createdb book’. The text before this command says, “Once you have Postgres installed, create a schema called book using the following command: $ createdb book’ But when I tried to issue this command (at a Linux command prompt) I get ‘createdb command not found’. Are the authors out of date? What is the current command?
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
Torsdag 1. november 2012 16.32.42 skrev Kevin Burton : > This is probably a question for the authors of a book I have been reading > but it may be faster to get an answer here. > > > > I was trying to follow along in a book 'Seven Databases in Seven Weeks' and > chapter 2 deals with PostgreSQL. One of the first things it does is issue a > command 'createdb book'. The text before this command says, "Once you have > Postgres installed, create a schema called book using the following > command: $ createdb book' But when I tried to issue this command (at a > Linux command prompt) I get 'createdb command not found'. Are the authors > out of date? What is the current command? leif@balapapa ~ $ which createdb /usr/bin/createdb regards, Leif
This is probably a question for the authors of a book I have been reading but it may be faster to get an answer here.
I was trying to follow along in a book ‘Seven Databases in Seven Weeks’ and chapter 2 deals with PostgreSQL. One of the first things it does is issue a command ‘createdb book’. The text before this command says, “Once you have Postgres installed, create a schema called book using the following command: $ createdb book’ But when I tried to issue this command (at a Linux command prompt) I get ‘createdb command not found’. Are the authors out of date? What is the current command?
Kevin
I type ‘find createdb’ and I get an error find: ‘createdb’ no such file or directory.
From: Magnus Hagander [mailto:magnus@hagander.net]
Sent: Thursday, November 01, 2012 10:38 AM
To: Kevin Burton
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Where is 'createdb'?
On Thu, Nov 1, 2012 at 4:32 PM, Kevin Burton <rkevinburton@charter.net> wrote:
This is probably a question for the authors of a book I have been reading but it may be faster to get an answer here.
I was trying to follow along in a book ‘Seven Databases in Seven Weeks’ and chapter 2 deals with PostgreSQL. One of the first things it does is issue a command ‘createdb book’. The text before this command says, “Once you have Postgres installed, create a schema called book using the following command: $ createdb book’ But when I tried to issue this command (at a Linux command prompt) I get ‘createdb command not found’. Are the authors out of date? What is the current command?
The authors are incorrect, in that this doesn't actually create a schema. It creates a database. but they are not out of tdate, just incorrect - it has never created a schema.
That said, the createdb command ships with postgresql still and should be avaiable. Exactly where it is depends on how you installed PostgreSQL, and which distribution of Linux you are on. You can probably find it with "find", or by looking at the contents of whichever package you used to install it.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
I type ‘find createdb’ and I get an error find: ‘createdb’ no such file or directory.
From: Magnus Hagander [mailto:magnus@hagander.net]
Sent: Thursday, November 01, 2012 10:38 AM
To: Kevin Burton
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Where is 'createdb'?
On Thu, Nov 1, 2012 at 4:32 PM, Kevin Burton <rkevinburton@charter.net> wrote:
This is probably a question for the authors of a book I have been reading but it may be faster to get an answer here.
I was trying to follow along in a book ‘Seven Databases in Seven Weeks’ and chapter 2 deals with PostgreSQL. One of the first things it does is issue a command ‘createdb book’. The text before this command says, “Once you have Postgres installed, create a schema called book using the following command: $ createdb book’ But when I tried to issue this command (at a Linux command prompt) I get ‘createdb command not found’. Are the authors out of date? What is the current command?
The authors are incorrect, in that this doesn't actually create a schema. It creates a database. but they are not out of tdate, just incorrect - it has never created a schema.
That said, the createdb command ships with postgresql still and should be avaiable. Exactly where it is depends on how you installed PostgreSQL, and which distribution of Linux you are on. You can probably find it with "find", or by looking at the contents of whichever package you used to install it.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
Which exact OS/distribution/PostgreSQL-version are you using and how was PostgreSQL installed (OS-provided or 3rd-party)? The different packagers deal with things in a variety of ways almost all of which are different than how PostgreSQL will be installed if compiling from source with default options.I type ‘find createdb’ and I get an error find: ‘createdb’ no such file or directory.
Ubuntu, for example, will typically include a (non-PostgreSQL-provided) helper package called postgresql-common which is designed to ease running multiple versions of PostgreSQL on a single machine. It also allows different users to connect to different clusters and has some version-to-version update facilities (which were more important in the pre-pg_upgrade era).
In Ubuntu, therefore, executables, data and configuration are in version-specific subdirectories (/usr/lib/postgresql/VERSION/..., /etc/postgresql/VERSION/..., /var/lib/postgresql/VERSION/...) and commands like "createdb" (/usr/bin/createdb) are actually links to /usr/share/postgresql-common/pg_wrapper which loads the appropriate user/version-specific executable (e.g. /usr/lib/postgresql/9.1/bin/createdb).
But RHEL/CentOS has a somewhat different layout as do other distributions and OSs and the layouts have evolved over time so what was correct for, say, Ubuntu 9.04 will differ from 12.10. Similarly, a general installer like EnterpriseDB's one-click installer will use a different layout than the distribution-specific installations.
Cheers,
Steve
From: rkevinburton@charter.net
To: pgsql-general@postgresql.org
Subject: [GENERAL] Where is 'createdb'?
Date: Thu, 1 Nov 2012 10:32:42 -0500
This is probably a question for the authors of a book I have been reading but it may be faster to get an answer here.
I was trying to follow along in a book ‘Seven Databases in Seven Weeks’ and chapter 2 deals with PostgreSQL. One of the first things it does is issue a command ‘createdb book’. The text before this command says, “Once you have Postgres installed, create a schema called book using the following command: $ createdb book’ But when I tried to issue this command (at a Linux command prompt) I get ‘createdb command not found’. Are the authors out of date? What is the current command?
Kevin
On Fri, Nov 2, 2012 at 2:37 AM, Magnus Hagander <magnus@hagander.net> wrote: > > On Thu, Nov 1, 2012 at 4:32 PM, Kevin Burton <rkevinburton@charter.net> > wrote: >> >> The text before this command says, “Once >> you have Postgres installed, create a schema called book using the following >> command: $ createdb book’ > > The authors are incorrect, in that this doesn't actually create a schema. It > creates a database. but they are not out of tdate, just incorrect - it has > never created a schema. Sounds like the author has a MySQL background, where "schema" and "database" are synonyms. (I have no idea why MySQL doesn't just use "schema" and declare that there's only one "database" per install. That would be much simpler.) ChrisA
This is probably a question for the authors of a book I have been reading but it may be faster to get an answer here.
I was trying to follow along in a book ‘Seven Databases in Seven Weeks’ and chapter 2 deals with PostgreSQL. One of the first things it does is issue a command ‘createdb book’. The text before this command says, “Once you have Postgres installed, create a schema called book using the following command: $ createdb book’ But when I tried to issue this command (at a Linux command prompt) I get ‘createdb command not found’. Are the authors out of date? What is the current command?
Kevin
The instructions start with "Once you have Postgres installed...".
Since the command is not available, you don't have Postgres installed.
$ which createdb
/usr/bin/createdb
$ rpm -q --whatprovides /usr/bin/createdb
postgresql-9.1.6-1.fc17.x86_64
Best regards,
Zoltán Böszörményi
-- ---------------------------------- Zoltán Böszörményi Cybertec Schönig & Schönig GmbH Gröhrmühlgasse 26 A-2700 Wiener Neustadt, Austria Web: http://www.postgresql-support.de http://www.postgresql.at/
This is not correct. What it means is that the command you typed is not in your search path or aliased in some way. The command may very well be available elsewhere (see my earlier post in the thread for an example of where Ubuntu places things).2012-11-01 16:32 keltezéssel, Kevin Burton írta:
The instructions start with "Once you have Postgres installed...".
Since the command is not available, you don't have Postgres installed.
Useful on rpm-based distros but I believe the OP is running a Debian-derivative which uses apt.
$ which createdb
/usr/bin/createdb
$ rpm -q --whatprovides /usr/bin/createdb
postgresql-9.1.6-1.fc17.x86_64
Cheers,
Steve
I watched while the OS was installed and it looked like postgres was installed but the Ubuntu package apparently didn’t install it all or it didn’t install it correctly.
From: Steve Crawford [mailto:scrawford@pinpointresearch.com]
Sent: Thursday, November 01, 2012 4:43 PM
To: Boszormenyi Zoltan
Cc: Kevin Burton; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Where is 'createdb'?
On 11/01/2012 02:10 PM, Boszormenyi Zoltan wrote:
2012-11-01 16:32 keltezéssel, Kevin Burton írta:
...I get ‘createdb command not found’. Are the authors out of date? What is the current command?
The instructions start with "Once you have Postgres installed...".
Since the command is not available, you don't have Postgres installed.
This is not correct. What it means is that the command you typed is not in your search path or aliased in some way. The command may very well be available elsewhere (see my earlier post in the thread for an example of where Ubuntu places things).
$ which createdb
/usr/bin/createdb
$ rpm -q --whatprovides /usr/bin/createdb
postgresql-9.1.6-1.fc17.x86_64
Useful on rpm-based distros but I believe the OP is running a Debian-derivative which uses apt.
Cheers,
Steve
You may have installed a portion of PostgreSQL - possibly just the client stuff (psql, libraries and such needed to connect to a PostgreSQL server). The deb package is usually called "postgresql-client-VERSION". Make sure you have installed the server which is just called "postgresql-VERSION".I watched while the OS was installed and it looked like postgres was installed but the Ubuntu package apparently didn’t install it all or it didn’t install it correctly.
Optionally you can install postgresql-contrib which contains a large variety of available extensions (the package installs them on your machine but you have to selectively install the specific extensions you want into your database - see "create extension" and look for info on "contrib").
You can also install a variety of languages for use in writing procedural functions in PostgreSQL (plperl, plpython, pllua, pltcl, ...).
Cheers,
Steve
Le jeudi 01 novembre 2012 à 16:49 -0500, Kevin Burton a écrit : > I watched while the OS was installed and it looked like postgres was > installed but the Ubuntu package apparently didn’t install it all or > it didn’t install it correctly. > to list the postgresql related packages installed on your system, use : dpkg -l postgres* (note : lower case 'l') to list the files each installed package provides, use : dpkg -L <package-name> e.g. : dpkg -L postgresql-client-8.4 (note : upper case 'L') -- Vincent Veyron http://marica.fr/ Logiciel de gestion des assurances sinistres et des dossiers contentieux pour le service juridique