Hi,
When logged in as administrator, i start the postgres server with
the following command:
runas /user:postgres D:\postgres_new\pgsql\bin\pg_ctl.exe start -D
D:\postgres_new\pgsql\data
The problem is runas cmd is not script friendly as i can not
pass the password as a cmd
Will,
William Temperley wrote:
Hi All
I'm wondering if anyone can share any insights or experience with
temporary versions of databases, allowing disconnected editing
during Internet downtime.
What do your users use for updating data? Software that you developed
for them? Do they use a
CM J wrote:
Hi,
When logged in as administrator, i start the postgres server
with the following command:
runas /user:postgres D:\postgres_new\pgsql\bin\pg_ctl.exe start -D
D:\postgres_new\pgsql\data
The problem is runas cmd is not script friendly as i can
not pass the
Well, if you don't delete the recovery.conf and you *do* delete
pg_standby's stop file (or it gets deleted, for example if you set it
to go under /tmp and the server is restarted for whatever reason) the
server will attempt to go back into recovery mode using your
configured recovery
Hi,
On Wed, Apr 15, 2009 at 9:23 AM, Dan Hayes dhayes...@gmail.com wrote:
Excellent! Thanks. One other quick question... What would happen if I
didn't delete the recovery.conf file? Is that step just to prevent
accidentally restarting the server with it there?
recovery.conf is
Hello all,
I have a table with 2 bigint columns, let's call them A and B. I need
a query that will allow me to return A alongside the sum of Bs from
rows where A is less than or equal to this row's A. It is best
described with some example data, consider the following:
A B
1 0
2 1
3 0
4 2
5 1
I
I was trying to clean up my database and after 2 days of vacuum full on
a 20GB table, I gave up and used pg_reorg which is seriously fast.
However, now I'm not sure if it is the cause of my unstable DB (8.2.13)
I can connect, initiate a simple query and the DB will do down
logs says :
The
On Wed, Apr 15, 2009 at 11:09:49AM +0100, Shug Boabby wrote:
Anyone have any ideas how to do this? I'm able to do it
programmatically, but it's slow. Optimally I'd like to be able to do
this in the DB. As you can see, it's a little trickier that the usual
aggregate function with a GROUP BY and
In response to Shug Boabby :
Hello all,
I have a table with 2 bigint columns, let's call them A and B. I need
a query that will allow me to return A alongside the sum of Bs from
rows where A is less than or equal to this row's A. It is best
described with some example data, consider the
Le Wednesday 15 April 2009, Greg Smith a écrit :
On Tue, 14 Apr 2009, William Temperley wrote:
I could potentially run a database in each of these countries and
provide 100% uptime, obviously raising the issue of version conflicts
that would require hand-merging.
Can you partition data on
Hey guys,
I need some information on
1. What are the best features of Npgsql product as compare to other
commercial .net data providers?
2. If you have encountered any major problems, bugs or performance issue
etc... With this product?
Thanks in advance,
Peeyush Jain| Software Engineer
Hi list,
we have just migrated one of our databases from 8.2.12 to 8.3.7. We now
experience a strange problem: A query that was really fast on the 8.2
server is now much slower on the 8.3 server (1 ms vs. 60 sec). I had a
look at the query plan and it is completely different. Both servers run
hi, all
The PostgreSQL has a option: backslash_quote.
It can be on, off or safe_encoding.
How to set it to ingore back-slash check?
The command: INSERT INTO table_name VALUES(..., '\\', ...);
always get a warning message whatever it is.
If use E'\\', value will be saved as '\' in database.
Has
set work_mem=24000; before running the query.
postgres is doing merge and sort on disc, that's always slow.
is there an index on column isin ?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Grzegorz Jaśkiewicz wrote:
set work_mem=24000; before running the query.
postgres is doing merge and sort on disc, that's always slow.
Ok, but why is the plan different in 8.2? As you can see the same query
is really fast in 8.2, but slow in 8.3.
is there an index on column isin ?
There
2009/4/15 Christian Schröder c...@deriva.de:
Grzegorz Jaśkiewicz wrote:
set work_mem=24000; before running the query.
postgres is doing merge and sort on disc, that's always slow.
Ok, but why is the plan different in 8.2? As you can see the same query is
really fast in 8.2, but slow in
On Wed, 2009-04-15 at 14:04 +0200, Christian Schröder wrote:
Grzegorz Jaśkiewicz wrote:
set work_mem=24000; before running the query.
postgres is doing merge and sort on disc, that's always slow.
Ok, but why is the plan different in 8.2? As you can see the same query
is really fast
On Wed, Apr 15, 2009 at 1:25 PM, Simon Riggs si...@2ndquadrant.com wrote:
The cost of the query seems accurate, so the absence of
attachment_isins_attachment_idx on the 8.3 plan looks to be the reason.
There's no way it would choose to scan 8115133 rows on the pkey if the
other index was
On Wed, Apr 15, 2009 at 9:34 AM, Dimitri Fontaine
dfonta...@hi-media.com wrote:
On Tue, 14 Apr 2009, William Temperley wrote:
I could potentially run a database in each of these countries and
provide 100% uptime, obviously raising the issue of version conflicts
that would require
Hi all,
I installed postgresql and when I typed ./createdb mydb, it gave error message:
*
createdb: could not connect to database postgres: could not connect to server:
No
On Wednesday 15 April 2009 5:30:29 am SongDongyan wrote:
Hi all,
I installed postgresql and when I typed ./createdb mydb, it gave error
message:
***
** createdb: could not
Fujii Masao wrote:
Hi,
On Wed, Apr 15, 2009 at 9:23 AM, Dan Hayes dhayes...@gmail.com wrote:
Excellent! Thanks. One other quick question... What would happen if I
didn't delete the recovery.conf file? Is that step just to prevent
accidentally restarting the server with it there?
Steve Crawford wrote:
Ivan Sergio Borgonovo wrote:
I still have to investigate if the tables are getting really
larger... but at a first guess there shouldn't be any good reason to
see tables getting so large so fast... so I was wondering if
anything could contribute to make a backup much
I simplified my problem a little too much and now I'm stuck trying to
use cumulative_sum(). My schema is not only A, B but also has a C
A B C
1 0 1
2 1 1
3 0 1
4 2 1
5 1 1
1 0 2
2 1 2
3 0 2
4 2 2
5 1 2
and I want to be able to do the cumulative sum only when C is the same. E.g.
A funkySumB C
1
Adrian Klaver akla...@comcast.net writes:
On Wednesday 15 April 2009 5:30:29 am SongDongyan wrote:
FATAL: could not open lock file /tmp/.s.PGSQL.5432.lock: Permission
denied
First are you trying to connect to a local server or a remote server?
Second what is listen_addresses in
Quan Zongliang quanzongli...@gmail.com writes:
Has a approach to let PostgreSQL conside back-slash as common char?
I think you're looking for the standard_conforming_strings parameter.
regards, tom lane
--
Sent via pgsql-general mailing list
Peeyush wrote:
I need some information on
1. What are the best features of Npgsql product as compare to
other commercial .net data providers?
2. If you have encountered any major problems, bugs or
performance issue etc... With this product?
You sent this to way too many lists, and you
Hi All
Its been some time since I did any work using triggers/pgsql and when I did,
it was pretty much basic stuff. Ive now returned to developing apps using
postgres and have run into an error when using a trigger that I wrote a few
years back (which worked fine then) but doesnt seem to work
Hi,
i run the greatest database ever, postgresql-8.3, on debian etch
I am investigating some error messages in my log file:
Apr 15 08:04:34 postgres[20686]: [4-1] 2009-04-15 08:04:34 CEST ERROR:
invalid byte sequence for encoding UTF8: 0x81
Apr 15 08:04:34 postgres[20686]: [4-2] 2009-04-15
=?ISO-8859-1?Q?Christian_Schr=F6der?= c...@deriva.de writes:
This is the query:
select isin from ts_frontend.attachment_isins full OUTER JOIN
ts_frontend.rec_isins using (attachment,isin) WHERE attachment=2698120
GROUP BY isin limit 1000;
Hmm. It seems 8.3 is failing to push the
Janning Vygen vy...@kicktipp.de writes:
I am investigating some error messages in my log file:
Apr 15 08:04:34 postgres[20686]: [4-1] 2009-04-15 08:04:34 CEST ERROR:
invalid byte sequence for encoding UTF8: 0x81
Apr 15 08:04:34 postgres[20686]: [4-2] 2009-04-15 08:04:34 CEST HINT: This
- sub_woofer tqzeli...@yahoo.co.uk wrote:
Hi All
Its been some time since I did any work using triggers/pgsql and when
I did,
it was pretty much basic stuff. Ive now returned to developing apps
using
postgres and have run into an error when using a trigger that I wrote
a few
Chander Ganesan wrote:
Steve Crawford wrote:
Ivan Sergio Borgonovo wrote:
I still have to investigate if the tables are getting really
larger...
Can we assume that by backup you mean pg_dump/pg_dumpall? If so, then
the change is likely due to increasing data in the database. I have a
daily
On Wed, 2009-04-15 at 17:15 +0200, Albe Laurenz wrote:
As to your questions:
Question 1 is wrong, because Npgsql is no commercial .NET data provider.
That's the main advantage: it is open source.
This is actually a misconception. Open Source doesn't disqualify it as
commercial. It
Hi,
Thank you for this great and ultra-fast support! One more question:
On Wednesday 15 April 2009 17:38:51 you wrote:
Janning Vygen vy...@kicktipp.de writes:
I am investigating some error messages in my log file:
Apr 15 08:04:34 postgres[20686]: [4-1] 2009-04-15 08:04:34 CEST ERROR:
Janning Vygen vy...@kicktipp.de writes:
Now i see that the errors occur _exactly_ every 4000 seconds (1 hour, 6
minutes and 40 seconds). I have no clue as i only have one cronjob at night
concerning postgresql. I have no autovacuum running (only manual at night).
my
application cronjobs
Hi All,
Is there any standards for installing postgres in a certain directory? or
What is the standard installation path to install postgres.
If I have to run two different versions of postgres on the same machine, how
should I install postgres? What is the standards for this?
By using RPM it
On Wed, Apr 15, 2009 at 11:29 AM, DM dm.a...@gmail.com wrote:
Hi All,
Is there any standards for installing postgres in a certain directory? or
What is the standard installation path to install postgres.
If I have to run two different versions of postgres on the same machine, how
should I
On Wed, Apr 15, 2009 at 07:57, Peeyush peeyush_j...@persistent.co.in wrote:
Hey guys,
Hi, Peeyush!
I need some information on
1. What are the best features of Npgsql product as compare to other
commercial .net data providers?
Well, the first one is that it is opensource. :)
We are
I have PostgreSQL Plus setup on windows 2008 running on a vmware virtual
machine on my Vista box.
How can I connect to it from PgAdmin from my Vista box?
http://www.nabble.com/file/p23064663/err-postgres-pgadmin1.png
err-postgres-pgadmin1.png
On 15/04/2009 19:44, mrLami wrote:
http://www.nabble.com/file/p23064663/err-postgres-pgadmin1.png
err-postgres-pgadmin1.png
http://www.nabble.com/file/p23064663/err-postgres-pgadmin2.png
err-postgres-pgadmin2.png
The second image says there's a problem with your pg_hba.conf. What does
it
On Apr 15, 3:15 pm, ray ray.jos...@cdicorp.com wrote:
I have just installed pgsql on a Windows XP from my administrator
snip
1) The encoding is win1252, I wanted to make it unicode but I missed
where to make that happen. Can I change it for those things already
built and for things in the
I have just installed pgsql on a Windows XP from my administrator
account 'rj'. I had created a power user account postgres but I did
not see where to invoke this. It seems to be running under this admin
account but maybe that is because this is a corporate machine and the
admin account isn't
On Apr 15, 2009, at 12:42 AM, Fujii Masao wrote:
Hi,
On Wed, Apr 15, 2009 at 9:23 AM, Dan Hayes dhayes...@gmail.com
wrote:
Excellent! Thanks. One other quick question... What would happen
if I
didn't delete the recovery.conf file? Is that step just to prevent
accidentally restarting
On Apr 15, 4:17 pm, ray ray.jos...@cdicorp.com wrote:
On Apr 15, 3:15 pm, ray ray.jos...@cdicorp.com wrote:
I have just installed pgsql on a Windows XP from my administrator
snip
I closed down everything and tried to start back up and failed. From
pgAdmin, there is a red 'x' in the icon for
I think you're looking for the standard_conforming_strings parameter.
Yes, it is.
Thanks
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Find server log message below
http://www.nabble.com/file/p23069775/pglog.txt pglog.txt
- mrLami...
Raymond O'Donnell wrote:
On 15/04/2009 19:44, mrLami wrote:
http://www.nabble.com/file/p23064663/err-postgres-pgadmin1.png
err-postgres-pgadmin1.png
Tried this out, and got a very familiar error that I don't know what
to do with : Error: expected just one rule action.
I'm using 8.3.5, and see this error quite a bit. Anyone know what's
behind this error?
Thanks,
Eric
On Apr 8, 2009, at 8:54 PM, John R Pierce wrote:
Eric Smith
Eric Smith eric_h_sm...@mac.com writes:
Tried this out, and got a very familiar error that I don't know what
to do with : Error: expected just one rule action.
Er, tried *what* out? That's supposed to be a can't-happen case,
so I'd like to see just what you did to trigger it.
Thanks a lot for kind information.
Currently I am investigating on Npgsql and dotConnect .. because we have
feature list of dotConnect I attached the same for your quick reference but
we don't have in Npgsql. If you can help me in this then it will be greatful
for me.
Thanks regards,
50 matches
Mail list logo