Also this:
http://www.postgresql.org/docs/9.2/static/textsearch-configuration.html
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Gauthier, Dave
Sent: Wednesday, July 10, 2013 3:49 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] How to
http://www.postgresql.org/message-id/440d446e.7040...@cybertec.at
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Gauthier, Dave
Sent: Wednesday, July 10, 2013 3:49 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] How to implement a value
That worked. Thank you Adrian
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@gmail.com]
Sent: Thursday, February 23, 2012 9:58 AM
To: pgsql-general@postgresql.org
Cc: Carlos Oliva
Subject: Re: [GENERAL] Dynamic File Name for COPY TO in Stored Procedure
On Thursday
Hi,
What would it be the correct format for using a variable in a stored
procedure that uses COPY TO?
I have the current stored procedure:
CREATE FUNCTION Table_To_File(text) RETURNS void AS $delimeter$
COPY (SELECT * FROM table_to_xml('table', true, false, '')) TO '$1'
WITH CSV QUOTE ' ';
$de
Hi,
What would it be the correct format for using a variable in a stored
procedure that uses COPY TO?
I have the current stored procedure:
CREATE FUNCTION Table_To_File(text) RETURNS void AS $delimeter$
COPY (SELECT * FROM table_to_xml('table', true, false, '')) TO '$1'
WITH CSV QUOTE ' ';
$de
Is there a way to create a database or a table of a database in its own
folder? We are looking for ways to backup the sytem files of the
database to tape and one to exclude some tables from this backup. We
can selectively backup folders of the file system so we figure that if
we can create a sche
Is there a way to create a database or a table of a database in its own
folder? We are looking for ways to backup the sytem files of the
database to tape and one to exclude some tables from this backup. We
can selectively backup folders of the file system so we figure that if
we can create a sche
[mailto:gryz...@gmail.com]
Sent: Tuesday, June 02, 2009 10:27 AM
To: Carlos Oliva
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Schema, databse, or tables in different system folder
yes, it is called tablespace.
[mailto:gryz...@gmail.com]
Sent: Tuesday, June 02, 2009 10:27 AM
To: Carlos Oliva
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Schema, databse, or tables in different system folder
yes, it is called tablespace.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
Would the backup be unrecoverable if I shutdown the databse first?
"Chris Browne" wrote in message
news:87ab4qfs48@dba2.int.libertyrms.com...
"Carlos Oliva" writes:
Is there a way to create a database or a table of a database in its own
folder? We are looking fo
We will probably pg_dump the data for backups and look at using Slony for
replication. We thank you and Gregor for the time that you spent sharing
your insights with us.
"Bill Moran" wrote in message
news:20090604104302.50e23318.wmo...@potentialtech.com...
> In response to
in message
news:20090604095554.c2d57008.wmo...@potentialtech.com...
> In response to "Carlos Oliva" :
>
>> I think that I understand. Would we need to stop the databse and then do
>> the copy? Is this the state to which you are refering? If the tables
>> never
&g
the
databse in the correct state a week later, a month later, a year later?
""Grzegorz Jaskiewicz"" wrote in message
news:2f4958ff0906040549u53bafe7br772033214d43e...@mail.gmail.com...
On Thu, Jun 4, 2009 at 1:23 PM, Carlos Oliva wrote:
> In which state do we need to put
7f...@mail.gmail.com...
On Thu, Jun 4, 2009 at 1:07 PM, Carlos Oliva wrote:
> Thanks again Grzgorz for your expedicious reply. Would anything else
> change
> in the database for a table once it ceases to be updated? We have several
> tables for which a number of records is inserted and nev
b5a38b7ka1a4b1f3a4ce...@mail.gmail.com...
pg_xlog and clog is something that is used during operation, and for
point in time recovery.
It doesn't go to database dump at all, not needed.
On Thu, Jun 4, 2009 at 12:32 PM, Carlos Oliva wrote:
> Thank you for your response Grzegorx. It is helping us a gr
ot; wrote in message
news:20090603161817.131e706e.wmo...@potentialtech.com...
> In response to "Carlos Oliva" :
>
>> Can the synchronization with Slony run while the old database is still
>> being
>> updated daily? I am wondering if we can just let Slony run u
t;Grzegorz Jaskiewicz"" wrote in message
news:2f4958ff0906031217h2a0bfe0t674f266d4397e...@mail.gmail.com...
On Wed, Jun 3, 2009 at 8:14 PM, Bill Moran wrote:
> In response to "Carlos Oliva" :
>
>> Woudl it be possible to keep the current postgresql version running in a
&
altech.com...
> In response to Grzegorz Jaskiewicz :
>
>> On Wed, Jun 3, 2009 at 8:14 PM, Bill Moran
>> wrote:
>> > In response to "Carlos Oliva" :
>> >
>> >> Woudl it be possible to keep the current postgresql version running in
>> &g
""Grzegorz Jaskiewicz"" wrote in message
news:2f4958ff0906031214k3dfaa4b2mae5733d7345f7...@mail.gmail.com...
On Wed, Jun 3, 2009 at 8:03 PM, Carlos Oliva wrote:
> Woudl it be possible to keep the current postgresql version running in a
> different port, install a new
the
database access for parts of the application until we complete the migration
to the new version.
""Grzegorz Jaskiewicz"" wrote in message
news:2f4958ff0906031157v32fb9810j9476fd950e494...@mail.gmail.com...
> On Wed, Jun 3, 2009 at 5:11 PM, Carlos Oliva wrote:
>>
Would I need to upgrade the entire cluster or can I just upgrade database
wise?
""Grzegorz Jaskiewicz"" wrote in message
news:2f4958ff0906030845t526db574q464c17072fadd...@mail.gmail.com...
> if you upgrade to different major version, yes. If between minor
> releases (say 8.1.4->8.1.5) than no, w
rowne" wrote in message
news:87prdlgurv@dba2.int.libertyrms.com...
> "Carlos Oliva" writes:
>> Would the backup be unrecoverable if I shutdown the databse first?
>
> If the backup includes pg_xlog and pg_clog, as well as all of the
> database metadata files, the
altech.com...
> In response to "Carlos Oliva" :
>
>> If I were to upgrade the database version, would I need to dump and
>> restore
>> all the data?
>
> If you upgrade patch releases (i.e. from 8.3.4 -> 8.3.5) then usually no,
> but see the release note
If I were to upgrade the database version, would I need to dump and restore
all the data?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Is there a way to create a database or a table of a database in its own
folder? We are looking for ways to backup the sytem files of the database
to tape and one to exclude some tables from this backup. We can selectively
backup folders of the file system so we figure that if we can create a
Hi Lloyd,
Please ignore searches on names that are in lower case. The PBSI-EMR will
search only on first and last names that are in upper case. In this way, we
are synchronized with PBSI-DOC which uses and sends only upper case names,
and we avoid searching problems. Teresa and I have discussed
in advance for your response.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Alan Hodgson
Sent: Tuesday, June 06, 2006 11:05 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Backwards index scan
On June 6, 2006 07:59 am, "Carlos Oliva&quo
Are there any configurations/flags that we should re-set for
the database (v 7.4.x) in order to enable a backwards scan on an index?
We are trying to query a table in descending order. We added an index
that we were hoping would be scanned backwards but EXPLAIN never indicates that
the op
12:01 PM
To: Carlos Oliva
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Reindexdb
Carlos Oliva wrote:
> Hi Joshua,
> I think that it was installed from a RedHat distribution and the
> installation left out reindexdb from the contrib folder. I will look into
> this.
>
>
trying to
eliminate index bloating.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Joshua D. Drake
Sent: Thursday, May 11, 2006 11:27 AM
To: Carlos Oliva
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Reindexdb
Carlos Oliva wrote:
> -->
&
Hi,
Where can I find information about installing and
running contrib/reindexdb? I have searched the manuals and appendixes without
much luck. I just know that there is a contrib for reindexing an entire
database.
We run postgresql (v 7.4.x) in Linux RedHat.
SYTmpDir, SYT | 2006-02-23 14:04:49.498836-05 | 00:00:00.558588
|
9667
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Michael Fuhr
Sent: Thursday, February 23, 2006 1:36 PM
To: Carlos Oliva
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Exclu
statement; not functions.
I will look further into these queries in case that they are using
functions.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Michael Fuhr
Sent: Thursday, February 23, 2006 1:09 PM
To: Carlos Oliva
Cc: pgsql-general
CTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Martijn van
Oosterhout
Sent: Thursday, February 23, 2006 10:04 AM
To: Carlos Oliva
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] ExclusiveLock without a relation in pg_locks
On Thu, Feb 23, 2006 at 08:54:36AM -0500, Carlos Oliva wrote:
> Would co
CTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Michael Fuhr
Sent: Thursday, February 23, 2006 10:05 AM
To: Carlos Oliva
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] ExclusiveLock without a relation in pg_locks
On Thu, Feb 23, 2006 at 08:54:36AM -0500, Carlos Oliva wrote:
> Would connection
Would connections to a database require crating an extra
ExclusiveLock? We have some connections to the database that happen to be “idle
in transaction” and their pids have a granted “Exclusive Lock”
in pg_locks. I cannot discern the tables where the ExclusiveLock is being
held because the
table of the database?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Matthew T. O'Connor
Sent: Thursday, November 10, 2005 3:44 PM
To: Carlos Oliva
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Performance of autovacuum and full vacu
uum -d2 -D -U postgres > /tmp/vacuum.log 2>&1"&
Thank you in advance for your response.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Matthew T. O'Connor
Sent: Thursday, November 10, 2005 2:46 PM
To: Carlos Oliva
Cc: pgsql-general
Hi Forum,
Should autovacuum reclaim most of the free space of a
database? We are trying to configure our database and running
pg_autovacuum to streamline our database. We have increased the
max_fsm_pages to a value larger than the total pages needed (see the output
from a full vacuum bel
)?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jim C. Nasby
Sent: Monday, November 07, 2005 2:38 PM
To: Carlos Oliva
Cc: 'Tom Lane'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Setting max_fsm_pages
On Sun, Nov 06, 2005 at 08:05:29PM -0500, Ca
b -f -z -v)
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Saturday, November 05, 2005 10:23 PM
To: Carlos Oliva
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Setting max_fsm_pages
"Carlos Oliva" <[EMAIL PROTECTED]>
Should I set the max_fsm_pages to the value reported (vacuum
verbose) as pages stored or the value reported as total pages needed? I
ran full + analyze vacuums in my database (vacuumdb –f –z –v ) a couple of times and I got the following reports:
INFO: free space map: 454 relations,
2227
Could anyone suggest something that we can check to
ascertain why pg_dumps fail? The pg_dump for our database just started to fail
this week. Dumps of the same database succeeded just last week. Moreover, we
can create a new database using the database (that we are trying to dump) as a
t
Thank you Philip. I found everything and installed the functions
successfully.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Philip Hallstrom
Sent: Friday, August 19, 2005 2:48 PM
To: Carlos Oliva
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL
Thank you Phillip. I was able to install the functions with the command
that you posted. I will look for the documents on the usage of these
functions.
-Original Message-
From: Philip Hallstrom [mailto:[EMAIL PROTECTED]
Sent: Friday, August 19, 2005 2:48 PM
To: Carlos Oliva
Cc: pgsql
Where can I find instructions to install these functions in
my 7.4 version? I am awaret hat they are in the contrib. folder but I have
never installed functions from the contrib folder. Thanks in advance.
Carlos
Hi Forum,
Is there a SQL sentence that one could build in order to
pull a bytea out of a table and save it into a file? Currently I do this by
getting a record set and outputting to a stream. I am using a developer
interface which would let me send a SQL sentence easily without having to
Thank you Michael. I am using the BIT_LENGTH function which seems to return
the size in bits of the stored blob
"Michael Fuhr" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> On Tue, Jan 25, 2005 at 04:58:33PM -0500, Carlos wrote:
>
>> Is there a way that I can find out the size of
Thank you Michael. This should work
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Michael Glaesemann
Sent: Wednesday, October 27, 2004 9:27 AM
To: Carlos
Cc: '[EMAIL PROTECTED]'
Subject: Re: [GENERAL] Changing access permissions without re-starting the
nks in advance for your response.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Tuesday, June 24, 2003 10:32 AM
To: Carlos
Cc: [EMAIL PROTECTED]; Dain
Subject: Re: [GENERAL] Eliminating start error message: "unary operator
"Car
gresql
service: ' -e 1
+ '[' color '!=' verbose -a -z '' ']'
+ echo_success
+ '[' color = color ']'
+ echo -en '\033[60G'
[60G+ echo -n '[ '
[ + '[' color = color ']'
+ echo -en '\033[1;32
art)
start
;;
stop)
stop
;;
status)
status postmaster
;;
restart)
restart
;;
condrestart)
condrestart
;;
reload|force-reload)
reload
;;
*)
echo $"Usage: $0
{start|stop|status|resta
Postgresql was installed from RPMS, downloaded from the following url:
ftp://ftp5.us.postgresql.org/pub/PostgreSQL/binary/v7.3.2/RPMS/redhat-7.
3/
The startup script was created when the rpms were installed.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
] Allowing user to connect to a database?
On 19/06/2003 14:04 Carlos Oliva wrote:
> Hi Paul,
> This worked very well. Perhaps, you can help me with another
> question: If I write an aaa bbb ccc of 200.200.200.0, do all clientes
> with IP addresses between 0.0.0.0 and 200.200.200.0 can con
54 matches
Mail list logo
