ental variable.
On my Ubuntu Dapper system PostgreSQL (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 t
lly I don't think this is a neat solution but has the virtue of
working. My own understanding of redirection is rudimentary at best.
It's a topic well worth researching on it's own merit.
Good luck.
John Purser
---(end of broadcast)
space map settings
Richard,
EXCELLENT resource. Thank you very much.
John Purser
--
The abuse of greatness is when it disjoins remorse from power.
-- William Shakespeare, "Julius Caesar"
---(end of broadcast)---
TIP 1
> broadcast)--- TIP 6: explain analyze is your
> friend
Sundar,
Take a look at the documentation at:
http://www.postgresql.org/docs/8.1/static/maintenance.html#AUTOVACUUM
There are a lot of configuration options that effect the autovacuum
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
o different databases with two
different connections and ditto for connecting to two different
clusters.
John Purser
--
Always do right. This will gratify some people and astonish the rest.
-- Mark Twain
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
ULL , NULL, 0); }
> after ECPG does its internal conversion from .pgc to .c
>
> Regards,
> ~Jas
>
It has been my impression that PosgreSQL REALLY likes 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 --
cast)--- TIP 3: Have you checked our
> extensive FAQ?
>
>http://www.postgresql.org/docs/faq
Karen,
You hopefully just need to edit your search path. See page 56 of the
manual for details. Type 'show search_path;' into pgsql and see w
an index scan if your
> joining column's datatypes do not match
As of 8.1.0 UNIQUE constraints are not inherited. See page 62 of the
documentation.
John Purser
--
Courage is your greatest present need.
---(end of broadcast)---
TIP 9: In
about running cygwin from
a cd drive. You might want to check out their archives and see if you
could use that information.
http://www.cygwin.com/
Good luck.
John Purser
--
You will never know hunger.
---(end of broadcast)---
TIP 9: In versi
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:
> >
>
tach TO the server FROM "anywhere" so why have a portable
installation? 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
t format=unaligned
--pset fieldsep=',' -c '' -d
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.
Seco
do you mean by "debug"? Speaking purely for myself I'd appreciate
it if you fixed windows FIRST. Then turn your skills to fixing
PostgreSQL.
John Purser
---(end of broadcast)---
TIP 6: explain analyze is your friend
advance,
> Blair.
>
>
> ---(end of
> broadcast)--- TIP 2: Don't 'kill -9' the
> postmaster
Blair,
How about setting up a seperate schema (private), adding your
customer's database to it (leaving it
14 matches
Mail list logo
