Hi,
in short terms:
CREATE TABLESPACE
http://www.postgresql.org/docs/8.1/interactive/sql-createtablespace.html
CREATE TABLESPACE tablespace_name [ OWNER username ] LOCATION
'directory'
ALTER INDEX
http://www.postgresql.org/docs/8.1/interactive/sql-alterindex.html
ALTER INDEX name SET TABLESPACE
Hi,
I have one tablespace with all my objects.
I would like to separate indexes from other.
How can I select and move with SQL???
Thank you for your help.
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropria
Hi Group!
I am trying to work & connect php wirh PGSQL on Red Hat ES 3.
I got some Important path like:
/usr/share/pgsql/contrib
/usr/include/pgsql
/usr/bin
But I don't know how to start/stop pgsql server, Insert data from
client pgsql , view database files, admin database & configuration
f
I'm trying to write a pl/pgsql trigger to validate incoming data to an existing
database. One of the fields is defined as character varying (255). Is there any
way of catching over-length data on inserts and silently dropping them? At the
moment, I'm getting the error 'ERROR: value too long for
Title: Postgres at startup
Postgres is starting automatically for me at startup.
When I boot up my machine and then check the running processes I see postmaster.exe and 4 postgres processes.
How can I stop this?
I don’t want Postgres starting up automatically.
Thanks.
-Michael
Please do not remove the list address from the Cc list, otherwise people who
might be able to help you with this won't know to respond.
In this case, that's important, because I don't use the pgadmin3 pgagent, and
so can't help you any further. I'd suggest you look here for support though:
ht
I would try here: http://www.pgadmin.org/docs/1.4/pgagent.html
On Tue, 14 Nov 2006, adey wrote:
Where can I find instructions to get it working please Jim?
I have Postgres and PGAdmin installed but I've not been able to get it
working.
On 11/14/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
Ri
Where can I find instructions to get it working please Jim?
I have Postgres and PGAdmin installed but I've not been able to get it working.
On 11/14/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
Right now the only job scheduling utility for PostgreSQL is the jobagent that was written by the pgAdmin
Is there not a parameter in Postgres to timeout idle connections?
On 11/11/06, imad <[EMAIL PROTECTED]> wrote:
I found it on postgresql archives:
http://archives.postgresql.org/pgsql-admin/2004-09/msg00261.phpThis post was by Tom Lane, I hope this is what you want.It will time out by itself eventua
Drop the index and recreate it in the new tablespace.
On 11/13/06, Alexander Burbello <[EMAIL PROTECTED]> wrote:
Hi,I have one tablespace with all my objects.I would like to separate indexes from other.
How can I select and move with SQL???Thank you for your help.---(end of
I'd like to create a setup where there are exactly 2 masters which
need to be synchronized against each other. The two masters should
have read+write access, but don't have a permanent connection to each
other. One will be on a LAN-server, the other instance will be
installed on a Windows-client-l
Admins,
I'm reading this post:
http://archives.postgresql.org/pgsql-novice/2005-04/msg00221.php
Is it possible and safe to run initdb again on a running database to
change encoding from SQL_ASCII to UTF8?
Will it affect new databases only or existing databases as well?
Thanks.
Ben K.
De
On Thu, Nov 09, 2006 at 08:46:42AM -0500, Jerry Sievers wrote:
> 2. Create new NOT NULL, CHECK and/or FK constraints by inserting them
>into the catalogs directly. NOT NULL is the simplest and requires
>only an update to pg_attribute table. CHECK constraints a bit more
>tricky and req
Right now the only job scheduling utility for PostgreSQL is the job
agent that was written by the pgAdmin folks. Or of course you could use
your OS's built-in scheduling.
On Fri, Nov 10, 2006 at 04:57:42PM -0200, Alexander Burbello wrote:
> Sorry, but now I am in a doubt!!
>
> pgAdmin isn't a too
"Doron Baranes" <[EMAIL PROTECTED]> writes:
> I want to install postgres on red hat linux 7.2 (Enigma).
> how can i find out which version supprt this platform?
As somebody who works for Red Hat, I would strongly advise getting a
newer OS release. You can probably build modern releases of PG to
w
Dear all,
I have posted this at the mailing list pgsql-general, i think it would
be appropriate to post the following question under admin.
I am intending to use JMX to enable my application to be monitored by
the NMS. I am wondering is there any SNMP agent already build-up for
postgres DB and c
Thanks for your answer!How can i issue a cancel?
thanks in advance!On 11/10/06, Simon Riggs <[EMAIL PROTECTED]> wrote:
On Thu, 2006-11-09 at 19:54 +, jose fuenmayor wrote:> Hi all , I have a question or a doubt, when I ran psql remotely it> opens a process on the server, so I issue a query (sel
Doron Baranes wrote:
Hi,
I want to install postgres on red hat linux 7.2 (Enigma).
how can i find out which version supprt this platform?
That might be a bit of a stretch. You could try downloading the SRPM
from the ftp site and building
and RPM. However you may have to update some packages.
Hi,
I have one tablespace with all my objects.
I would like to separate indexes from other.
How can I select and move with SQL???
Thank you for your help.
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating a
Hi,
I want to install postgres on red hat linux 7.2 (Enigma).
how can i find out which version supprt this platform?
10x,
Doron
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
20 matches
Mail list logo
