SEO

We, here at EMS Database Management Solutions, are pleased to announce
SQL Manager 2007 for PostgreSQL - the new major version of the
powerful PostgreSQL administration and development tool!

You can download SQL Manager 2007 for PostgreSQL at:
http://www.sqlmanager.net/products/p...nager/download

You can purchase SQL Manager 2007 for PostgreSQL at:
http://www.sqlmanager.net/products/p...ql/manager/buy

What's new in SQL Manager 2007 for PostgreSQL?
1. Support of UTF8 data in SQL Editor, Query Builder, Grid View, Data
Export/Import Wizard.
2. Now you can continue working with SQL Manager while a query is
being executed in SQL Editor or Query Builder or while table or view
data are being loaded in the editor. A query taking too long to
execute can be aborted when using PostgreSQL 8.0 and higher.
3. New Database Statistics form added; it allows viewing various
statistic information on database objects, helps to find weak points
in database performance, indicates if it's necessary to create new
indices, etc. The corresponding options must be enabled in server
configuration file (postgresql.conf.) for collecting statistics.
4. All Wizards, including Data Export/Import, DB Extract, Copy DB
wizards can now be run in the background mode, so that you could
continue working with the program.
5. New improved SQL Editor of the Visual Studio 2005 kind with Code
Folding function and UNICODE support.
6. Improved Data Import Wizard now allows to import data up to 10
times faster. New import formats have been added: HTML, XML Document,
Open Document Format (OpenOffice), Open XML Format (MS Word 2007, MS
Excel 2007).
7. Support of new PostgreSQL 8.2 features is implemented (FILLFACTOR
parameter for tables and indices, CONNECT permission for databases,
USAGE permission for sequences, support of CREATE INDEX CONCURRENTLY,
ALTER TABLE [ NO ] INHERIT support, creating domains based on other
domains, support of IF EXISTS clause in DROP operators of the Extract
Database Wizard, reassigning ownership of all objects owned by a
role).
8. Object editors now contain the Permissions tab which allows to
grant permissions on the object for users and groups.
9. Common SQL commands can now be generated from DB Explorer (Script
to SQL Editor, Script to Clipboard). Now you can easily generate such
SQL commands as CREATE, ALTER, DROP, SELECT etc for each database
object.
10. Now you can save your queries in the Favorite Queries folders in
DB Explorer; these queries Óan be stored either locally in the
registry (nobody but you will have access to them) or in a special
database table (then all or some of your db users will have access to
it).
11. Download File wizard has been added, which allows to download and
upload files from/to PostgreSQL server machine using standard
PostgreSQL functions and FTP/SFTP protocols.
12. Improved Visual database designer; new object type - comments - is
added. One can now choose whether only object names or fields should
be displayed. Now it is possible to select schemas whose tables should
be added to the diagram when performing Reverse Engineering.
13. Improved Data Export Wizard now works faster. New export formats
have been added: XML Document, Open Document Format (OpenOffice), Open
XML Format (MS Word 2007, MS Excel 2007).
14. Database Properties window has been added, which displays database
options and allows to change some of them.
15. Improved Table Editor. Now it is possible to view and change table
properties on a new tab.
16. Tasks menu is added in DB Explorer context menu. It contains
common operations which can be performed on the object selected. Also
hosts are now named in accordance with the selected connection type
(SSH or HTTP tunneling).
17. Improved report building system.
18. Function Debugger. The variable that changed its value at the last
step is displayed bold at the Debug Information window. The SQLSTATE
and SQLERRM variables are also displayed now.
19. Lots of other improvements and bug-fixes.

Hope you will enjoy working with our software.

On May 23, 8:47 am, "EMS Database Management Solutions
(SQLManager.net)" <sqlmana...@gmail.com> wrote:
> We, here at EMS Database Management Solutions, are pleased to announce
> SQL Manager 2007 for PostgreSQL - the new major version of the
> powerful PostgreSQL administration and development tool!
>
> You can download SQL Manager 2007 for PostgreSQL at:http://www.sqlmanager.net/products/p...nager/download
>
> You can purchase SQL Manager 2007 for PostgreSQL at:http://www.sqlmanager.net/products/p...ql/manager/buy
>
> What's new in SQL Manager 2007 for PostgreSQL?

<snip>


Thanks for this, but is there any plan to launch something like this
for use on Linux admin servers? Something that I could install on a
server, and perhaps work with a web interface? I would love some
recommendations.

Many thanks!
LB

--
Conan O' Brien gets it right!
http://blogs.pcworld.com/tipsandtwea...es/004369.html

On 22 May 2007 17:47:46 -0700, EMS Database Management Solutions
(SQLManager.net) <sqlmanager@gmail.com> wrote:
> We, here at EMS Database Management Solutions, are pleased to announce
> SQL Manager 2007 for PostgreSQL - the new major version of the
> powerful PostgreSQL administration and development tool!

I'd be happy to use EMS products, but I really need Linux versions.
Any plans regarding *nix platforms support?


--
Best regards,
Nikolay

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org/

On 23/05/2007 11:40, L. Berger wrote:

> Thanks for this, but is there any plan to launch something like this
> for use on Linux admin servers? Something that I could install on a
> server, and perhaps work with a web interface? I would love some
> recommendations.

Have you tried PHPPgAdmin? I use it all the time and am very happy with it.

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

On May 22, 2007, at 19:47 , EMS Database Management Solutions
(SQLManager.net) wrote:

> We, here at EMS Database Management Solutions, are pleased to announce
> SQL Manager 2007 for PostgreSQL - the new major version of the
> powerful PostgreSQL administration and development tool!

Congratulations on the release. In the future, refrain from posting
product announcements to the pgsql-general list. Thanks!

Michael Glaesemann
grzm seespotcode net



---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Nikolay Samokhvalov wrote:
> On 22 May 2007 17:47:46 -0700, EMS Database Management Solutions
> (SQLManager.net) <sqlmanager@gmail.com> wrote:
>> We, here at EMS Database Management Solutions, are pleased to announce
>> SQL Manager 2007 for PostgreSQL - the new major version of the
>> powerful PostgreSQL administration and development tool!
>
> I'd be happy to use EMS products, but I really need Linux versions.
> Any plans regarding *nix platforms support?
>
>

Ditto, when will we see the *nix versions?

--
Kenneth Downs
Secure Data Software, Inc.
www.secdat.com www.andromeda-project.org
631-689-7200 Fax: 631-689-0527
cell: 631-379-0010


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org/

Kenneth Downs a écrit :
> Nikolay Samokhvalov wrote:
>> On 22 May 2007 17:47:46 -0700, EMS Database Management Solutions
>> (SQLManager.net) <sqlmanager@gmail.com> wrote:
>>> We, here at EMS Database Management Solutions, are pleased to announce
>>> SQL Manager 2007 for PostgreSQL - the new major version of the
>>> powerful PostgreSQL administration and development tool!
>>
>> I'd be happy to use EMS products, but I really need Linux versions.
>> Any plans regarding *nix platforms support?
>>
>>
>
> Ditto, when will we see the *nix versions?
>

I asked them some time ago. They answered me this :

As for SQL Manager for PostgreSQL - we regret to inform you that the
development and support of Linux editions of EMS software products has
become impossible now that Borland no longer supports Kylix libraries
for Delphi, on which all Linux versions of EMS software were based.
Hence, EMS has made a decision to discontinue Linux versions of its
products. Linux products will not be available for sale or download anymore.


--
Guillaume.
<!-- http://abs.traduc.org/
http://lfs.traduc.org/
http://docs.postgresqlfr.org/ -->

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Group,
I have to admit, I'm a little disappointed. I'm a HUGE advocate of
PostgreSQL(to state for the record) - in fact I always keep my eyes peeled
for opportunities to recommend it in my day to day business.

So why am I disappointed, and who really cares?

I'm disappointed because SLONY-II has not been released yet to support
multi-master replication! PostgreSQL is going through all of the releases
- and that's great - BUT, where is the sync-up with the powerhouse of a
component, that Slony-II would bring to the table? Slony-I is pretty
sweet, but if Slony-II would release, I can imagine that this would
introduce some major competition in the enterprise world against the
commercial dyno's.

I've been doing some really cool stuff with the latest versions of
OpenLDAP and PostgreSQL on Solaris 10(in the past Solaris 9) also using
Linux(Fedora Core - go Redhat).

Anyone have any thoughts/comments to this end?


On Fri, 1 Jun 2007, Guillaume Lelarge wrote:

> Kenneth Downs a écrit :
>> Nikolay Samokhvalov wrote:
>>> On 22 May 2007 17:47:46 -0700, EMS Database Management Solutions
>>> (SQLManager.net) <sqlmanager@gmail.com> wrote:
>>>> We, here at EMS Database Management Solutions, are pleased to announce
>>>> SQL Manager 2007 for PostgreSQL - the new major version of the
>>>> powerful PostgreSQL administration and development tool!
>>>
>>> I'd be happy to use EMS products, but I really need Linux versions.
>>> Any plans regarding *nix platforms support?
>>>
>>>
>>
>> Ditto, when will we see the *nix versions?
>>
>
> I asked them some time ago. They answered me this :
>
> As for SQL Manager for PostgreSQL - we regret to inform you that the
> development and support of Linux editions of EMS software products has
> become impossible now that Borland no longer supports Kylix libraries
> for Delphi, on which all Linux versions of EMS software were based.
> Hence, EMS has made a decision to discontinue Linux versions of its
> products. Linux products will not be available for sale or download anymore.
>
>
>

--
Louis Gonzales
louis.gonzales@linuxlouis.net
http://www.linuxlouis.net

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org/

gonzales@linuxlouis.net wrote:
> Group,
> I have to admit, I'm a little disappointed. I'm a HUGE advocate of
> PostgreSQL(to state for the record) - in fact I always keep my eyes
> peeled for opportunities to recommend it in my day to day business.
>
> So why am I disappointed, and who really cares?
>
> I'm disappointed because SLONY-II has not been released yet to support
> multi-master replication! PostgreSQL is going through all of the
> releases - and that's great - BUT, where is the sync-up with the
> powerhouse of a component, that Slony-II would bring to the table?
> Slony-I is pretty sweet, but if Slony-II would release, I can imagine
> that this would introduce some major competition in the enterprise world
> against the commercial dyno's.

Which databases ship with multi-master replication?

Joshua D. Drake



--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

On Fri, 1 Jun 2007, Joshua D. Drake wrote:

> gonzales@linuxlouis.net wrote:
>> Group,
>> I have to admit, I'm a little disappointed. I'm a HUGE advocate of
>> PostgreSQL(to state for the record) - in fact I always keep my eyes peeled
>> for opportunities to recommend it in my day to day business.
>>
>> So why am I disappointed, and who really cares?
>>
>> I'm disappointed because SLONY-II has not been released yet to support
>> multi-master replication! PostgreSQL is going through all of the releases
>> - and that's great - BUT, where is the sync-up with the powerhouse of a
>> component, that Slony-II would bring to the table? Slony-I is pretty
>> sweet, but if Slony-II would release, I can imagine that this would
>> introduce some major competition in the enterprise world against the
>> commercial dyno's.
>
> Which databases ship with multi-master replication?
I dunno, which ones?

Which ones have robust and fully functional multi-master replication?
(Oracle, MS SQL, not-PostgreSQL).

>
> Joshua D. Drake
>
>
>
>

--
Louis Gonzales
louis.gonzales@linuxlouis.net
http://www.linuxlouis.net


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match