Jaisen N.D. wrote:
Hai, I use Debian Etch. I have a problem with postgresql 8.1. I have
uninstalled the postgresql-8.3, which I was took from debian back ports,
removed its configuration files, and the user postgres also.
It sounds like you didn't remove the data directory,
/var/lib/postgresql/d
Hi all, i'm trying to setup PITR on my postgresql ( i run version 1.8.11 );
Following the docs and tips from the list this is what i made:
1) set up a crontab which copys the last-created WAL file in
/home/postgres/WAL
2) set up a shell-script as a the archive_command: it copyes WAL files
from
On Apr 11, 5:45 am, [EMAIL PROTECTED] ("Albe Laurenz") wrote:
>
> Format the output.
>
> For example, the "17408" in the query above is a result from the
> first query.
>
> If you had triggers, constraints, rules or indexes associated
> with the table or the table would INHERIT another table, you'd
Hi all, i'm trying to setup PITR on my postgresql ( i run version 1.8.11 );
Following the docs and tips from the list this is what i made:
1) set up a crontab which copys the last-created WAL file in
/home/postgres/WAL
2) set up a shell-script as a the archive_command: it copyes WAL files
from
Hai, I use Debian Etch. I have a problem with postgresql 8.1. I have
uninstalled the postgresql-8.3, which I was took from debian back ports,
removed its configuration files, and the user postgres also. Then installed
postgresql-8.1. But when I started to create a database, it shows some
message li
On Fri, 2008-04-11 at 22:07 +0400, Oleg Bartunov wrote:
> We have the same problem with names in astronomy, so we implemented
> dict_regex http://vo.astronet.ru/arxiv/dict_regex.html
> Check it out !
Oleg-
This gets me a lot closer. Thank you. I have two remaining problems.
The first problem
"Bharat Patel" <[EMAIL PROTECTED]> writes:
> I have a table that has 5.4 million rows of data in it. 4.6 million of
> these rows are just administrative messages and not necessary so I'd like to
> delete them. If I try and delete them, it takes 69 minutes to delete ~650K
> rows.
I'm betting on a
Hello,
I'm new to postgres and the work of DB's.
I'm running postres 7.4 on RHLinux 3.
I have a table that has 5.4 million rows of data in it. 4.6 million of
these rows are just administrative messages and not necessary so I'd like to
delete them. If I try and delete them, it takes 69 minut
On Apr 11, 2008, at 4:23 PM, Stefan Sturm wrote:
Hello,
Am 11.04.2008 um 18:41 schrieb Andrew Sullivan:
On Fri, Apr 11, 2008 at 03:09:43PM +0200, Stefan Sturm wrote:
DBVisualizer stoped working and no I have two processes on my
server:
postgres 30873 0.0 0.7 46552 7124 ?Ss 12:
On Fri, 11 Apr 2008 14:27:09 -0500
"Adam Rich" <[EMAIL PROTECTED]> wrote:
> > Is there a switch (php side or pg side) to avoid things like:
> >
> > pg_query("select id from table1 where a=$i");
> >
> > into becoming
> >
> > pg_query("select id from table1 where a=1 and 1=1; do something
> > nas
[EMAIL PROTECTED] (Ivan Sergio Borgonovo) writes:
> Is there a switch (php side or pg side) to avoid things like:
>
> pg_query("select id from table1 where a=$i");
>
> into becoming
>
> pg_query("select id from table1 where a=1 and 1=1; do something
> nasty; -- ");
>
> So that every
> pg_query(...)
Hello,
Am 11.04.2008 um 18:41 schrieb Andrew Sullivan:
On Fri, Apr 11, 2008 at 03:09:43PM +0200, Stefan Sturm wrote:
DBVisualizer stoped working and no I have two processes on my server:
postgres 30873 0.0 0.7 46552 7124 ?Ss 12:33 0:01
postgres: postgres dbName 10.0.1.198(53658
> Is there a switch (php side or pg side) to avoid things like:
>
> pg_query("select id from table1 where a=$i");
>
> into becoming
>
> pg_query("select id from table1 where a=1 and 1=1; do something
> nasty; -- ");
Ideally, you'd use this:
pg_query_params('select id from table1 where a=$1', a
Is there a switch (php side or pg side) to avoid things like:
pg_query("select id from table1 where a=$i");
into becoming
pg_query("select id from table1 where a=1 and 1=1; do something
nasty; -- ");
So that every
pg_query(...) can contain no more than one statement?
thanks
--
Ivan Sergio Bo
We have the same problem with names in astronomy, so we implemented
dict_regex http://vo.astronet.ru/arxiv/dict_regex.html
Check it out !
Oleg
On Thu, 10 Apr 2008, Reece Hart wrote:
I'd like to use tsearch2 to index protein and gene names. Unfortunately,
such names are written inconsistently a
Reece Hart <[EMAIL PROTECTED]> writes:
> For the purposes of indexing these names, I suspect I'd get the majority
> of cases by removing a hyphen when it's followed by 1 or 2 chars from
> [a-zA-Z0-9]. Does that require a custom parser?
Yeah, looks like it:
regression=# select * from ts_debug('MCL
On Fri, Apr 11, 2008 at 7:09 AM, Stefan Sturm
<[EMAIL PROTECTED]> wrote:
> Hello,
>
> altered a database using DBVisualizer. When I hit execute, DBVisualizer
> stoped working and no I have two processes on my server:
> postgres 30873 0.0 0.7 46552 7124 ?Ss 12:33 0:01 postgres:
> p
On Fri, Apr 11, 2008 at 03:09:43PM +0200, Stefan Sturm wrote:
> DBVisualizer stoped working and no I have two processes on my server:
> postgres 30873 0.0 0.7 46552 7124 ?Ss 12:33 0:01
> postgres: postgres dbName 10.0.1.198(53658) ALTER TABLE waiting
> postgres 31007 0.0 0.6 46
I'd like to use tsearch2 to index protein and gene names. Unfortunately,
such names are written inconsistently and sometimes with hyphens. For
example, MCL-1 and MCL1 are semantically equivalent but with the default
parser and to_tsvector, I see this:
[EMAIL PROTECTED]> select to_tsvector(
"Obe, Regina" <[EMAIL PROTECTED]> writes:
> Does PostgreSQL use the COMMUTATOR property of an operator to determine
> if flip-flopped arguments can be collapsed.
No. In recent releases we don't even bother to look for simple
duplicate clauses (it's seldom worth the cycles), let alone clauses that
This is sorted now chaps, I was missing a system locale.
ta
Glyn
- Original Message
> From: Glyn Astill <[EMAIL PROTECTED]>
> To: pgsql-general@postgresql.org
> Sent: Friday, 11 April, 2008 2:59:56 PM
> Subject: [GENERAL] createdb: database creation failed: ERROR: encoding
> LATIN1 doe
am Thu, dem 10.04.2008, um 21:26:14 -0600 mailte kevin kempter folgendes:
> I can get the number of days since the start of the fiscal year like
> this:
>
> # select date '01/01/2007' - date '09/01/2006' as interval;
> interval
> --
> 122
> (1 row)
>
> However I'm stumped [er h
Hi all, dear Richard,
your mail about my configuration parameter were the right hint, but i am still
struggling with the problem. i will appreciate if you or somebody else can
help me even further.
After some investigation i got some new results to my problem. The following
query is not workin
Miguel A. Lopera Tejero escribió:
> I need some help. We have a Web application connecting to a postgresql
> 8.2 database on Windows Server 2003. According to the log, we logged on
> the server using a remote control desktop, after uninstalling Tomcat we
> installed a new Tomcat version. After tha
When trying to specify an encoding to initdb I get:
createdb: database creation failed: ERROR: encoding LATIN1 does not match
server's locale en_GB.UTF-8
8.2 Used to let us create any encoding in initdb. I see that it was in the todo
to make this change, but how do I create my database in LATI
Hello,
altered a database using DBVisualizer. When I hit execute,
DBVisualizer stoped working and no I have two processes on my server:
postgres 30873 0.0 0.7 46552 7124 ?Ss 12:33 0:01
postgres: postgres dbName 10.0.1.198(53658) ALTER TABLE waiting
postgres 31007 0.0 0.6 46
Pavan Deolasee wrote:
I wonder if it would make sense to add support to mount database in
*read-only* mode from multiple servers though. I am thinking about
data warehouse kind of operations where multiple servers can be
used answer read-only queries. Is there a use case for such applications
in
Does PostgreSQL use the COMMUTATOR property of an operator to determine
if flip-flopped arguments can be collapsed.
I used to think it did until someone pointed it doesn't - For example
in the below
SELECT b.*
FROM boszip b INNER JOIN landparcels l
ON (b.the_geom && l.the_geom AND l.the_geom
On Thu, Apr 10, 2008 at 10:26 PM, kevin kempter
<[EMAIL PROTECTED]> wrote:
> However I'm stumped [er how to get the number of months from 09/01/2007
> thru 01/01/2007
select extract(month from (age(date '2007-1-1', date '2006-9-1')));
--
Sent via pgsql-general mailing list (pgsql-general@postgr
On 11/04/2008 09:58, J Ottery wrote:
Thanks Craig for making me look like an idiot. I feel bad now.
When I posted I suspected that what you have just replied with was the
case.
I'm sure that wasn't Craig's intent. I'd hazard a guess that you've been
using Access or a similar single-file-based
On Apr 11, 5:34 pm, [EMAIL PROTECTED] ("A.
Kretschmer") wrote:
> am Thu, dem 10.04.2008, um 23:53:18 -0700 mailte J Ottery folgendes:
>
> > Using windows XP and TCP/IP network.
>
> > I install PostgreSQL on a client PC and put the data files on a
> > networked drive (instead of the local drive).
On Thu, Apr 10, 2008 at 11:29 PM, Dennis Brakhane
<[EMAIL PROTECTED]> wrote:
>
> I believe it does. See
> http://www.postgresql.org/docs/8.3/interactive/sql-set-constraints.html
> and the DEFERRABLE keyword in CREATE TABLE.
>
> Or am I missing something here?
>
Only foreign key contrains chec
On Fri, Apr 11, 2008 at 1:04 PM, A. Kretschmer
<[EMAIL PROTECTED]> wrote:
>
>
> You idea is complete ill. PostgreSQL is a Server-Client-database, with
> one Server and multiple Clients. You can't access to the same
> database-files with multiple database-servers.
>
I wonder if it would make sen
Andrew Falanga wrote:
> > > I know about the -E option to psql and did that to get the following,
> > > which is what psql does for a \d :
> >
[...]
> >
> > > Now, I tried to execute these queries one at a time and they failed,
> > > somewhat miserably. In what order does PostgreSQL actually execu
am Thu, dem 10.04.2008, um 23:53:18 -0700 mailte J Ottery folgendes:
> Using windows XP and TCP/IP network.
>
> I install PostgreSQL on a client PC and put the data files on a
> networked drive (instead of the local drive). Postgres as user and
> localport. This works well.
>
> Now I install po
Tomasz Ostrowski wrote:
> On 2008-04-11 08:53, J Ottery wrote:
>
> > I install PostgreSQL on a client PC and put the data files on a
> > networked drive (instead of the local drive). Postgres as user and
> > localport. This works well.
>
> This is not the way it is meant to work, and it can eat
J Ottery wrote:
Thanks Craig for making me look like an idiot. I feel bad now.
That wasn't my intent, so I'm sorry for making you feel bad about it. I
was just trying to stress the importance of only ever having one pg
instance using a data directory. If you're used to shared-access systems
J Ottery wrote:
Thanks so much Craig. I have decided to migrate to Postgres and most
of my applications are single computer based but I need to plan for
future needs. Some research is in order for me.
All you should need to do is allow the user / administrator to configure
the connection sett
Thanks Craig for making me look like an idiot. I feel bad now.
When I posted I suspected that what you have just replied with was the
case.
I have some leaning to do on this.
Jeff
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http:/
On 4/11/08, Jan de Visser <[EMAIL PROTECTED]> wrote:
>Your commit at (2) ends the transaction, and the second select runs in
>a new one.
>jan
--
I got it. I didn't notice it is the *TRANSACTION* isolation.
Thanks a lot!
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
T
Dennis Brakhane wrote:
On Thu, Apr 10, 2008 at 4:40 PM, Pavan Deolasee
<[EMAIL PROTECTED]> wrote:
On Thu, Apr 10, 2008 at 7:18 PM, Ivano Luberti <[EMAIL PROTECTED]> wrote:
I think that's because Postgres does not have deferred constraint checks.
I believe it does. See
http://www.post
J Ottery wrote:
Using windows XP and TCP/IP network.
I install PostgreSQL on a client PC and put the data files on a
networked drive (instead of the local drive). Postgres as user and
localport. This works well.
I wouldn't personally trust this setup.
Now I install postgresSQL on another cl
On Apr 9, 5:51 am, [EMAIL PROTECTED] ("Albe Laurenz") wrote:
> Andrew Falanga wrote:
>
> > I know about the -E option to psql and did that to get the following,
> > which is what psql does for a \d :
>
> > * QUERY **
> > SELECT c.oid,
> > n.nspname,
> > c.relname
> > FROM pg_cat
You can't read the online article without an account, but the headlines might
still be of interest (or you can buy the magazine :-)
http://www.linux-mag.com/id/5679
Cheers,
Brent Wood
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscriptio
On Thu, Apr 10, 2008 at 4:40 PM, Pavan Deolasee
<[EMAIL PROTECTED]> wrote:
> On Thu, Apr 10, 2008 at 7:18 PM, Ivano Luberti <[EMAIL PROTECTED]> wrote:
>
> I think that's because Postgres does not have deferred constraint checks.
I believe it does. See
http://www.postgresql.org/docs/8.3/interactiv
On 4/10/08, Gong <[EMAIL PROTECTED]> wrote:
>
>
> In the java code below, I set the transaction isolation to serialization.
>
> public class IsolationTest {
>
> private static String select = "select * from tmp where url = 'aaa'";
>
> public static void main(String[] args) throws Exception{
On 2008-04-11 08:53, J Ottery wrote:
> I install PostgreSQL on a client PC and put the data files on a
> networked drive (instead of the local drive). Postgres as user and
> localport. This works well.
This is not the way it is meant to work, and it can eat your data.
> Now I install postgresSQ
Using windows XP and TCP/IP network.
I install PostgreSQL on a client PC and put the data files on a
networked drive (instead of the local drive). Postgres as user and
localport. This works well.
Now I install postgresSQL on another client machine and point it to
the same data directory on the n
48 matches
Mail list logo
