(which was build from source, not
the .deb) this is set from SysV startup script located
at /etc/init.d/postgresql. To change the default directory run
initdb -D New Directory then change the data directory in the SysV
init script. Stop and restart PostgreSQL.
John Purser
.
John Purser
--
The abuse of greatness is when it disjoins remorse from power.
-- William Shakespeare, Julius Caesar
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail
daemon.
John Purser
--
You will pay for your sins. If you have already paid, please disregard
this message.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
the data in a single database, the one
specified in the connection request.
http://www.postgresql.org/docs/8.1/static/ddl-schemas.html
Now your CLIENT can connect to two different databases with two
different connections and ditto for connecting to two different
clusters.
John Purser
--
Always
to know who it's
talking to. I'd include a user name with my connection string at the
least.
John Purser
--
Learn to pause -- or nothing worthwhile can catch up to you.
---(end of broadcast)---
TIP 5: don't forget to increase your free space map
;' into pgsql and see what
the value is currently set to. Then use set to make it include the
schema with your function.
John Purser
--
I must have a prodigious quantity of mind; it takes me as much as a
week sometimes to make it up.
-- Mark Twain, The Innocents Abroad
of the
documentation.
John Purser
--
Courage is your greatest present need.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
. Then turn your skills to fixing
PostgreSQL.
John Purser
---(end of broadcast)---
TIP 6: explain analyze is your friend
HERE' -d DATABASE NAME HERE
I think that will give you the output you were after assuming you're
scripting psql and that you replace the values in with appropriate
values. The syntax is slightly different from the psql command line.
Second:
man psql is your friend.
John Purser
? Not arguing, just trying to understand.
John Purser
--
Beware the one behind you.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
On Tue, 9 May 2006 17:06:53 -0400
Rodrigo Cortés [EMAIL PROTECTED] wrote:
On 5/9/06, John Purser [EMAIL PROTECTED] wrote:
On Tue, 9 May 2006 16:54:37 -0400
Rodrigo Cortés [EMAIL PROTECTED] wrote:
It is possible to install postgres on usb driver to run it
anywhere???
Im trying
that information.
http://www.cygwin.com/
Good luck.
John Purser
--
You will never know hunger.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do
about setting up a seperate schema (private), adding your
customer's database to it (leaving it in public) and then backing up
private.customerdb?
/UNTESTED
John Purser
--
You need more time; and you probably always will.
---(end of broadcast
13 matches
Mail list logo