Hi,
I would like some pointers as to how to install the dbsamples so that I can
use them in Postgres. These .tar.qz files seem to contain *.sql files.
These seem to be text files but I do not understand how to import to
postgres or if there is some command line command to run.
These samples are
Martin,
Have you tried using the RETURNING function in your SQL insert statement
to immediately return the auto-generated key value? For example, how about
something like this:
String insert = INSERT INTO \schema_name\.\XX\ (\BB\, \CC\,
\DD\, \EE\) VALUES (?, ?, ?, ?) RETURNING \AA\
am Mon, dem 29.09.2008, um 22:52:52 +0100 mailte Tommy Gibbons folgendes:
Hi,
I would like some pointers as to how to install the dbsamples so that I can
use
them in Postgres. These .tar.qz files seem to contain *.sql files. These
seem
to be text files but I do not understand how to
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
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
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 Tue,
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() takes same
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 value of
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 for
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 WHERE
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 didn't
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 load
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 here
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 lane
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 should
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
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
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
entries and inodes.
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 Gasparin
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
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_name;
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 list
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 to do
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 plpgsql
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
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 schema to
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 bottles
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 schema to
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 works well?
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
many of them
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 to him that
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 given
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 could
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 like this:
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 indexed.
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.7
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:
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
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
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 PG
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 like,
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 GB
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 of
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 well it's
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 running
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
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 entry must
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 indexed, when a new row
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 memory is
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
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]
wrote:
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
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 the
--- 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:
SELECT
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
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 | grep
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
67 matches
Mail list logo