> Hi,
>
> Price and features. There are some changes in V12 which is causing us to
> do some steps with our support and resellers. We've always wanted to move
> away from Sybase so we can make more of a profit off our software and lower
> costs for us and our clients. Sybase is a wonderful p
Dear all,
for the sake academic teaching, a colleague asked me in how far
PostgreSQL does support object functionality these days.
I am afraid my web research was not very fruitful to him; the impression
is that hardly anybody is occupied in working on PostgreSQL object
functionality -- have
A fairly frequent operation I do is copying a database between servers,
for which I use pg_dump. Since the database contains some extensions -
most notably hstore and tsearch2, which need superuser privileges to
install, I have a sort of a chicken-and-egg problem: the owner of the
database (and
* tuanhoanganh wrote:
I download postgresql from Enterprise DB
On Thu, Jan 20, 2011 at 6:06 AM, Christian Ullrich mailto:ch...@chrullrich.net>> wrote:
We cannot assume that the one-click installer was used, but if it
was, the service account it creates will be a member of the Users
PostgreSQL 9.0.1, compiled by Visual C++ build 1500, 64-bit
is installed in Windows 2008 server and servers 23 users in LAN 10 hours per
work day.
Approx once per week server stops responding: Users are waiting 4 minutes
for query to complete but nothing happens.
If postgres service is re-st
In response to Ivan Voras :
> A fairly frequent operation I do is copying a database between servers,
> for which I use pg_dump. Since the database contains some extensions -
> most notably hstore and tsearch2, which need superuser privileges to
> install, I have a sort of a chicken-and-egg pro
On Thu, Jan 20, 2011 at 6:14 PM, Tom Lane wrote:
> So I'm not sure whether to fix it, or leave it as a known failure case
> in old branches. Comments?
Since there is a workaround, I think it is best to document it and
leave it as-is.
--
Sent via pgsql-general mailing list (pgsql-general@postgr
Hello everybody out there familiar with the tablefunc module,
Having read the documentation of the tablefunc module,
I'm wondering whether it is possible to get the values for the names of
the columns for the crosstab query from a subquery.
A minimal example would look like this:
CREATE TABLE
On Fri, Jan 21, 2011 at 3:16 AM, Uwe Schroeder wrote:
> Have to say: here you get a premium product at cost of zip, nada, nothing and
> when you shout out to the mailing list - and you provide useable information -
> chances are you'll get premium support from people like Tom Lane. No company I
>
* tuanhoanganh wrote:
Here is procmon i thinks error
[some procmon events]
No, that is all OK. The event at 2:39:55.7588651 is where Postgres
starts cmd.exe to perform the copy. The really interesting data would be
from cmd.exe itself, which implements the copy command.
Please send the eve
On 21/01/2011 14:39, Bill Moran wrote:
In response to Ivan Voras:
A fairly frequent operation I do is copying a database between servers,
for which I use pg_dump. Since the database contains some extensions -
most notably hstore and tsearch2, which need superuser privileges to
install, I have a
In response to Ivan Voras :
> On 21/01/2011 14:39, Bill Moran wrote:
> > In response to Ivan Voras:
> >
> >> A fairly frequent operation I do is copying a database between servers,
> >> for which I use pg_dump. Since the database contains some extensions -
> >> most notably hstore and tsearch2, wh
On 21/01/2011 15:55, Bill Moran wrote:
On the "no" side, doing this kind of thing is always complex. We have a
slew of other, very specialized scripts that do things like convert a
production database to a development database by sanitizing sensitive
data, or automatically deploy new database o
On 01/21/2011 05:48 AM, Julia Jacobson wrote:
> Having read the documentation of the tablefunc module,
> I'm wondering whether it is possible to get the values for the names of
> the columns for the crosstab query from a subquery.
> A minimal example would look like this:
>
> CREATE TABLE mytable(
On 1/21/2011 2:16 AM, Nick Rudnick wrote:
Dear all,
for the sake academic teaching, a colleague asked me in how far
PostgreSQL does support object functionality these days.
I am afraid my web research was not very fruitful to him; the impression
is that hardly anybody is occupied in working on
On 1/21/2011 7:16 AM, Andrus wrote:
PostgreSQL 9.0.1, compiled by Visual C++ build 1500, 64-bit
is installed in Windows 2008 server and servers 23 users in LAN 10 hours
per work day.
Approx once per week server stops responding: Users are waiting 4
minutes for query to complete but nothing happe
On 1/20/2011 11:56 PM, Adarsh Sharma wrote:
Dear all,
I want to know ACl of different users on different tables and databases
in Postgresql.
Is there any command as we do in mysql as :
select * from mysql.user\G;
I am researching but cannot able to find.
Thanks & Regards
Adarsh Sharma
u
On Friday 21 January 2011 7:13:23 am Andy Colson wrote:
> On 1/21/2011 7:16 AM, Andrus wrote:
> > PostgreSQL 9.0.1, compiled by Visual C++ build 1500, 64-bit
> > is installed in Windows 2008 server and servers 23 users in LAN 10 hours
> > per work day.
> >
> > Approx once per week server stops resp
On 1/21/2011 9:21 AM, Adrian Klaver wrote:
On Friday 21 January 2011 7:13:23 am Andy Colson wrote:
On 1/21/2011 7:16 AM, Andrus wrote:
PostgreSQL 9.0.1, compiled by Visual C++ build 1500, 64-bit
is installed in Windows 2008 server and servers 23 users in LAN 10 hours
per work day.
Approx once
In response to "Andrus" :
> PostgreSQL 9.0.1, compiled by Visual C++ build 1500, 64-bit
> is installed in Windows 2008 server and servers 23 users in LAN 10 hours per
> work day.
>
> Approx once per week server stops responding: Users are waiting 4 minutes
> for query to complete but nothing ha
Andy,
Does PG start swapping to disk?
Earlier I used Stack builder to optimize Postgres as dedicated server. MS
SQL server was installed afterwards.
In this case message
"System is out of virtual memory". Windows is increasing the swap file size.
During this memory requests from applicatio
On 1/21/2011 9:43 AM, Andrus wrote:
Andy,
Does PG start swapping to disk?
Earlier I used Stack builder to optimize Postgres as dedicated server.
MS SQL server was installed afterwards.
In this case message
"System is out of virtual memory". Windows is increasing the swap file
size. During thi
On 2011-01-21 16.16, Andy Colson wrote:
On 1/20/2011 11:56 PM, Adarsh Sharma wrote:
Dear all,
I want to know ACl of different users on different tables and databases
in Postgresql.
Is there any command as we do in mysql as :
select * from mysql.user\G;
I am researching but cannot able to fi
Hello,
I can't figure this out, and need help.
I need access (VIA SQL Statements) to retreive a list of all PUBLIC tables,
columns and their descriptions.
I found:
tables
columns
pg_description
1. There is no link between the description (object ID and the
tables/columns)
2. pg_description
Hello,
I have postgresql 8.3.9 database. Now I am working on reading file
from bytea data and save to filesystem.
I am using Npgsql.dll on c#.net.
First I have using OpenERP to upload a file to postgres database in
bytea column. The original file size is 104,960 bytes and .doc
extension.
Then I re
To add to this.
Is there a backup being done? Maybe not pg_dump but some Windows backup
program?
Yes yes... or antivirus full scan kicking off?
There is no antivirus installed.
Windows scheduler contains only one task which runs pg_dump at 2:00 every
morning.
Dump takes few minutes to run
Thanks for your answer. The fact that the column definition list must be
available to the parser was not obvious to me.
Instead of building the second query dynamically in an application, I
would prefer a user-defined function, because there will probably be
several applications in need of it an
I have changed archive_command to
archive_command = 'copy %p D:\\3SDATABACKUP\\PITR\\WAL\\%f'
and it work again.
But why old archive_command work from 01/01 to 05/01
archive_command = 'copy %p D:/3SDATABACKUP/PITR/WAL/%f'
Thank for your help
Tuan Hoang ANh
On Fri, Jan 21, 2011 at 8:58 PM, Christi
Tom Lane wrote:
>
> So I'm not sure whether to fix it, or leave it as a known failure case
> in old branches. Comments?
I understand the reluctance to fool with stable code. I have zero insight
into your installed versions distribution and backward compatibility needs
so any comment I may have
On Fri, Jan 21, 2011 at 12:44 PM, Bosco Rama wrote:
> Tom Lane wrote:
>>
>> So I'm not sure whether to fix it, or leave it as a known failure case
>> in old branches. Comments?
>
> I understand the reluctance to fool with stable code. I have zero insight
> into your installed versions distributi
Hello,
I have the typical problem of overlapping periods exclusion and I'm
trying to give constraint exclusion a go as we have recently switched
to a PG 9.0 server.
All the examples I've found check a record against the whole table.
But in practice I will have a table of resources (hotel rooms,
w
On Fri, Jan 21, 2011 at 6:36 PM, Daniele Varrazzo
wrote:
> All the examples I've found check a record against the whole table.
> But in practice I will have a table of resources (hotel rooms,
> whatever) and independent periods for each resource.
Clarification: I have read the depesz article
(ht
After a year I have restarted work on a project using Postgresql. The database I created was in Postgresql 8.2.5. I updated my database server from Ubuntu 7.10 to 10.4 (lucid) and installed Postgresql 9.0.2 The Postgresql install went fine and the restore from my previous pg_dumpall went fine but
On 01/21/11 11:07 AM, margaretgil...@chromalloy.com wrote:
After a year I have restarted work on a project using Postgresql. The
database I created was in Postgresql 8.2.5. I updated my database
server from Ubuntu 7.10 to 10.4 (lucid) and installed Postgresql
9.0.2 The Postgresql install went
Robert Haas writes:
> On Fri, Jan 21, 2011 at 12:44 PM, Bosco Rama wrote:
>> Tom Lane wrote:
>>> So I'm not sure whether to fix it, or leave it as a known failure case
>>> in old branches. Comments?
>> As an end user there is one area of the DB that I want to work correctly
>> 100% of the time
On Fri, 2011-01-21 at 18:36 +, Daniele Varrazzo wrote:
> => alter table commission_rate add constraint check_overlapping
> exclude using gist (payer_id with =, box( point(extract(epoch from
> start_date), extract(epoch from start_date)),
> point(coalesce(extract(epoch from end_date), 'infinity'
>> FATAL: Ident authentication failed for user "engineering">>that says it right there. your LOCAL authentication type is set to >IDENT in your pg_hba.conf file.>That was it. I have updated my install documentation. Thank you, Margaret "This e-mail message and any attachment(s) are for the sole u
On 01/21/2011 10:45 PM, Robert Paresi wrote:
Hello,
I can't figure this out, and need help.
I need access (VIA SQL Statements) to retreive a list of all PUBLIC
tables, columns and their descriptions.
Look at the INFORMATION_SCHEMA schema.
--
Craig Ringer
--
Sent via pgsql-general mailing li
On Fri, Jan 21, 2011 at 9:11 PM, Jeff Davis wrote:
> On Fri, 2011-01-21 at 18:36 +, Daniele Varrazzo wrote:
>> => alter table commission_rate add constraint check_overlapping
>> exclude using gist (payer_id with =, box( point(extract(epoch from
>> start_date), extract(epoch from start_date)),
On Fri, 2011-01-21 at 09:10 -0600, Andy Colson wrote:
> On 1/21/2011 2:16 AM, Nick Rudnick wrote:
> > Dear all,
> >
> > for the sake academic teaching, a colleague asked me in how far
> > PostgreSQL does support object functionality these days.
Although postgres at one time had "ORDBMS" as a goal,
> 2. Inheritance
>
> This feature is now used almost exclusively for physical partitioning
> rather than logical design.
GNUmed uses it for logical design (albeit not OO) a lot.
Karsten
--
NEU: FreePhone - kostenlos mobil telefonieren und surfen!
Jetzt informieren: http
Firstof all sorry for posting linux kernel question in pgsql-general, but i
am trying to figure out what value to set for postgresql db server.
RAM = 16GB, what value should i set for shmall?
If i set shmall to 4294967296 (4GB), current PAGE_SIZE is 4096 should i need
to set my shmmax = 429496729
On 01/21/2011 06:34 PM, Jeff Davis wrote:
On Fri, 2011-01-21 at 09:10 -0600, Andy Colson wrote:
You do realize that ORM sucks, right?
Andy, please try to keep the criticism constructive.
Sorry Nick. Didn't mean to be hostile. Thanks Jeff.
-Andy
--
Sent via pgsql-general mailing list (pgs
Hi Andy,
to a considerable extent I agree with you -- but the motivation exactly
is not typical business apps, but *academic teaching* needing a
demonstration platform for *non-standard* apps -- these guys are a DB
chair, and I was optimistic there might be some projects here which
might allo
Hi Jeff,
this is worse news than I expected -- I had that that at least somebody
would be playing around with this...
Of course there is a price to pay for OO functionality -- but is there
evidence that, given I tweak the frontend into such a direction,
PostreSQL due to its backend architec
On Fri, Jan 21, 2011 at 6:34 PM, DM wrote:
> Firstof all sorry for posting linux kernel question in pgsql-general, but i
> am trying to figure out what value to set for postgresql db server.
>
> RAM = 16GB, what value should i set for shmall?
>
> If i set shmall to 4294967296 (4GB),
shmall is mea
* tuanhoanganh wrote:
I have changed archive_command to
archive_command = 'copy %p D:\\3SDATABACKUP\\PITR\\WAL\\%f'
and it work again.
Argh. How could I not have seen that?
But why old archive_command work from 01/01 to 05/01
archive_command = 'copy %p D:/3SDATABACKUP/PITR/WAL/%f'
It works
47 matches
Mail list logo
