On Fri, Jan 21, 2011 at 12:28:14PM +0530, Shobhit Jain wrote:
> I have a machine on which MS SQL Server 2005 is already installed. Now I
> want to install PostgreSQL 8.3 along with MS SQL Server.
>
>
>
> Can this combination cause any problems to any of the database servers?
Well, you might
> I have a machine on which MS SQL Server 2005 is already installed. Now I
> want to install PostgreSQL 8.3 along with MS SQL Server.
>
>
>
> Can this combination cause any problems to any of the database servers?
You should not run into any problems, both servers run on different
ports (by defa
Dear Concern,
I have a machine on which MS SQL Server 2005 is already installed. Now I
want to install PostgreSQL 8.3 along with MS SQL Server.
Can this combination cause any problems to any of the database servers?
Regards,
Shobhit Jain
Disclaimer :- This e-mail and any attachment
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
--
Sent via pgsql-general mailing list (pgsql-
On 01/21/2011 05:10 AM, Robert Paresi wrote:
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
I download postgresql from Enterprise DB
On Thu, Jan 20, 2011 at 6:06 AM, Christian Ullrich wrote:
> * Magnus Hagander wrote:
>
> On Wed, Jan 19, 2011 at 19:20, Christian Ullrich
>> wrote:
>>
>
> So when PostgreSQL runs "copy 000...5E D:\...", it fails, and when you do
>>> the same thing as th
NO, D is local driver.
I setup PITR from 01/01/2011. It work well from 01->05/01/2011
(D:/3SDATABACKUP/PITR/WAL has 00010004005D) but error from
06/01/2011
On Thu, Jan 20, 2011 at 3:56 AM, John R Pierce wrote:
> On 01/19/11 9:23 AM, tuanhoanganh wrote:
>
>>
>>
>>2011-01-06 08
Joshua Tolley wrote:
-- Start of PGP signed section.
> On Sat, Nov 27, 2010 at 04:38:27PM +0530, c k wrote:
> > How can we implement procedure cache? Cane you please give details regarding
> > this?
> > It will be helpful for me.
>
> This is something the PL implementation needs to do for you. I f
Bosco Rama writes:
>>> If 'standard_conforming_strings = on' is set in our DB (which is required
>>> for
>>> our app) then the piped restore method (e.g. pg_restore -O backup.dat |
>>> psql)
>>> results in the large objects being corrupted.
> All servers and client tools involved are PG 8.4.6 o
Hi Tom,
Tom Lane wrote:
> Bosco Rama writes:
>> We've discovered (or possibly rediscovered?) a corruption when restoring
>> large
>> objects.
>
>> If 'standard_conforming_strings = on' is set in our DB (which is required for
>> our app) then the piped restore method (e.g. pg_restore -O backup.d
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 product, an
Bosco Rama writes:
> We've discovered (or possibly rediscovered?) a corruption when restoring large
> objects.
> If 'standard_conforming_strings = on' is set in our DB (which is required for
> our app) then the piped restore method (e.g. pg_restore -O backup.dat | psql)
> results in the large obj
Hi folks,
We've discovered (or possibly rediscovered?) a corruption when restoring large
objects.
If 'standard_conforming_strings = on' is set in our DB (which is required for
our app) then the piped restore method (e.g. pg_restore -O backup.dat | psql)
results in the large objects being corrupte
Once again, youreka, or EUREKA Tom!
There was no indication that the problem was inside the loop, just the
query wouldn't work.
In fact it ran perfectly fine yesterday!...? (Though I am going to go
back and check it now.)
Thanks. I know better but... You can bet I won't make that one again
Ralph Smith writes:
> Within the function I have:
> for darec in select * from purchbt where addr not like ''%STE%STE%'' and
> addr not like ''%STE%STE%STE%'' and (addr similar to
> ''%STE[A-Z]*[0-9]+'' or addr similar to ''%STE[A-Z]*[0-9]+[A-Z]'' or
> addr similar to ''%STE[A-Z]*[0-9]+[A-Z][
Within the function I have:
for darec in select * from purchbt where addr not like ''%STE%STE%'' and
addr not like ''%STE%STE%STE%'' and (addr similar to
''%STE[A-Z]*[0-9]+'' or addr similar to ''%STE[A-Z]*[0-9]+[A-Z]'' or
addr similar to ''%STE[A-Z]*[0-9]+[A-Z][A-Z]'') loop
and it finds n
Robert,
We used Data Manager from JP to do this. Worked well. He recently added
the ability to read OEM versions of ASA. How's come your moving away from
SQL Anywhere?
Best Regards
Mike Gould
"Robert Paresi" wrote:
> Hello,
>
> We have 700 user install base using Sybase SQL Anywhere 9.02
>
On Thu, 2011-01-20 at 11:37 -0500, Robert Paresi wrote:
> Hello,
>
> We have 700 user install base using Sybase SQL Anywhere 9.02
>
> We are looking at migrating these installations over to PostGres
>
> 1. Very Very Short Answer Please - why should we?
* Lower TCO
* More flexibility
* A growin
On 1/20/2011 10:37 AM, Robert Paresi wrote:
Hello,
We have 700 user install base using Sybase SQL Anywhere 9.02
We are looking at migrating these installations over to PostGres
1. Very Very Short Answer Please - why should we?
You should not. Does not sound like you have a problem to solve.
"Robert Paresi" writes:
> Hello,
>
> We have 700 user install base using Sybase SQL Anywhere 9.02
>
> We are looking at migrating these installations over to PostGres
>
> 1. Very Very Short Answer Please - why should we?
Cheaper? Perhaps faster? It's tough to guess, absent of metrics as to
why
Hello,
We have 700 user install base using Sybase SQL Anywhere 9.02
We are looking at migrating these installations over to PostGres
1. Very Very Short Answer Please - why should we?
2. Does anyone have a utility or migration application to read SQL Anywhere
to go to PostGres
3. Does Pos
On Thu, Jan 20, 2011 at 1:49 AM, Gregory Machin wrote:
> In short how can I get "Hot standby" / master-master replication that
> will be transparent to the changes made by Silver Stripe, that will
> work with Postgresql 8.4.4.
>
The only replication system I know of that does not need to be aware
Hi.
I'm new to Postgresql, database replication and Silver Stripe.
I have to provide a solution for real time database replication. I was
using Rubyrep to do replication to a second database running as Hot
standby / Master-Master. The developers failed to tell me that you
can't use trigger based r
On Thursday 20 January 2011 6:59:08 am Khristian wrote:
> Hi,
> I'm trying to backup a schema in a database which uses OIDs. Using
> pg_dump | psql works fine, but I need to backup it to a file. So I
> tried using pg_dump like this:
> pg_dump -h localhost -U usr -F c -f dump.sql -o -n my_schema -b
Hi,
I'm trying to backup a schema in a database which uses OIDs. Using
pg_dump | psql works fine, but I need to backup it to a file. So I
tried using pg_dump like this:
pg_dump -h localhost -U usr -F c -f dump.sql -o -n my_schema -b source_db_name
And then restoring it with:
pg_restore -d target_db
> Any suggestions?
you might find this approach useful:
http://www.depesz.com/index.php/2008/01/18/how-to-check-if-given-update-is-from-trigger-or-why-i-hate-orms/
Best regards,
depesz
--
Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/
jid/gtalk: dep...@depesz.com
26 matches
Mail list logo