you're right it's late, i better to get to bed myself, i forgot to
throw in the parameter for the user_id in there, i'm sure you can
figure that one out.
regards,
-
Jonel Rienton
http://blogs.road14.com
Software Developer, *nix Advocate
On Feb 3, 2005, at 1:32 AM, Uwe C. Schroeder wrote:
---
> > Pgpool 2.5b2 supports "master slave mode" which can cope with
> > master/slave replication softwares such as Slony-I. In this mode
> > pgpool sends non SELECT queries to master only. SELECTs are load
> > balanced by pgpool.
>
> Sounds good!
Thanks. Yesterday I have put offcial release of pgpo
Hi Uwe,
I did a solution for you using PLPgSQL,
create or replace function countem() returns varchar as $$
declare
gcount integer;
xcount integer;
result varchar;
begin
select count(*) into gcount
from pix where image_type = 'G';
select count(*) into xcount
sid tow wrote:
HI
I have a problem locating the documentation for "sequence". I want to get the detailed information about the columns present in a sequence table ie when I do
psql=# select * from foo_seq;
sequence_name | last_value | increment_by | max_value | min_value
Sim Zacks wrote:
I merged 2 tables into 1 table and created a view for each of the tables so
as not to break existing applications. I renamed the old tables with the
_old suffix in case there was a problem so I could verify against the old
data.
The problem is that all the views and functions swit
I wrote a very basic entry about this at improveyourweb some weeks ago
(http://www.improveyourweb.com/?q=node/2). Hope it helps.
In the source code, sequence.c, you can read something like:
/*
* Decide whether we should emit a WAL log record. If so, force up
* the fetc
Scott Marlowe wrote:
Method 2 often provides all the protection you need and is quite easy to
program. You basically do something like:
To use this to prevent simultaneous inserts of the same data (for
example if two employees try to insert the same contact into the DB), I
suppose you could use
> > Does it attempt any interaction with Slony when it detects a failure of
the
> > master? It would seem a pity to have pgpool watching the pair to detect
> > failure but having to have a separate watcher process to tell Slony to
> > failover.
>
> If pgpool detects PostgreSQL failure, Slony shoul
Thanks that should help but what about the rest of the columns can u explain what is "is_cycled" and "cache_value". Thanks in advance.Richard Huxton wrote:
sid tow wrote:> HI> > I have a problem locating the documentation for "sequence". I want to get the detailed information about the columns pre
To use this to prevent simultaneous inserts of the same data (for
example if two employees try to insert the same contact into the DB), I
suppose you could use a constraint (before insert) that checks that
there is no data matching the md5 checksum, right?
CREATE TABLE blah
(
mymd5
sid tow wrote:
Thanks that should help but what about the rest of the columns can u
explain what is "is_cycled" and "cache_value". Thanks in advance.
See the manuals. Section "SQL Commands", "CREATE SEQUENCE"
--
Richard Huxton
Archonet Ltd
---(end of broadcast)--
On Wed, 2 Feb 2005 11:16:56 +0200, Sim Zacks <[EMAIL PROTECTED]> wrote:
> I read the following thread from Nov 2002 on the impossibilities of
> modifying a view and I was wondering if anything had changed in this regard
> since then?
> http://archives.postgresql.org/pgsql-hackers/2002-11/msg00609.p
# [EMAIL PROTECTED] / 2005-02-02 23:32:28 -0800:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
>
> Maybe it's to late for me to think correctly (actually I'm sure of
> that). I'm going to ask anyways. I have a table like
>
> id int4
> user_id int4
> photo varchar
> image_type char(1)
>
>
Bricklen Anderson wrote:
Tom Lane wrote:
Bricklen Anderson <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
I would have suggested that maybe this represented on-disk data
corruption, but the appearance of two different but not-too-far-apart
WAL offsets in two different pages suggests that indeed the en
Bricklen Anderson <[EMAIL PROTECTED]> writes:
>> Tom Lane wrote:
>>> But anyway, the evidence seems pretty clear that in fact end of WAL is
>>> in the 73 range, and so those page LSNs with 972 and 973 have to be
>>> bogus. I'm back to thinking about dropped bits in RAM or on disk.
> memtest86+ ra
Hello,
is it somehow possible to hide databases from users?
Example:
I am user postgres1 and I created a database 'pg1db' with owner postgres1.
I log into phppgadmin as user postgres2, and I can see pg1db in the
list. But I don't want to, I want pg1db to be private for user
postgres1, so no one e
Hi folks;
Trying to move from 7.4.1 to 8.0.1
All goes well until I try to reload after installation.
Dump was done with the 8.0.1 pg_dumpall program
On restore, I get thousands of errors on the console, and of course the
data doesn't end up back in the system.
The only two "non-standard" thi
On Thu, Feb 03, 2005 at 07:54:22PM +0100, Martin Balint wrote:
> is it somehow possible to hide databases from users?
You can of course hide the database contents, through the HBA mechanism
(pg_hba.conf). You can't really hide the fact that the database exists.
--
Alvaro Herrera (<[EMAIL PROTE
On Thu, Feb 03, 2005 at 07:54:22PM +0100, Martin Balint wrote:
> is it somehow possible to hide databases from users?
To what end? Are you trying to keep users out of certain databases?
If so, then you can configure pg_hba.conf accordingly.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
On Thu, Feb 03, 2005 at 01:03:57PM -0600, Karl Denninger wrote:
> Trying to move from 7.4.1 to 8.0.1
>
> All goes well until I try to reload after installation.
>
> Dump was done with the 8.0.1 pg_dumpall program
>
> On restore, I get thousands of errors on the console, and of course the
> da
On Thu, Feb 03, 2005 at 01:03:57PM -0600, Karl Denninger wrote:
> Hi folks;
>
> Trying to move from 7.4.1 to 8.0.1
>
> All goes well until I try to reload after installation.
>
> Dump was done with the 8.0.1 pg_dumpall program
>
> On restore, I get thousands of errors on the console, and of c
I know my leading substring searches used to be done via indexes. We
specifically tested that. Since the last time I tested it, the database has
probably been reloaded to fix a corruption problem. Now all I can get is
sequential leading substring searches. In the examples below, the database
wa
So they will see each others database name? I really don't want this
To what end? Are you trying to keep users out of certain databases?
If so, then you can configure pg_hba.conf accordingly.
Yes, I don't even want them to see the database name.
Alvaro Herrera napsal(a):
On Thu, Feb 03, 2005
I've written a function to provide information relating to each row in
an inbox. I'd like to do a query returning some information from each
row of the inbox + some columns from the function pertinent to each row
returned.
I've tried the following on 7.4.6:
t4=> select * from function_message
I have something simlar working on windows in V 8.0
My select loks like:
SELECT *,function_message_context(inbox.rowid) from inbox;
Hope this helps.
Oisin
- Original Message -
From: "Rory Campbell-Lange" <[EMAIL PROTECTED]>
To: "Postgresql General List"
Sent: Thursday, February 03,
Wes <[EMAIL PROTECTED]> writes:
> The locale is showing up as en_US.iso885915. As far as I know, it was
> always this (default RedHat install), so I don't understand why it worked
> before. Did something change between 7.4.1 and 7.4.5? I supposed it's
> possible that I specified locale=C on the
Ok, I found out what was going on with the tsearch2 module and reloading
after an upgrade to 8.0.1 from 7.4.1
The data now loads cleanly, and selects are fine.
HOWEVER, when I attempt an update, I issue the following SQL command (this
table has a tsearch2 vector in it:)
update post set invisible
If I remove the full-text indexing from the table involved (remove the
indices and triggers) then the system is fine.
Somehow, it appears that there's some kind of internal consistency problem
with the tsearch2 package.
Attempts to recreate the indices (after dropping them) fail with the same
Karl Denninger <[EMAIL PROTECTED]> writes:
> Ok, I found out what was going on with the tsearch2 module and reloading
> after an upgrade to 8.0.1 from 7.4.1
> ERROR: cache lookup failed for function 36476
I think that tsearch2's control tables contain function OIDs, which
means that you can't ju
Hi Oisin
On 03/02/05, Oisin Glynn ([EMAIL PROTECTED]) wrote:
> I have something simlar working on windows in V 8.0
> My select loks like:
>
> SELECT *,function_message_context(inbox.rowid) from inbox;
This works great for a function returning a single column. I'm not sure
how to do it with a
This is know issue with OIDS.
You,probably, needed to apply regprocedure_7.4.patch.gz
patch from http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/
Oleg
On Thu, 3 Feb 2005, Karl Denninger wrote:
Ok, I found out what was going on with the tsearch2 module and reloading
after an upgrade t
The patch is in the 8.0.1 version of Tsearch2 already.
The problem is that I have a dump from a 7.4.1 database taken with the
8.0.1 pg_dumpall that I need to be able to get back online on 8.0.x.
Is the only option to find all the functions in the tsearch.sql file, drop
them by hand, remove all th
Thanks, it worked.
On Tue, 1 Feb 2005 00:30:31 -0700, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Tue, Feb 01, 2005 at 12:11:06AM -0700, Pritesh Shah wrote:
> >
> > Is there any way of copying/dumping/restoring the user and group
> > information and permissions from the old machine to the new on
On 2/2/2005 11:57 AM, Bruce Momjian wrote:
Tatsuo Ishii wrote:
Pgpool 2.5b2 supports "master slave mode" which can cope with
master/slave replication softwares such as Slony-I. In this mode
pgpool sends non SELECT queries to master only. SELECTs are load
balanced by pgpool.
Other features of 2.5b2
On 2/3/05 2:29 PM, "Tom Lane" <[EMAIL PROTECTED]> wrote:
> You could use the alternative operator classes for pattern searches, but
> if you want the same indexes to also serve for normal text sorting,
> C locale is the better bet.
As an interim solution until I can reload the database (takes a w
hi,
I'm trying to restore some databases from the plain text format dumps.
To restore I'm using:
psql -e -f nmayande.sql template1
I captured a small part while restoring the database which has an error,
CREATE OPERATOR >= (
PROCEDURE = daterange_greater_than_equals,
LEFTARG = dateran
Wes <[EMAIL PROTECTED]> writes:
> As an interim solution until I can reload the database (takes a weekend),
> can I define two indexes on the same field, one using operator classes and
> one not (and have them automatically used as appropriate)?
Certainly.
regards, tom lan
Pritesh Shah <[EMAIL PROTECTED]> writes:
> I know that the CREATE FUNCTION part should come before using it in
> CREATE OPERATOR. If it was one or two databases i would have edited
> the plain text dump file by hand appropriately.
If you can use the pg_dump from the 8.0 release, it should get this
Hello,
We have a long running DB application using PG7.4.6. We do a VACUUM FULL
every night and a normal 'maintenance' VACUUM every hour. We do nothing with
any indexes. Every now and then we get errors from the database whereby an
update will fail on a table saying that there is duplicate violatio
"Andrew Hall" <[EMAIL PROTECTED]> writes:
> We have a long running DB application using PG7.4.6. We do a VACUUM FULL
> every night and a normal 'maintenance' VACUUM every hour. We do nothing with
> any indexes. Every now and then we get errors from the database whereby an
> update will fail on a ta
Dear list,
I have a problem starting PG 8.0 on a OSX machine, getting this
FATAL: could not open lock file "/tmp/.s.PGSQL.5432.lock": Permission
denied
I checked the privs on /tmp
ls -ld /tmp
lrwxr-xr-x 1 root admin 11 4 Oct 2003 /tmp -> private/tmp
ls -ld /private/tmp
drwx
Does anyone have any useful info about dealing with applications which
"leak" connections, eventually causing "connection limit exceeded for
non superusers?"
Obviously fixing the app is the best choice, but I have a feeling that
this is going to recur again and again since the app is poorly
ma
Hello everyone,
I have a Postgresql 7.4 database that was created on a Fedora 3 box
*prior* to turning off enforcing mode in SELinux, but then has since
been used for some time in permissive mode. Since everything seemed to
be working, I never knew there was a problem until I attempted to set
u
I have need to set up a 2nd database server for a client in their new
offices in another state this month. We will be shutting down the old
offices later this year but we really don't want to have 2-3 days of
downtime while we physically transfer equipment 800 miles.
We should have decent data
hi, how did you install PostgreSQL? from source or from dmg? which user are
you using to start the instance?
On Fri, 4 Feb 2005 00:22:47 +0100, Philippe Schmid wrote
> Dear list,
>
> I have a problem starting PG 8.0 on a OSX machine, getting this
> FATAL: could not open lock file "/tmp/.s
Philippe Schmid <[EMAIL PROTECTED]> writes:
> I have a problem starting PG 8.0 on a OSX machine, getting this
> FATAL: could not open lock file "/tmp/.s.PGSQL.5432.lock": Permission
> denied
Perhaps that file already exists?
regards, tom lane
-
Joseph Kiniry <[EMAIL PROTECTED]> writes:
> Does anyone have any suggestions on this problem? How can I recreate
> pg_user?
Sure, just run the CREATE VIEW command executed by initdb; it's in the
initdb shell script. Note that all the objects created that way (with
"postgres <
On Thu, Feb 03, 2005 at 06:25:50PM -0600, Mike Nolan wrote:
> I have need to set up a 2nd database server for a client in their
> new offices in another state this month. We will be shutting down
> the old offices later this year but we really don't want to have 2-3
> days of downtime while we phy
Got it fixed.
As it happens, there's an "untsearch2.sql" script in the contrib directory.
Removing the transaction block around it allowed it to kill all the "dregs"
from the 7.4.x database entries (on 8.0.1) and a subsequent "tsearch2.sql"
was then able to rebuild them.
I had to reinsert the col
> Slony-1 is perfectly capable of replicating to a slave database, then
> letting you decide to promote it to master, which is just what you'd
> need. Why are you asking about multi-master?
I am concerned that if I have to support the traffic to keep the slave
unit in sync PLUS support general d
On Thu, Feb 03, 2005 at 07:03:36PM -0600, Mike Nolan wrote:
> > Slony-1 is perfectly capable of replicating to a slave database,
> > then letting you decide to promote it to master, which is just
> > what you'd need. Why are you asking about multi-master?
>
> I am concerned that if I have to supp
This one must be obvious for most here.
I have a 170 million rows table from which I want to eliminate
duplicate "would be" keys and leave only uniques.
I found a query in http://www.jlcomp.demon.co.uk/faq/duplicates.html
for the oracle database but can't figure out how to refer to the row
id in
you are perfectly right, fixing the source of the problem is the best way to
fix this. i always make it a habit to close my connections as soon as i'm
done with it. if foxpro won't do it for you, you have to manage your own
resources, always a good practice for unmanaged applications.
i suggest
Hi,
How do I call a StoredProcdure, written in PlPqSql
which returns a set of records (or tableWhatever)
and wants parameters,
from ADO while using "adCmdStoredProc" ?
ERROR: set-valued function called in context that cannot accept a set
-- VERY LONG VERSION OF THIS QUEST
On Thu, Feb 03, 2005 at 06:44:55PM -0600, Karl Denninger wrote:
>
> As it happens, there's an "untsearch2.sql" script in the contrib directory.
That reminds me: it would be useful if all contributed modules had
an unmodule.sql file. That would simplify reloading the module if
the definitions chan
On Thu, Feb 03, 2005 at 06:59:55PM -0700, Michael Fuhr wrote:
> On Thu, Feb 03, 2005 at 06:44:55PM -0600, Karl Denninger wrote:
> >
> > As it happens, there's an "untsearch2.sql" script in the contrib directory.
>
> That reminds me: it would be useful if all contributed modules had
> an unmodule.s
Karl Denninger <[EMAIL PROTECTED]> writes:
> I agree with this - what would be even better would be a way to create
> 'subclasses' for things like this, which could then be 'included' easily.
We could decree that a contrib module's script should create a schema
and shove everything it makes into t
On Thu, Feb 03, 2005 at 10:20:47PM -0500, Tom Lane wrote:
> Karl Denninger <[EMAIL PROTECTED]> writes:
> > I agree with this - what would be even better would be a way to create
> > 'subclasses' for things like this, which could then be 'included' easily.
>
> We could decree that a contrib module'
Have a winXP machine with the above program installed, however, the
service will not start, even when logged in as administrator.
Need a step by step setup procedure for WINDOWS. Is sthere one available
or is there anything available on setup after install? All I have found
is for lilnux-unix-b
On Thu, 3 Feb 2005, Karl Denninger wrote:
The patch is in the 8.0.1 version of Tsearch2 already.
The problem is that I have a dump from a 7.4.1 database taken with the
8.0.1 pg_dumpall that I need to be able to get back online on 8.0.x.
you had to apply patch to 7.4.1 db before dumping or use regp
On Thu, 3 Feb 2005, Karl Denninger wrote:
On Thu, Feb 03, 2005 at 10:20:47PM -0500, Tom Lane wrote:
Karl Denninger <[EMAIL PROTECTED]> writes:
I agree with this - what would be even better would be a way to create
'subclasses' for things like this, which could then be 'included' easily.
We could de
You cannot install the service as administrator, because of security
risks.
Try this thing:
http://pgfoundry.org/projects/pginstaller
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Art Fore
Sent: Thursday, February 03, 2005 9:20 PM
To: pgsql-general@post
Martha Stewart called it a Good Thing when [EMAIL PROTECTED] (Mike Nolan) wrote:
>> Slony-1 is perfectly capable of replicating to a slave database,
>> then letting you decide to promote it to master, which is just what
>> you'd need. Why are you asking about multi-master?
>
> I am concerned that
Hi,
Is there a replication solution for PostgreSQL? I learnt Slony 1 is for Linux OS.
Also, has anyone used the tablellog contrib in Windows environment before?
Best regards.
Tope.Jesus said, I am the way, the truth and the life.
ALL-NEW
Yahoo! Messenger
- all new features - even mo
pgpool 2.5 has the capabilty to perform periodical health checking to
PostgreSQL.
Since pgpool has this capability, how about including a hook that allows a
script to be run when pgpool detects a problem with the master? That would
allow action to be taken to investigate further and, if requ
Tope Akinniyi wrote:
Hi,
Is there a replication solution for PostgreSQL? I learnt Slony 1 is
for Linux OS.
Also, has anyone used the tablellog contrib in Windows environment before?
Hello,
Mammoth Replicator is due to hit in two weeks for Win32. It can be found at:
http://www.commandprompt.c
Hello,
We have a long running DB application using PG7.4.6. We do a VACUUM FULL
every night and a normal 'maintenance' VACUUM every hour. We do nothing with
any indexes. Every now and then we get errors from the database whereby an
update will fail on a table saying that there is duplicate viola
"Mike Cox" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Rob Kelk <[EMAIL PROTECTED]> writes:
>
> > On 03 Feb 2005 16:04:44 -0800, Mike Cox <[EMAIL PROTECTED]> wrote:
> >
> > >Rob Kelk <[EMAIL PROTECTED]> writes:
> > >
> > >> On 03 Feb 2005 13:34:40 -0800, Mike Cox <[EMAIL PROTECTE
Am Donnerstag, 3. Februar 2005 08:32 schrieb Uwe C. Schroeder:
> Maybe it's to late for me to think correctly (actually I'm sure of
> that). I'm going to ask anyways.
> I have a table like
>
> id int4
> user_id int4
> photo varchar
> image_type char(1)
>
> where image_type is either G or X
> What I
Hi all,
Does anyone know if PostgreSQL got a function which work like
load_file() of mySQL?
I need it for uploading of big files... i encounter a memory limit when
i try to upload a query with the file data in it and i recieved this
response for a question about it at php-general maillist:
"loa
Can you not use your table's primary key value instead?
If you table is created with OIDs you may be able to use those -
although I don't know if that this advisable or not since I never use
OIDs...
John Sidney-Woollett
Clodoaldo Pinto wrote:
This one must be obvious for most here.
I have a 170
I have a problem starting PG 8.0 on a OSX machine, getting this
FATAL: could not open lock file "/tmp/.s.PGSQL.5432.lock":
Permission
denied
Perhaps that file already exists?
regards, tom lane
Huu, I feel really stupid... forgot to check invisible files...
Many thanks, it
72 matches
Mail list logo
