Dear All,
I worked again from very start and faced the same problem which encountered
earlier.
In order to perform replication. I am following the steps present in
http://people.planetpostgresql.org/dpage/index.php?/archives/51-Setting-up-Slony-I-with-pgAdmin.html
and
successfully reached to
Hi.
I'm evaluating to issue the drop_caches kernel command (echo 3 >
/proc/sys/vm/drop_caches) in order to free unused pagecache, directory
entries and inodes.
I'm thinking to schedule the command during low load moments after
forcing a sync command.
I wonder if this can cause pgsql problems of
> From: Abdul Rahman <[EMAIL PROTECTED]>
> Dear All,
>
> I worked again from very start and faced the same problem
> which encountered earlier.
> In order to perform replication. I am following the steps
> present in
>
> http://people.planetpostgresql.org/dpage/index.php?/archives/51-Setting-u
How will I get know that all slons are running? However in the replication
"pgbench" properties the value of Slon PID is Not Running in each node. Yes,
every node is listed with its path and listen. And what do you mean by "do you
see the connections on each node".
Thanks Glyn Astill.
--- On T
On Mon, Sep 29, 2008 at 2:12 PM, Simon Riggs <[EMAIL PROTECTED]> wrote:
>
> On Mon, 2008-09-29 at 13:39 +0400, Ivan Zolotukhin wrote:
>
>> This is all not about checkpoints. As I've mentioned in the first
>> message, even right after manual run of CHECKPOINT command in psql
>> pg_start_backup() tak
> From: Abdul Rahman <[EMAIL PROTECTED]>
> Subject: Re: [GENERAL] Replication using slony-I
> To: pgsql-general@postgresql.org
> Cc: [EMAIL PROTECTED]
> Date: Tuesday, 30 September, 2008, 9:51 AM
> How will I get know that all slons are running? However in
> the replication "pgbench" properties the
Dear all,
Due to personal reason (to celebrate EID) I will rejoin my work from
06-Oct-2008.
Regards,
Abdul Rehman
Craig Ringer wrote:
> Hi
> The crash occurs whether a file, system, or user DSN is being used.
> I can reproduce this on two different machines. It happens with or
> without SSL in use. It affects any Access 2007 database with a
> PostgreSQL ODBC connection in use, including a newly created blank
>
>
> So the answer is you've got something that's gone hog-wild on creating
> large objects and not deleting them; or maybe the application *is*
> deleting them but pg_largeobject isn't getting vacuumed.
>
> regards, tom lane
Hi all, thanks for the advice. I ran the script f
On Sep 29, 11:25 pm, [EMAIL PROTECTED] ("Scott Marlowe") wrote:
> > However, this is starting to become too slow (as there are about 10 of
> > these queries), and therefore I need to write an aggregate function
> > which lets me do:
>
> >>SELECT count_unique(make), count_unique(color) from table WH
On Sep 30, 2:36 am, [EMAIL PROTECTED] (Tom Lane) wrote:
> > SELECT count_unique(make), count_unique(color) from table WHERE >criteria<;
>
> I must be missing something, because I don't see why you couldn't do
> SELECT count(distinct make), count(distinct color) from table WHERE
> >criteria<;
I di
On Tue, Sep 30, 2008 at 3:33 AM, Denis Gasparin <[EMAIL PROTECTED]> wrote:
> Hi.
>
> I'm evaluating to issue the drop_caches kernel command (echo 3 >
> /proc/sys/vm/drop_caches) in order to free unused pagecache, directory
> entries and inodes.
>
> I'm thinking to schedule the command during low lo
On Mon, Sep 29, 2008 at 05:53:02PM -0400, Greg Smith wrote:
> On Mon, 29 Sep 2008, Sam Mason wrote:
> > echo 3 | sudo tee /proc/sys/vm/drop_caches
> >As an aside, it would be nicer if there was a more appropriate program
> >than tee but I've yet to find one.
>
> What are you trying to accomplish
Denis Gasparin <[EMAIL PROTECTED]> writes:
> I'm evaluating to issue the drop_caches kernel command (echo 3 >
> /proc/sys/vm/drop_caches) in order to free unused pagecache, directory
> entries and inodes.
Why in the world would you think that's a good idea?
regards, tom la
On Mon, Sep 29, 2008 at 06:41:33AM -0700, [EMAIL PROTECTED] wrote:
> On 16 sep, 23:04, [EMAIL PROTECTED] (Andrew Sullivan) wrote:
> > Specify the specific TCP/IP interfaces in the postmaster.conf file.
> I have the same pb. I have looked for a postmaster.conf file but there
Doh! Sorry, that shou
I must be missing something, because I don't see why you couldn't do
SELECT count(distinct make), count(distinct color) from table WHERE
>criteria<;
I didn't explain well, I want the count of each distinct value in a
column, eg, if the color column has 50 rows, 20x'red', 10x'green',
20x'blue'
Hi,
I would like to set an alias name for a column from a subquery, i.e.
something like this:
SELECT entry AS (SELECT name from colnames WHERE id=1) from entries ;
Obviously it doesn't work _this_ way, but is there _any_ way to do it?
Kind regards,
Felix
--
Sent via pgsql-general mailing l
Hi.
I want to use Postgres without installation. The problem is the
dependencies on the Visual C dll (msvcrt).
As far as I know it would be possible to include a manifest file (only
for libpq.dll?) and bundle the dlls from c:\windows\WinSxS into the bin
directory of Postgres.
Is this correct?
Tom Lane ha scritto:
> Denis Gasparin <[EMAIL PROTECTED]> writes:
>
>> I'm evaluating to issue the drop_caches kernel command (echo 3 >
>> /proc/sys/vm/drop_caches) in order to free unused pagecache, directory
>> entries and inodes.
>>
>
> Why in the world would you think that's a good idea
On Tue, Sep 30, 2008 at 7:51 AM, Denis Gasparin <[EMAIL PROTECTED]> wrote:
> Tom Lane ha scritto:
>> Denis Gasparin <[EMAIL PROTECTED]> writes:
>>
>>> I'm evaluating to issue the drop_caches kernel command (echo 3 >
>>> /proc/sys/vm/drop_caches) in order to free unused pagecache, directory
>>> entr
If its the OS cache the kernel ought to free the memory when there is
something else worth caching. Its not a big deal if the cache is full so
long as the system still performs well.
On Tue, Sep 30, 2008 at 9:51 AM, Denis Gasparin <[EMAIL PROTECTED]> wrote:
> Tom Lane ha scritto:
> > Denis Gaspa
There are a number of mysql to postgresql converters available, but
many of them have significant shortcomings. Has anyone found a tool
that works well? I am trying to convert a couple of relatively large,
public schema to postgresql.
Thanks,
Sean
--
Sent via pgsql-general mailing list (pgsql-
Hi Jeffrey,
Thanks for your quick response!
Hoover, Jeffrey wrote:
select (SELECT name from colnames WHERE id=1) as entry from entries;
I think, I should have been a bit clearer in what I need:
I've got two tables, colnames and entries:
test=# SELECT * from colnames;
id | name
+
On 30/09/2008 14:21, Felix Homann wrote:
> I would like to set an alias name for a column from a subquery, i.e.
> something like this:
>
> SELECT entry AS (SELECT name from colnames WHERE id=1) from entries ;
select entry from (select name from colnames where id = 1) as
entry_with_different_na
Raymond O'Donnell wrote:
select entry from (select name from colnames where id = 1) as
entry_with_different_name;
...maybe?
Thanks Ray!
No, "entry_with_different_name" should be the result of "SELECT name
FROM colnames WITH id=1".
Kind regards,
Felix
--
Sent via pgsql-general mailing li
On Tue, Sep 30, 2008 at 03:21:53PM +0200, Felix Homann wrote:
> I would like to set an alias name for a column from a subquery, i.e.
> something like this:
>
> SELECT entry AS (SELECT name from colnames WHERE id=1) from entries ;
>
> Obviously it doesn't work _this_ way, but is there _any_ way t
On Tue, Sep 30, 2008 at 8:29 AM, Felix Homann <[EMAIL PROTECTED]> wrote:
> _But_, I don't want to give the alias explicitely, instead it should be
> taken from a second table 'colnames', i.e. something like the line I sent in
> my initial mail. Any idea?
Then you'll have to build a query in plpgs
>From what i know, Aliases are literals, they are not variables, hence they
cannot be derived from something. you can derive them outside the scope of
normal SQL by using functions or shell scripts, but probably not inside an
SQL context.
rgds,
dotyet
On Tue, Sep 30, 2008 at 12:10 PM, Scott Marlo
On Tue, Sep 30, 2008 at 10:08 AM, Sean Davis <[EMAIL PROTECTED]> wrote:
> There are a number of mysql to postgresql converters available, but
> many of them have significant shortcomings. Has anyone found a tool
> that works well? I am trying to convert a couple of relatively large,
> public sche
On Mon, Sep 29, 2008 at 8:02 PM, Mike Diehl <[EMAIL PROTECTED]> wrote:
> That fixed it. If you are ever in Albuquerque, NM., let me know. I'll be
> happy to buy you a beer.
>
Tom probably has enough beers coming to him that he could found a new
software company with money from returning the bott
On Tue, Sep 30, 2008 at 10:08 AM, Sean Davis <[EMAIL PROTECTED]> wrote:
> There are a number of mysql to postgresql converters available, but
> many of them have significant shortcomings. Has anyone found a tool
> that works well? I am trying to convert a couple of relatively large,
> public sche
On Tue, Sep 30, 2008 at 12:48 PM, Sean Davis <[EMAIL PROTECTED]> wrote:
> On Tue, Sep 30, 2008 at 10:08 AM, Sean Davis <[EMAIL PROTECTED]> wrote:
>> There are a number of mysql to postgresql converters available, but
>> many of them have significant shortcomings. Has anyone found a tool
>> that wo
On Tue, Sep 30, 2008 at 1:18 PM, Merlin Moncure <[EMAIL PROTECTED]> wrote:
> On Tue, Sep 30, 2008 at 12:48 PM, Sean Davis <[EMAIL PROTECTED]> wrote:
>> On Tue, Sep 30, 2008 at 10:08 AM, Sean Davis <[EMAIL PROTECTED]> wrote:
>>> There are a number of mysql to postgresql converters available, but
>>>
On Tue, Sep 30, 2008 at 10:46 AM, Merlin Moncure <[EMAIL PROTECTED]> wrote:
> On Mon, Sep 29, 2008 at 8:02 PM, Mike Diehl <[EMAIL PROTECTED]> wrote:
>> That fixed it. If you are ever in Albuquerque, NM., let me know. I'll be
>> happy to buy you a beer.
>>
>
> Tom probably has enough beers coming
Hi Sam,
Sam Mason wrote:
I think you may be trying to solve the wrong problem, what are you
really trying to do?
Here you go. I have some tables created like this:
CREATE TABLE player(
id INTEGER PRIMARY KEY,
name varchar(20)
);
CREATE TABLE transfer(
id SERIAL PRIMARY KEY,
fromID
On Tue, Sep 30, 2008 at 11:45 AM, Felix Homann <[EMAIL PROTECTED]> wrote:
> Hi Sam,
> In other words, I would like to have a named column for every Name in the
> player table. I _can_ create such a view manually if I know each player.name
> beforehand, but I don't know how to automate it for any gi
On Tuesday 30 September 2008 10:46:46 am Merlin Moncure wrote:
> On Mon, Sep 29, 2008 at 8:02 PM, Mike Diehl <[EMAIL PROTECTED]> wrote:
> > That fixed it. If you are ever in Albuquerque, NM., let me know. I'll
> > be happy to buy you a beer.
>
> Tom probably has enough beers coming to him that he
I think you should look at crosstab contrib module.
Regards,
Taras Kopets
On 9/30/08, Felix Homann <[EMAIL PROTECTED]> wrote:
> Hi Sam,
>
> Sam Mason wrote:
>> I think you may be trying to solve the wrong problem, what are you
>> really trying to do?
>
> Here you go. I have some tables created li
Working with PG 8.1 I'm trying to update a char(4) column, and it's
taking a very long time; 15 minutes so far and no end in sight. From the
explain, it doesn't seem like it should take that long, and this column
is not indexed. Sure, there's 2.7 million records but it only takes a
few minutes
On Tuesday 30 September 2008, Bill Thoen <[EMAIL PROTECTED]> wrote:
> Working with PG 8.1 I'm trying to update a char(4) column, and it's
> taking a very long time; 15 minutes so far and no end in sight. From the
> explain, it doesn't seem like it should take that long, and this column
> is not ind
Bill Thoen <[EMAIL PROTECTED]> schrieb:
> Working with PG 8.1 I'm trying to update a char(4) column, and it's
> taking a very long time; 15 minutes so far and no end in sight. From the
> explain, it doesn't seem like it should take that long, and this column
> is not indexed. Sure, there's 2
Thanks to Scott and Taras for pointing me to the crosstab functions. I
only had a quick look but they seem very helpful!
Kind regards,
Felix
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-gene
On Tue, 2008-09-30 at 13:00 -0600, Bill Thoen wrote:
> Working with PG 8.1 I'm trying to update a char(4) column, and it's
> taking a very long time; 15 minutes so far and no end in sight. From the
> explain, it doesn't seem like it should take that long, and this column
> is not indexed. Sure,
On Tue, Sep 30, 2008 at 1:00 PM, Bill Thoen <[EMAIL PROTECTED]> wrote:
> Working with PG 8.1 I'm trying to update a char(4) column, and it's taking a
> very long time; 15 minutes so far and no end in sight. From the explain, it
> doesn't seem like it should take that long, and this column is not in
Doesn't look like that's the problem. I moved my table over to another
Linux box running PG 8.3 and update performance was pretty bad there as
well. In the time that PG 8.3 was struggling with update there I created
a copy of my table on my PG 8.1 machine and inserted all columns with
one conta
In response to Bill Thoen <[EMAIL PROTECTED]>:
> Doesn't look like that's the problem. I moved my table over to another
> Linux box running PG 8.3 and update performance was pretty bad there as
> well. In the time that PG 8.3 was struggling with update there I created
> a copy of my table on my
Bill Moran wrote:
> What I suspect is that the typical tuning advice applies here. I don't
> see any information about your configuration or your hardware setup.
> * What are shared_buffers set at?
> * What do the checkpoint configs look like?
> * In general, what does your postgresql.conf look l
Sorry for the hyperbole; I should have qualified that ridiculous
statement with "...on my machines." No doubt the problem has something
to do with configuration, because I don't know much about that. One of
my machines is running PG 8.1 on Linux Fedora Core 5. It's got an AMD
64bit CPU with a G
On Tue, Sep 30, 2008 at 2:51 PM, Bill Thoen <[EMAIL PROTECTED]> wrote:
> Doesn't look like that's the problem. I moved my table over to another Linux
> box running PG 8.3 and update performance was pretty bad there as well. In
> the time that PG 8.3 was struggling with update there I created a copy
On Tue, Sep 30, 2008 at 03:51:44PM +0200, Denis Gasparin wrote:
> It seems like postgres or the operating system (linux) is keeping in
> cache that old data even if it has been deleted.
Just remember: "free memory" is "memory you paid for and are not
using" == "wasted memory". The OS knows damn we
On Tuesday 30 September 2008, Bill Thoen <[EMAIL PROTECTED]> wrote:
> Sorry for the hyperbole; I should have qualified that ridiculous
> statement with "...on my machines." No doubt the problem has something
> to do with configuration, because I don't know much about that. One of
> my machines is r
Alvaro Herrera wrote:
Bill Moran wrote:
What I suspect is that the typical tuning advice applies here. I don't
see any information about your configuration or your hardware setup.
* What are shared_buffers set at?
* What do the checkpoint configs look like?
* In general, what does your post
On Tue, 2008-09-30 at 16:34 -0600, Bill Thoen wrote:
> > Also, how many indexes does this table have?
> >
> >
> Two, but the column I'm updating isn't included in either one of them.
>
Even if the column is not indexed, when a new row is created (which is
the case with UPDATE) a new index entr
On Tue, Sep 30, 2008 at 4:37 PM, Jeff Davis <[EMAIL PROTECTED]> wrote:
> On Tue, 2008-09-30 at 16:34 -0600, Bill Thoen wrote:
>> > Also, how many indexes does this table have?
>> >
>> >
>> Two, but the column I'm updating isn't included in either one of them.
>>
>
> Even if the column is not indexe
On Tue, Sep 30, 2008 at 4:02 PM, Martijn van Oosterhout
<[EMAIL PROTECTED]> wrote:
> On Tue, Sep 30, 2008 at 03:51:44PM +0200, Denis Gasparin wrote:
>> It seems like postgres or the operating system (linux) is keeping in
>> cache that old data even if it has been deleted.
>
> Just remember: "free m
Sean Davis wrote:
There are a number of mysql to postgresql converters available, but
many of them have significant shortcomings. Has anyone found a tool
that works well? I am trying to convert a couple of relatively large,
public schema to postgresql.
I couldn't find anything either but ende
Hello,
If you want to get the value of a autogenerated column it's better to use
"RETURNING"
insert into something returning primary key...
Best Regards,
Rafael Domiciano
Postgres DBA
2008/9/15 Scott Marlowe <[EMAIL PROTECTED]>
> On Mon, Sep 15, 2008 at 11:53 AM, c k <[EMAIL PROTECTED]>
> wrot
I'm curious about pgbash. I've taken a look at the website here:
http://www.psn.co.jp/PostgreSQL/pgbash/index-e.html
According to the history on the main home page, the pgbash package was
last updated in 2003, ie:
2003.02.11 : pgbash-7.3 released (for PostgreSQL-7.3 and bash-2.05a).
I've made a
Hi:
I have v8.2.5 running on my server and serving my DB to my customers. I
also have v8.3.4. I created a v8.3.4 instance (initdb) but haven't
started anything yet (no pg_ctl start yet). I want to test v8.3.4 on
the server while keeping v8.2.5 running and serving my customers at the
same tim
On Tue, Sep 30, 2008 at 8:21 PM, Gauthier, Dave <[EMAIL PROTECTED]> wrote:
> Hi:
>
> I have v8.2.5 running on my server and serving my DB to my customers. I
> also have v8.3.4. I created a v8.3.4 instance (initdb) but haven't started
> anything yet (no pg_ctl start yet). I want to test v8.3.4 on
--- On Tue, 9/30/08, r_musta <[EMAIL PROTECTED]> wrote:
> From: r_musta <[EMAIL PROTECTED]>
> Subject: Re: [GENERAL] Counting unique rows as an aggregate.
> To: pgsql-general@postgresql.org
> Date: Tuesday, September 30, 2008, 6:55 AM
> On Sep 30, 2:36 am, [EMAIL PROTECTED] (Tom Lane) wrote:
>
Jörn Heid wrote:
Hi.
I want to use Postgres without installation. The problem is the
dependencies on the Visual C dll (msvcrt).
As far as I know it would be possible to include a manifest file (only
for libpq.dll?) and bundle the dlls from c:\windows\WinSxS into the bin
directory of Postgres.
"Scott Marlowe" <[EMAIL PROTECTED]> writes:
> It's actually a pretty common practice to install two versions for
> migration purposes.
Also, all the core developers routinely run multiple versions for the
purpose of testing back-branch bug fixes. The machine I'm typing this
on has, hm [ ... ps |
Jörn Heid wrote:
Hi.
I want to use Postgres without installation. The problem is the
dependencies on the Visual C dll (msvcrt).
As far as I know it would be possible to include a manifest file (only
for libpq.dll?) and bundle the dlls from c:\windows\WinSxS into the
bin directory of Postgres.
Thanks Ashesh for your answer.
I will try to do so although I first have to install VC (or can I just
use the directories from WinSxS?). Is there another possibility without
setting an environment variable? Think of the simplest distribution of
just copying files (e.g. to a USB stick) and "pg_
Hi ,
Can somebody tell me the solution for this.i tried compiling postgres
as follows in vs2005 .its giving the following errors
E:\postgresql-8.3.1\src\interfaces\libpq>nmake /f win32.mak
Microsoft (R) Program Maintenance Utility Version 8.00.50727.42
Copyright (C) Microsoft Corporation
On Tue, 2008-09-30 at 12:58 +0400, Ivan Zolotukhin wrote:
> Just a few points on pg_start_backup() from user point of view. I
> personally would prefer to have some control over the process, e.g. it
> would be nice to have proposed pg_start_backup(label text,
> immediate_chkpt boolean).
I've ad
Hi
I am currently upgrading from 8.1 to 8.3 and am getting errors when
restoring the dump from 8.1 into 8.3. Like below:
ERROR: could not find function "gtsvector_in" in file
"/usr/lib/postgresql/8.3/lib/tsearch2.so"
ERROR: function public.gtsvector_in(cstring) does not exist
ERROR: could not
68 matches
Mail list logo
