[pgadmin-support] Connection ODBC

[Daniel]

Date: 06/01/03
 
    I need to connect ASP - (Active 
Server Pages) to the data base POSTGRESQL,  Is it 
possible?
    I don't know the connection 
string, so I need that someone can help me, and tell me some 
information about that.
    Are there some more special 
thing to do?

 
Thanks for all...
From Brazil
Sds, Daniel
 
 

[pgadmin-support] Connection ODBC

[Daniel]

 
 
Gostaria de saber como o PostgreSQL consegue conectar-se automaticamente com o servidor 
postmaster
sem necessidade de start manual do 
mesmo;
 
O que devo fazer ?
 
Sds.
Daniel

[pgadmin-support] help

[daniel]

Hello  ! I'm using your application Pgadmin a lot.
I have a question : where is the server list saved ? i can't find any file
on my computer with this info.
I need to install the same configuration on a lot of computers and I can't
find a quick solution.


My OS : Windows Xp

--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[pgadmin-support] Question

[daniel]

Is there a tool to convert
postgresql backups (sql.gz files) to Pgadmin Backups ?

Thank you
--



--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] Question

[daniel]

Title: Dan Turcitu




That's my biggest problem.
The server i have use plain format dumps , but use gz to archive them .

I could change the way backups are made but that's not my goal.

So my problem remains : how can i convert Plain format dumps to files
readable by pg_restore ?



Dave Page wrote:

  On Thu, Jun 19, 2008 at 8:34 AM, daniel <[EMAIL PROTECTED]> wrote:
  
  
Is there a tool to convert
   postgresql backups (sql.gz files) to Pgadmin Backups ?

  
  
With the exception of PLAIN format dumps, they are entirely compatible
because pgAdmin just calls pg_dump to create them. PLAIN format
backups must be fed into psql however - pg_restore doesn't understand
them, and that's what pgAdmin uses for restores.

  



-- 









Dascar
Daniel
Ascent
Soft SRL
www.ascent-soft.ro
[EMAIL PROTECTED]

tel:
+40256 40.74.00
fax:
+40356 40.90.47
gsm:
+40722 32.67.96

[pgadmin-support] pgAdmin crashes when showing "Guru Hint - Server denies access" with Polish locale

[daniel]

Hi,
I found that pgAdmin crashes when it tries to connect to DB and then  
wants to show the "Guru Hint - Server denies access" dialog. This  
happens when language is set to Polish (pl_PL). When I switched to  
English, problem disappeared - dialog was displayed properly. Please  
fix this.


Windows 7 Pro SP1 (English version)
pgAdmin installed from binary package, version 1.18.1


Regards,
Daniel



--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[pgadmin-support] unsubscribe

[Daniel Chang]

unsubscribe

Daniel Chang,
Software Engineer,
Changsoft, Inc.


<>
---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[pgadmin-support] unsubscribe

[Daniel Chang]

unsubscribe

[pgadmin-support] unsubscribe

[Daniel Chang]

unsubscribe
<>
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings

[pgadmin-support] BUG: spaces in passwords

[Daniel Risacher]

pgAdmin III does not appear to handle passwords with spaces in them.

Leading and trailing spaces simply fail to authenticate.

Internal spaces produce the error message:
 missing '=' after 'xxx' in connection info string

Where 'xxx' is the part of the password after the space.

For reference, I'm using pgAdmin III 1.0.2 on Win2k against PostgreSQL
7.4.1 on sparc-sun-solaris2.9, compiled by GCC gcc (GCC) 3.3

-- 
 "The blues are multicolored."   -- Dave Lambert

Daniel Risacher  [EMAIL PROTECTED]

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

   http://archives.postgresql.org

Re: [pgadmin-support] [PHP] Secure DB Systems - How to

[Daniel Struck]

> Keeping the system administrator from seeing the data while making it
> searchable is difficult. To do this you need to encrypt the data on
> the client side using a key the client has (and this key has to be
> protected from loss) and the only searches you can do are equality
> searches using a hash or encrypted value.

You can also perform regex searches.

Here is an example to get you started:

CREATE TABLE crypto (
id SERIAL PRIMARY KEY,
title  VARCHAR(50),
crypted_contentBYTEA
);


INSERT INTO  crypto VALUES 
(1,'test1',encrypt_iv('daniel','fooz',decode('9MlPeZtpuxKo5m4O4+pd4g==','base64'),'aes'));
INSERT INTO  crypto VALUES 
(2,'test2',encrypt_iv('test','fooz',decode('9MlPeZtpuxKo5m4O4+pd4g==','base64'),'aes'));
INSERT INTO  crypto VALUES 
(3,'test3',encrypt_iv('struck','fooz',decode('9MlPeZtpuxKo5m4O4+pd4g==','base64'),'aes'));

SELECT *,decrypt_iv(crypted_content, 
'fooz',decode('9MlPeZtpuxKo5m4O4+pd4g==','base64'), 'aes') FROM crypto;

-- equality search
SELECT 
*,decrypt_iv(crypted_content,'fooz',decode('9MlPeZtpuxKo5m4O4+pd4g==','base64'),'aes')
FROM crypto WHERE decrypt_iv(crypted_content, 
'fooz',decode('9MlPeZtpuxKo5m4O4+pd4g==','base64'), 'aes')='struck';

-- regex search
SELECT 
*,decrypt_iv(crypted_content,'fooz',decode('9MlPeZtpuxKo5m4O4+pd4g==','base64'),'aes')
FROM crypto WHERE encode(decrypt_iv(crypted_content, 
'fooz',decode('9MlPeZtpuxKo5m4O4+pd4g==','base64'), 'aes'),'escape')
~* 'daniel';


"fooz" is the password and "9MlPeZtpuxKo5m4O4+pd4g==" is the IV (initialization 
vector) stored in base64 format. I choose base64 because it is more convenient to 
create queries with it.

In the real database I do use a different IV for every row, so I do also store the IV 
with the row.
In my case I do generate the IV by PHP with /dev/urandom as a random source.


Greetings,

Daniel Struck

-- 
Retrovirology Laboratory Luxembourg
Centre Hospitalier de Luxembourg
4, rue E. Barblé
L-1210 Luxembourg

phone: +352-44116105
fax:   +352-44116113
web: http://www.retrovirology.lu
e-mail: [EMAIL PROTECTED]

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [pgadmin-support] [PHP] Secure DB Systems - How to

[Daniel Struck]

> If you decrypt the data on the database, the sysadmin can see it.

Hm, you are right. If one does decrypt the data on the database you have to sent the 
password to postgresql and so a administrator of the database could easily grasb the 
password.

So the only way to go, would be to perform en/decryption on the client side?


> If you are willing to take that chance (e.g. if you primary concern is
> some third party getting a snapshot of the DB), then you can do lots of
> things.

I wonder now; if somebody could achieve to get a snapshot of the database, they could 
also be able to get the log-file of postgresql.
So one would also have to make attention that the information like sql statements 
don't leak that way.
Are there other places where this kind of information could leak?


Greetings,

Daniel Struck

-- 
Retrovirology Laboratory Luxembourg
Centre Hospitalier de Luxembourg
4, rue E. Barblé
L-1210 Luxembourg

phone: +352-44116105
fax:   +352-44116113
web: http://www.retrovirology.lu
e-mail: [EMAIL PROTECTED]

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

[pgadmin-support] BUG in New Server Dialog

[Daniel Espinosa]

In the Entry for Password need be hiden the
caracteres, now it show the password you write!

=
>>>
Trabajar es la mejor arma para tu superación.

_
Do You Yahoo!?
La mejor conexión a internet y 25MB extra a tu correo por $100 al mes. 
http://net.yahoo.com.mx

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faqs/FAQ.html

[pgadmin-support] printing table-structure

[Daniel Seichter]

Good morning,

I am new at the pgadmin-support list. I want to print the tables, but
can't find a printer-button or something else. Is there a solution for
printing the table-structure? I thought to develope a solution for
myself, but can't, because I don't know if pgadmin is developed in
Delphi ( I am really new pgadmin).

Hope to find an answer here

Daniel

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly

[pgadmin-support] Order columns

[Daniel Seichter]

Hello,

isn't there a function for reorder columns of an existing table?

Daniel

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

Antw: (possibly spam: 8.6484) Re: [pgadmin-support] Order columns

[Daniel Seichter]

Hello,

ok, thank you.

Daniel

>>> Andreas Pflug <[EMAIL PROTECTED]> 07.04.2005 14:36 >>>
Daniel Seichter wrote:
> Hello,
> 
> isn't there a function for reorder columns of an existing table?

No, and there never will be, this was discussed exhaustively on 
pgsql-hackers.
Simply *never-ever* rely on the order of columns of a SELECT *, on any

database system; it's always a call for trouble.

Regards,
Andreas


---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly

[pgadmin-support] Add 'CHECK( length(fieldname) > 0 )' to a field

[Daniel Seichter]

Hello,

I have to let postgreSQL check the length of some fields in a database.
So I want to add the SQL Code "CHECK( length(fieldname) > 0 )" to some
fields so that the check will be executed during INSERT statement.
With the properties dialog I can't add the CHECK statement, so maybe it
isn't possible or I have to take a look to something. But to what?

Thank you in advance

Daniel Seichter

---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings

[pgadmin-support] FR: import textfile as new records

[Daniel Seichter]

Hello,

I want to import some data as comma seperated list (or separated with
|) but I don't know how? I get a list with values, which I have to
INSERT into a table. What possibilities I have?
Using snapshot build from 5th July under Win32 (server is linux)

Thanks

Daniel

---(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

[pgadmin-support] RFE: Make Control+Enter execute query

[Daniel Serodio]

If this is the wrong place for RFE's, I'm sorry, please point me to the
right one.

I'd like to request that Control+Enter execute the query in the
"pgAdmin III Query" window, to make it more consistent with similar
tools.

Thanks in advance,
Daniel Serodio


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

Re: [pgadmin-support] RFE: Make Control+Enter execute query

[Daniel Serodio]

"Dave Page" wrote:
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] On Behalf Of
> > Daniel Serodio
> > Sent: 05 September 2006 20:34
> > To: pgadmin-support@postgresql.org
> > Subject: [pgadmin-support] RFE: Make Control+Enter execute query
> >
> > If this is the wrong place for RFE's, I'm sorry, please point
> > me to the
> > right one.
> >
> > I'd like to request that Control+Enter execute the query in the
> > "pgAdmin III Query" window, to make it more consistent with similar
> > tools.
>
> pgAdmin uses F5, per SQL Server's Query Analyser. That's not going to
> change I'm afraid.

I see. Isn't is possible to have both shortcuts?

TIA,
Daniel Serodio


---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly

[pgadmin-support] Menu accelerators don't work when another window has a modal dialog open

[Daniel Segall]

Summary:
 
If I have two Query windows open, and one has a modal dialog open, I
cannot execute queries in the other one by pressing F5.  Using the mouse
to select Query -> Execute, however, does work.
 
To Reproduce:
 
1. Open 2 Query windows.
2. In one window, select File -> Open.  Leave the Open File Dialog
alone.
3. Switch to the other Query window.  Type in a query.
4. Try to execute by pressing F5.  (Bug - doesn't work)
5. Try to execute by selecting Query -> Execute with the mouse.  (Works
fine)
 
Platform:
 
WinXP SP2
pgAdmin III 1.6.1, English, Binary distribution
 
Daniel Segall
Software Engineer | Aegis Software
14 Penn Plaza | Ste 806 | New York, NY 10122
Email [EMAIL PROTECTED] | Phone (212) 651.9407
 

[pgadmin-support] Using Quotation marks.

[Daniel Mendes]

Hello,

I am using postgres installed in two different computers, in one I
have to do the queries using quotation marks (select * from "Table")
and in the other I can do select * from Table.
What can I do to disable the use of quotation marks?

 Thanks
Daniel Gomes Mendes

---(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

[pgadmin-support] Version 1.8, Windows version

[Daniel Degasperi]

Hello,

when i open a database i can't find tree node "aggregates" in the 
database object browser.

The tree node "aggregates" was shown in version 1.61

Best regards
Daniel Degasperi

--

 Daniel Degasperi
 Software Developer
 [EMAIL PROTECTED]
 
==

Venite a trovarci all'ASITA, dal 6 al 9 novembre a Torino www.asita.it
Besuchen Sie uns bei der Messe ASITA vom 6. bis 9. November in Turin 
www.asita.it
Visit us at ASITA, from 6th to 9th November in Torino www.asita.it
==
 
---

 R3 GIS Srl
 Via Johann Kravogl 2
 I-39010 Merano - Sinigo (BZ)
 Tel. +39 0473 494949
 Fax. +39 0473 069902
 Web  http://www.r3-gis.com
-


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

[pgadmin-support] Wish: Option to remove pg_temp and pg_toast from views

[Daniel Migowski]

 Dear developers,

I already know that I can hide system objects in PGAdmin to remove the 
pg_toast and pg_temp schemas from my views, but I usually am very 
interested in system objects.


The pg_toast and pg_temp schemas are different, because I can't open my 
tree anymore to find my public schema, without navigation down along 200 
useless items, which shouldn't even be removed ("Just ignore them" is 
official statement).


Please ad an Option in PGAdmin to exclude these schemata specifically.

Thank you VERY MUCH in advance, this is so annoying.

Regards,
Daniel Migowski


--
*I**K*Office
*UNTERNEHMENSSOFTWARE*
    IKOffice GmbH   *Daniel Migowski*

Mail:   dmigow...@ikoffice.de <mailto:dmigow...@ikoffice.de>
Nordstrasse 10  Tel.:   +49 (0)441 21 98 89 52
26135 Oldenburg Fax.:   +49 (0)441 21 98 89 55
http://www.ikoffice.de  Mob.:   +49 (0)176 22 31 20 76

Geschäftsführer:    Ingo Kuhlmann, Daniel Migowski
Amtsgericht Oldenburg:  HRB 201467
Steuernummer:   64/211/01864

[pgadmin-support] Stop pgpass.conf EOL conversion

[Daniel Browning]

Do you agree with modifying pgAdmin so that it stops converting the EOL 
characters in the pgpass.conf file from unix-style (\n) to Windows-style 
(\r\n)?

It works fine with unix-style line endings, and if the file is in that format 
already, I think it should leave well enough alone.

The reason the issue came up is that I would like to be able to use one pgpass 
file for both Windows applications (pgAdmin, psql under powershell, etc.) and 
cygwin applications (/usr/bin/psql). I created a symlink from the pgpass.conf 
file to .pgpass, and it works perfectly. Until, that is, I launch pgAdmin and 
it adds the Windows carriage returns. Then, cygwin's psql stops working; it 
seems to send the carriage return appended to the end of the password, 
resulting in incorrect password errors.

For now, I can work around the problem by setting the pgpass.conf file to be 
read-only at the filesystem level, forcing pgAdmin to stop updating it. 
Apparently, unix-style EOL chars work everywhere (Windows and cygwin), while 
Windows-style EOL chars only work in Windows. If a user wants Windows-style, 
I'd say we should let them do it themselves with their text editor, not do it 
for them behind the scenes.

You might wonder why I don't just work around the problem by only using the 
Windows version of psql from within cygwin. The answer to that is because it 
hangs under cygwin's mintty. I think it's due to the use of native windows 
console functions, which aren't supported under mintty, as reported here:

http://stackoverflow.com/questions/13731384/

Another workaround would be to programatically generate the pgpass.conf from 
the .pgpass file (or vice-versa), but that involves an extra step of work 
every time the file is edited, just like my current workaround (overriding the 
read-only every time I want to make a change).

I could also just not use cygwin, but as a long-term Linux user, I find that 
when I am forced to use Windows, as in this case, it is significantly easier 
for me to use cygwin than to learn all the Windows-equivalent commandline 
tools, which in many cases do not even exist.

What do you think?
--
DB


-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] Stop pgpass.conf EOL conversion

[Daniel Browning]

On Friday 05 September 2014 12:57:21 am Dave Page wrote:
> On Thu, Sep 4, 2014 at 11:23 PM, Daniel Browning  wrote:
> > Do you agree with modifying pgAdmin so that it stops converting the EOL
> > characters in the pgpass.conf file from unix-style (\n) to Windows-style
> > (\r\n)?
> >
> > It works fine with unix-style line endings, and if the file is in that
> > format already, I think it should leave well enough alone.
> >
> > The reason the issue came up is that I would like to be able to use one
> > pgpass file for both Windows applications (pgAdmin, psql under
> > powershell, etc.) and cygwin applications (/usr/bin/psql). I created a
> > symlink from the pgpass.conf file to .pgpass, and it works perfectly.
> > Until, that is, I launch pgAdmin and it adds the Windows carriage
> > returns. Then, cygwin's psql stops working; it seems to send the carriage
> > return appended to the end of the password, resulting in incorrect
> > password errors.
> 
> The primary reason that file (and others) are written with DOS line
> endings is because the default editor on Windows (notepad) can't cope
> with *nix style line ends.

I can understand that, but how would such a user have ever ended up with a 
file that has unix line-endings anyway?

If they were creating it from scratch, it would have windows EOLs already. If 
they copied the file from another windows developer, it would have them too. 
The only case I can think of where this feature would be useful is in a pretty 
specific set of circumstances:

 * A novice user copies a .pgpass file with *nix EOLs from a colleague
 * He knows to rename it to pgpass.conf and put it in AppData\Roaming\etc.
 * When he tries to open it in notepad, it's all wonky and he is confused.
 * He tries running PgAdmin anyway
 * PgAdmin fixed the file so it can be opened in notepad
 * The novice user is thankful for PgAdmin doing that

To me, that seems like a pretty rare circumstance -- and not really PgAdmin's 
place to be doing that. Now if the user was actually *modifying* the 
pgpass.conf in PgAdmin, I could see some reason behind converting to windows 
EOLs; however, when the file is only being read and not written, it seems like 
converting EOLs is trying to be too helpful.

> This is obviously a PITA, as it requires
> users to install a better editor (which is arguably a very good idea
> anyway, but we don't want to force it on users who may just be setting
> up an app on a machine for someone else for example).

Agreed. My inner pedant would like to point out that technically, they don't 
have to install a better editor, they just need to open the file in Wordpad, 
which is distributed with all versions of windows from at least Windows 95 
through 8.1, and reads files with unix-style line endings. But for some novice 
users, opening a file in a non-default program is probably just as hard as 
installing a new text editor, so your point remains.

> > I could also just not use cygwin, but as a long-term Linux user, I find
> > that when I am forced to use Windows, as in this case, it is
> > significantly easier for me to use cygwin than to learn all the
> > Windows-equivalent commandline tools, which in many cases do not even
> > exist.
> 
> Have you tried Msys? Not suggesting you should switch, but it would be
> interesting to know how it behaves.

I haven't tried it. If I get a chance to, I'll report back.

> > What do you think?
> 
> At the moment I'm leaning towards leaving it as-is. I see your
> problem, but you're the only person to report it in 12+ years that I
> can remember. I suspect the notepad issue would inconvenience far more
> users. I suppose we could make it a configurable option.

Personally, I'd be in favor of a configurable option and a dialog box that 
says something like:

"Your pgpass.conf file was in unix format, so we converted it to Windows 
format for you. If you would like to change this behavior, access the such-
and-such option."
--
DB


-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] Stop pgpass.conf EOL conversion

[Daniel Browning]

On Friday 05 September 2014 12:38:26 pm Dave Page wrote:
> pgAdmin writes that file whenever a user successfully logs into a server
> with a new password for the first time, and opts to save it.

Ah, that probably explains what happened to me. I had all my passwords already 
setup in pgpass, and every time I connected to a new server, pgAdmin would ask 
me for a password, which of course I left blank because it was already in 
pgpass. After a while of repeatedly hitting enter on the same password dialog 
box, I finally clicked the save password checkbox (with a blank password), and 
it stopped asking me.

So maybe the pgAdmin might just stop updating the pgpass file when a user is 
trying to "save" a blank password?

>  If the user then edits the file in notepad (maybe to add new details for a
>  server to use from psql), they'll run into problems.

I'm fine with pgAdmin converting to Windows EOLs if the user changes or saves 
passwords in pgAdmin. But it seems like there's a place for users who just 
want pgAdmin to read the passwords, not change them or rewrite the file for no 
reason except to change the EOL chars.

--
DB


-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[pgadmin-support] Error when deleting multiple databases: "Maintenance database can't be dropped."

[Daniel Hahler]

Hello,

When selecting multiple databases (via the "Properties" tab) and trying to
delete them, only the first one gets deleted, and then an error pops up.

The question:

  Drop multiple objects?
Are you sure you wish to drop multiple objects?

The error:

  Dropping database not allowed
Maintenance database can't be dropped.

The "maintenance database" is not selected.

This is with pgadmin3 1.20.0-1 from Debian (the experimental repo), but
happens with 1.18.1-3, too.

The system is Ubuntu 14.04.

I am using libwxgtk3.0-0=3.0.2-1 and libwxbase3.0-0=3.0.2-1 (upgraded for
pgadmin3 1.20).

I think it might be related to having installed the postgresql-contrib package
and using the "Fix it!" button from the wizard that recommends this when
selecting the "postgres" database.
If I remember correctly, this used to work before - and I've suspected it to
be a regression in 1.20 (which I've just upgraded to also), but then the bug
is now also there with 1.18.


Thanks,
Daniel.

-- 
http://daniel.hahler.de/



signature.asc
Description: OpenPGP digital signature

[pgadmin-support] Error when deleting multiple databases: "Maintenance database can't be dropped."

[Daniel Hahler]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hello,

When selecting multiple databases (via the "Properties" tab) and trying to
delete them, only the first one gets deleted, and then an error pops up.

The question:

  Drop multiple objects?
Are you sure you wish to drop multiple objects?

The error:

  Dropping database not allowed
Maintenance database can't be dropped.

The "maintenance database" is not selected.

This is with pgadmin3 1.20.0-1 from Debian (the experimental repo), but
happens with 1.18.1-3, too.

The system is Ubuntu 14.04.

I am using libwxgtk3.0-0=3.0.2-1 and libwxbase3.0-0=3.0.2-1 (upgraded for
pgadmin3 1.20).

I think it might be related to having installed the postgresql-contrib package
and using the "Fix it!" button from the wizard that recommends this when
selecting the "postgres" database.
If I remember correctly, this used to work before - and I've suspected it to
be a regression in 1.20 (which I've just upgraded to also), but then the bug
is now also there with 1.18.


Thanks,
Daniel.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1

iD8DBQFUu9gMfAK/hT/mPgARAvuuAKCrVfZs0LjNXAcZ+Ex4Ov89N2NSsACg1rm3
zAARlgNODhhWxOmtgjJsaZg=
=7jmv
-END PGP SIGNATURE-


-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[pgadmin-support] What does "+01" mean in a timestamp field

[Daniel Grace]

What does "+01" mean in a timestamp field, for example:
"2015-06-28 22:00:00+01"

I am assuming it is timezone information.

Thanks

[pgadmin-support] Bug: rows in Query Output pane are too narrow with higher DPI

[Daniel Hahler]

I'm seeing a problem similar to 
http://www.postgresql.org/message-id/f246364e-8def-4b0a-acb6-1d6113b7a...@pobox.com,
 but only with higher DPI (more than the default 96).

With DPI 96 the height of the columns/rows has enough height, but with 176 (or 
140) the cell contents gets cut off.

The same applies to the splash screen and (to some extent?!) the "Object 
browser" heading.

I can provide screenshots if that would help.

I am using Arch Linux, and pgadmin3 1.22.1.

The DPI is controlled via https://github.com/derat/xsettingsd (which provides 
settings to X11 applications via the XSETTINGS specification).

I am using "Xft/DPI 180224" (176 * 1024), but it's even more obvious with 
"Xft/DPI 256000" (250dpi).

TEST CASE:
1. run xsettingsd: xsettingsd -c <(echo "Xft/DPI 256000")
2. run pgadmin3 and look at the splash screen and "Query Output" tab (with 
results)


Thanks,
Daniel.

-- 
http://daniel.hahler.de/



signature.asc
Description: OpenPGP digital signature

[pgadmin-support] Cannot connect to Postgres without allowing non-SSL connections in pg_hba.conf

[Daniel Buus]

Hi there :)

I'm trying to connect to a Postgresql server (running in a Docker
container) from pgAdmin (most recent 3 stable as well as most recent 4
beta).

Connecting to the server works fine with Postico. With pgAdmin,
however, I get the error, "SSL error: sslv3 alert handshake failure
FATAL: no pg_hba.conf entry for host "172.17.0.1", user "postgres",
database "nosco", SSL off" as long as my pg_hba.conf looks like this:

local   all all  trust
hostall,replication replication samehost md5
hostssl all,replication replication samehost md5
hostssl all all samenet md5
hostssl nosco all .nos.co md5

The error message mentions "SSL off," so I tried adding "host all all
samenet md5" to pg_hba.conf, and this allows pgAdmin 4 to connect with
SSL still required in its connection settings. pgAdmin 3, however,
will still fail to connect with SSL required, but with the
non-SSL-allowing rule in pg_hba.conf it will now successfully connect
if I explicitly disable SSL in the connection settings.

Any idea why this is?

Thanks in advance,
Daniel


-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[pgadmin-support] unable to restore database

[Daniel Küppers]

Hi,
i tried to restore a database dump into my local db with pgAdmin4, but 
it fails for no reason.
The only thing the dialog outputs is "Restore Job created", nothing 
happens afterwards nor can i examine if the job is running.
Do you have a suggestion how to use the Backup and Restore tools in 
pgAdmin4?

Environment: pgAdmin4 1.2, Windows 10

Regards, Daniel


--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] unable to restore database

[Daniel Küppers]

This works. i can backup and restore the database. i also get the 
correct error message when i try to restore a pg_dump file.
But considering that this functionallity is essential, may i ask if 
pgAdmin4 is production ready or still in some kind of beta phase?
Im confused, because sometimes things break in the new ui or wont even 
show up, take extraordinary long and now this happening.


Thanks Dave for the working build.

Test build here: https://developer.pgadmin.org/~dpage/pgadmin4-1.2-x86.exe

On Fri, Mar 3, 2017 at 10:05 AM, Murtuza Zabuawala
 wrote:

Hi Daniel,

This is a bug and will be fixed in future release.

~Murtuza

On Fri, Mar 3, 2017 at 3:30 PM, Daniel Küppers  wrote:

Hi,
i tried to restore a database dump into my local db with pgAdmin4, but it
fails for no reason.
The only thing the dialog outputs is "Restore Job created", nothing
happens afterwards nor can i examine if the job is running.
Do you have a suggestion how to use the Backup and Restore tools in
pgAdmin4?
Environment: pgAdmin4 1.2, Windows 10

Regards, Daniel


--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support








--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[pgadmin-support] Where are Logfiles stored?

[Daniel Küppers]

Hi, i want to know if and when where pgAdmin4 stores Logfiles.
Im seeking two error notices that happend on a database restore.
I couldn't find a hint in the official documentation.

regards,
Daniel


--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] Where are Logfiles stored?

[Daniel Küppers]

Many thanks!
Sadly, the errors on import didn't got catched by the logfile.
Any hint how can i configure this to protocol errors of imports?

*Environment*
Version: 1.3
Python Version: 2.7.12
Flask Version: 0.11.1
Application Mode: Desktop
Windows 10 Pro 64 Bit

regards,
Daniel

Am 31.03.2017 um 10:03 schrieb Ashesh Vashi:
On Fri, Mar 31, 2017 at 1:28 PM, Daniel Küppers <mailto:dan...@tetralog.com>> wrote:


Hi, i want to know if and when where pgAdmin4 stores Logfiles.
Im seeking two error notices that happend on a database restore.
I couldn't find a hint in the official documentation.

Yes - it do as 'pgadmin4.log'

On windows - it generates the logs in the '%APPDATA%\pgAdmin' directory.
On non-windows - it generates the logs in the '$HOME/.pgadmin' directory

-- Regards,
Ashesh Vashi


regards,
Daniel


-- 
Sent via pgadmin-support mailing list

(pgadmin-support@postgresql.org
<mailto:pgadmin-support@postgresql.org>)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
<http://www.postgresql.org/mailpref/pgadmin-support>

Re: [pgadmin-support] making me love pgAdmin III

[Daniel Küppers]

Am 19.05.2017 um 10:04 schrieb Dave Page:

On Fri, May 19, 2017 at 7:36 AM, Tomek  wrote:

18 maja 2017 22:43 - "Dave Page" :


On 18 May 2017, at 21:09, Eric Hill  wrote:


Hey,

I don’t mean to hurt anyone’s feelings or anything, but is it not obvious to 
everyone that pgAdmin
4 (I have version 1.4) is bloody horrendous? It is absolutely as slow as 
Christmas. It’s use of
screen real-estate is poor. I was never a huge fan of pgAdmin III; I mean, it 
seemed to do its job
okay, but after using pgAdmin 4, suddenly I have newfound respect for pgAdmin 
III.

Not to me, because the number of people I've had complimenting pgAdmin 4 is 
probably 20x the number
who have said they don't like it. Which is a good sign - normally people who 
don't like something
are far more likely to say something.

Either way, I'm not going to lose sleep over it. pgAdmin 4 is far more stable 
than pgAdmin 3 was,
has attracted more new developers in a year than pgAdmin 3 had in 15, and 
continues to improve with
every release. I'm very proud of the way the team have built such a complex 
application in such a
short space of time that many people have told me they like.

You can't please everyone unfortunately, but then a) it's free (despite being 
estimated at over $2M
worth of work), and b) it's open source so those that are inclined can help 
improve it further.

Constructive feedback is always welcome of course. In your case maybe you could 
explain how you're
using it such that you see slow response. For me, it performs well, even on my 
low powered 1.2GHz
MacBook. It's naturally slower than pgAdmin 3 of course, as it's not a native 
application, but it
still outpaces my ability to drive it and I'm no slouch behind the keyboard.

You don't care what You users say about Your software??? That's a nice 
statement...

Twisting my words is a great way to make your point. Kudos.


I've posted here a list of what is missing/wrong in new pgAdmin - did You even 
commented on that?

Posted here? The website is quite clear that bugs and feature requests
should be logged as tickets on our Redmine instance. There is no
guarantee developers will read every message here.


What is this 'Constructive feedback'?

Constructive feedback is that which describes an issue and steps to
reproduce it with the aim of helping the developers resolve it, or in
the case of a new feature, describing what is required and why it
would be useful.

Feedback along the lines of "It's crap and I hate it" is unhelpful and
will likely be ignored.


How 4 is more stable than 3? Please explain it to us...

Because it doesn't crash every 5 minutes? Because it doesn't go nuts
if it loses an open database connection?


In 1.4 - query SELECT 2/0; returns
successfully...

Oh? I haven't seen that logged. When I try it, I get the result in the
attached screenshot.


And please, please explain to us how 'less and slower' is better than 'more and 
faster'...

The vast majority of the "more" wasn't used by anyone. Did you ever
create an Operator Class? Or use pgScript for example?

Sure, there are some things we left out that we didn't realise users
use - and we're adding them back in.

As for the speed, yes, it's a little slower due to the architecture,
but we're talking fractions of a second (at least on all the machines
and virtual machines I've tested on). I know I still can't keep up
with it. The only exception I know of is the query tool with very
large results sets, which we've been working on and already have a WIP
patch that makes it ~20x *faster* than pgAdmin 3 in some large test
cases.


I must ask it - do You even work with databases? Because from how You made new 
pgAdmin, it looks
like You don't have a clue what real dbadmins do...

You say pgAdmin 4 attracted more developers... I don't know how You measure it 
but for me - a guy
with more than 10 years work experience with PostgreSQL - it's a sign to move 
to another db...

I must say - You had a possibility that few developers have - make software 
from scratch - and You
made all possible mistakes:
- wrong toolkit (html... really??? - so many fast, portable toolkits and You 
picked the slowest...)

Oh? You have a better idea for something that we wanted to be able to
run over the web? Java or Flash perhaps?


I think, the community should stop blaming the developers for free 
Software. That is bad, seriously.

Of course we got issues in pgAdmin4 that need to be adressed. But remember:
they made the effort from native application to crossplatform browser 
compatible.
In my opinion, the declaration as stable was too early, but with that, 
the developers got also huge feedback.
So community, stop beeing a bully and be smart and constructive. Here is 
no place for ranting, but for critic.
I know some people are upset, but clarify it. For myself, i have also 
issues with pgAdmin4.
Thats why i switched to valentina studio. I can't use it in production 
right know.
Issues are for me slow query windows, disconnects, ha

[pgadmin-support] Error when editing data on a table

[Daniel Grace]

I am using pgAdmin 1.22.0.  Often when editing data on a table via the
"view the data in the selected object" icon, I get the error:

ASSERT INFO:
../src/common/wincmn.cpp(478): assert "GetEventHandler() == this" failed in
~wxWindowBase(): any pushed event handlers must have been removed

BACKTRACE:
[1] wxWindowBase::~wxWindowBase()
[2] wxStyledTextCtrl::~wxStyledTextCtrl()
[3] wxWindowBase::Destroy()
[4] wxWindowBase::DestroyChildren()
[5] wxWindow::~wxWindow()
[6] wxWindowBase::Destroy()
[7] wxWindowBase::DestroyChildren()
[8] wxWindow::~wxWindow()
[9] wxString wxString::Format(wxFormatString const&, wxString)
[10] wxWindowBase::Destroy()
[11] wxWindowBase::DestroyChildren()
[12] wxWindow::~wxWindow()
[13] wxString wxString::Format(wxFormatString const&, wxString)
[14] wxString wxString::Format(wxFormatString const&, wxString)
[15] wxAppConsoleBase::DeletePendingObjects()
[16] wxAppConsoleBase::ProcessIdle()
[17] wxAppBase::ProcessIdle()
[18] wxApp::DoIdle()
[19] g_main_context_dispatch
[20] g_main_loop_run
[21] gtk_main
[22] wxGUIEventLoop::DoRun()
[23] wxEventLoopBase::Run()
[24] wxAppConsoleBase::MainLoop()
[25] wxEntry(int&, wchar_t**)
[26] __libc_start_main

Is this a bug in the pgAdmin software or is something awry in my
configuration?

Thanks,
Daniel

bug ins installation of Migration PlugIn

[Daniel F. Gaspary]

Hello, 
I've downloaded the pgmigration-1_2_0.zip and followed the 
instructions to install it: regsvr32 "C:\Program 
Files\pgAdmin2\Plugins\pgMigration.dll".

But now, when i use the pgAdmin just the "Connection Debug Tools"  
appears in the plugins menu. I'm Using Windows 2000 professional, I 
imagine that is the cause of the problems.

Well, how can I fix the problems ??


Whats the right procedure to install the plugin on windows 2000??




Daniel


p.s.: Sorry, my english is terrible, I know. :)

[pgadmin-support] download broken

[Armbrust, Daniel C.]

The download for pgAdminII v1.3.60 (Alpha release) on 
http://pgadmin.postgresql.org/downloads/ is broken.

The zip file gives a crc error when you try to unzip it.



*
Daniel C. Armbrust 
Medical Informatics Research 
Information Services 
Mayo Clinic Rochester 
*

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

http://archives.postgresql.org

[pgadmin-support] BUG - does not handle empty strings properly

[Armbrust, Daniel C.]

Database Migration Wizard Plugin for pgAdmin II 1.2.0 does not properly handle empty 
strings from an MS Access Database.

When processing a column with a data type of Text, which is required but allows 0 
length fields, and it encounters an empty string "", instead of passing the value as 
"", it just leaves out that column, which causes the database to try to set it to 
NULL, but NULL is not a legal value for the column.



*****
Daniel C. Armbrust 
Medical Informatics Research 
Information Services 
Mayo Clinic Rochester 
*


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[pgadmin-support] download broken

[Armbrust, Daniel C.]

The download for pgAdminII v1.3.60 (Alpha release) on 
http://pgadmin.postgresql.org/downloads/ is broken.

The zip file gives a crc error when you try to unzip it.



*
Daniel C. Armbrust 
Medical Informatics Research 
Information Services 
Mayo Clinic Rochester 
*

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [pgadmin-support] download broken

[Armbrust, Daniel C.]

Sorry, you are correct.  It turns out, for some reason Mozilla (my browser of choice) 
is corrupting the file on download.  It works when I downloaded it with IE.  

Strange, I was able to download v1.2.0 using Mozilla without an issue.  I guess its 
time to report a bug to a different list.


*
Daniel C. Armbrust 
Medical Informatics Research 
Information Services 
Mayo Clinic Rochester 
*


-Original Message-
From: Dave Page [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 14, 2002 2:51 AM
To: Armbrust, Daniel C.; [EMAIL PROTECTED]
Subject: RE: [pgadmin-support] download broken




> -Original Message-
> From: Armbrust, Daniel C. [mailto:[EMAIL PROTECTED]] 
> Sent: 13 August 2002 22:30
> To: [EMAIL PROTECTED]
> Subject: [pgadmin-support] download broken
> 
> 
> 
> 
> The download for pgAdminII v1.3.60 (Alpha release) on 
> http://pgadmin.postgresql.org/downloads/ is > broken.
> 
> The zip 
> file gives a crc error when you try to unzip it.

I just downloaded it myself and it unzips fine using Winzip 8. Can you
try downloading again in case it corrupted along the way.

Regards, Dave.

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

[pgadmin-support] migration problems with 1.3.60 alpha + gui issues

[Armbrust, Daniel C.]

When attempting to migrate a set of tables from an access database using version 
1.3.60 alpha, According to the log file, the following SQL was generated:

SELECT MAX(`OID_key`) AS RECCOUNT FROM `OID_root`CREATE SEQUENCE 
"OID_root_OID_key_key" START 356

Notice the back ticks (`) around OID_key.  These promptly cause an error (illegal 
syntax I think it was?) which causes an abort and a rollback of the migration.

This works with version 1.2.0.

Additionally, in version 1.3.60 alpha, when I launch the program, the lower right pane 
where "Definition" is does not get painted until I click on something that causes data 
to go there.  It stays transparent at first (I can see my desktop through it)

Last:
In version the new version, when I connect to my database, it doesn't show me any of 
my tables with the new version.  I believe that this may have something to do with the 
fact that my table names contain capital letters (I'm new to postgres, is uppercase 
and postgres a bad thing?) - however, this works in the old version.  I'm currently 
testing the capital letter theory.  It appears that the calls must be surrounded in 
quotes?  And the new version is not doing it?






*
Daniel C. Armbrust 
Medical Informatics Research 
Information Services 
Mayo Clinic Rochester 
*

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Re: [pgadmin-support] pgAdmin 1.3.76

[Armbrust, Daniel C.]

Thanks Dave!  I checked my following previously reported errors against the new 
current version:

* SELECT MAX(`OID_key`) AS RECCOUNT FROM `OID_root`CREATE SEQUENCE 
"OID_root_OID_key_key" START 356
* Notice the back ticks (`) around OID_key.  These promptly cause an error (illegal 
syntax I think it was?) 
* which causes an abort and a rollback of the migration.

This bug magically disappeared with this version


* In version the new version, when I connect to my database, it doesn't show me any of 
my tables with the 
* new version.  I believe that this may have something to do with the fact that my 
table names contain 
* capital letters

This was never a bug... (darn blind users reporting bugs that didn't really exist)... 
they were hiding under the schema... : )

*Database Migration Wizard Plugin for pgAdmin II 1.2.0 does not properly handle empty 
strings from an MS 
* Access Database.
* When processing a column with a data type of Text, which is required but allows 0 
length fields, and 
* it encounters an empty string "", instead of passing the value as "", it just leaves 
out that column,
* which causes the database to try to set it to NULL, but NULL is not a legal value 
for the column.

Fixed.  Works perfectly for me now.


* The download for pgAdminII v1.3.60 (Alpha release) on 
* http://pgadmin.postgresql.org/downloads/ is > broken.
* 
* The zip 
* file gives a crc error when you try to unzip it.

This turns out to be some sort of odd error with Mozilla, however, both version 1.2 
and 1.3.76 work fine when downloaded with mozila.  I reported it to Mozilla, and while 
it was not previously unheard of, most people reported back wfm (works for me)


*
Daniel C. Armbrust 
Medical Informatics Research 
Information Services 
Mayo Clinic Rochester 
*


-Original Message-
From: Dave Page [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 19, 2002 9:02 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: pgAdmin 1.3.76


I'm pleased to announce the release of pgAdmin II 1.3.76. This is the
second release from the 1.3 development code.

pgAdmin II is an open source PostgreSQL database design and management
tool for Windows platforms. Further information and downloads can be
found at http://www.pgadmin.org/.

This release includes extensive changes to support schemas in the
upcoming 7.3 release of PostgreSQL. Testing on both current and
development versions of PostgreSQL is encouraged - any bug reports
should be sent to the support mailing list:
[EMAIL PROTECTED]

Changes in this release include:

- Fixed a bug that attempted to access inaccessible databases when
clicked on in the treeview.
- Use doubles instead of longs to cope with very large OIDs.
- Fixed a bug that caused an error if the pgAdmin window was too small
when the listview was populated.
- Don't class 'public' as a system schema.
- Don't throw an error when changing Not Null/Primary Key on a new
column in an existing table.
- Don't allow (attempted) alteration of certain column attributes in
PostgreSQL 7.2.
- Fixed some errors in the function editor.
- Raise errors properly from pgSchema.
- Only quote identifiers in datagrid update queries when required.
- Allow use of numeric identifiers.
- Fixed a bug that prevented renaming columns.
- Fixed an error that occured when clicking on the Relationships node
under a Foreign Key.
- Fixed a bug that prevented updating of Sequence values.
- Display object counts in the treeview immediately now we know them in
advance.
- Handle dates/time formats supported by Windows, not just those
supported by PostgreSQL (particuarly those that use . seperators)
- Allow use of F5 to execute SQL queries (Andy Kelk).
- If SQL is highlighted in the SQL textbox, execute only that, not the
whole query (Andy Kelk).
- Fixed a bug where an SQL file got overwritten if the user clicked
'Cancel'.
- Added DROP COLUMN support (Wahoo!).
- Don't display ON UPDATE/ON DELETE clauses in Foreign Keys if
unspecified.
- Fixed broken error handling in pgSchema.

The Migration Wizard (distributed seperately under GPL) has also been
updated:

- Correctly clear CREATE SEQUENCE sql. [John McCawley]
- Check the Migration type in a more sensible way. [John McCawley]
- Insert empty values correctly to avoid errors by not inserting into
NOT NULL columns.

Regards, Dave.

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Re: [pgadmin-support] Import

[Armbrust, Daniel C.]

Check out your logging:

Tools-> Options->Logging

The default level of Errors and SQL queries will probably be enough to sort out what 
is going on, but if not, you can up it to Debug or Full Debug, rerun the export, and 
then view the log file.




*
Daniel C. Armbrust
Medical Informatics Research
Information Services
Mayo Clinic Rochester
*


-Original Message-
From: Willem Luijk [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 27, 2002 1:36 PM
To: [EMAIL PROTECTED]
Subject: [pgadmin-support] Import


Can anynone help me with the import wizard?
I import to a table with 2 fields: 
name varchar 60
abbrev varchar 3

The data looks like
dut^Dutch ^
ita^Italian  ^
etc

The import went well but encounters 1 problem (no description)
and is rolled back without reason!

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

[pgadmin-support] Add a user to a group of tables?

[Armbrust, Daniel C.]

Is there a quick way to give a user permissions on multiple tables at once?

*
Daniel C. Armbrust 
Medical Informatics Research 
Information Services 
Mayo Clinic Rochester 
*

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [pgadmin-support] Add a user to a group of tables?

[Armbrust, Daniel C.]

Wow, one would think I would notice the Security Wizard

so nevermind my silly question.


*
Daniel C. Armbrust 
Medical Informatics Research 
Information Services 
Mayo Clinic Rochester 
*


-Original Message-
From: Armbrust, Daniel C. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 11:39 AM
To: [EMAIL PROTECTED]
Subject: [pgadmin-support] Add a user to a group of tables?


Is there a quick way to give a user permissions on multiple tables at once?

*
Daniel C. Armbrust 
Medical Informatics Research 
Information Services 
Mayo Clinic Rochester 
*

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [pgadmin-support] unsubscribe

[Armbrust, Daniel C.]

Maybe some of you "unsubscribe" fools could take the time to actually use the web.

http://pgadmin.postgresql.org/pgadmin2.php?ContentID=4

It took me all of 2 seconds to find the instructions for how to unsubscribe.
A direct link off the front page.  Wow.  That was hard.

Since you are apparently too lazy to even do that, I'll make it even easier for you.  
Quoting from the page:

" This is the primary support list intended for end user support & bug reports. To 
subscribe to this list, send an email to [EMAIL PROTECTED] with 
the word 'subscribe' (without the quotes) as the body of message.

To unsubscribe from a list, follow the procedure for subscribing but use 'unsubscribe' 
in the message body instead of 'subscribe'."


Notice how you sent the mail to [EMAIL PROTECTED]



-Original Message-
From: K Anderson [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, December 03, 2002 1:43 AM
To: [EMAIL PROTECTED]
Subject: [pgadmin-support] unsubscribe


unsubscribe

Ok, I tried unsubscribing from this group with no luck. Could somebody remove me 
please.

THank you.
-- 

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[pgadmin-support] Security settings

[Armbrust, Daniel C.]

I've managed to mess up the permissions on all of the tables in one of my 
databases One way or another.  I'm not sure of the actual sequence of events, but 
I think that a user of the database got deleted, while it was set as having privileges 
on these tables.  Ever since then, things have been not quite right.

When I try to open the properties pane in pgadmin 2, I get the following error:

-- Error Information --

Description:Element not found
Number: 35601
Routine:pgAdmin II:frmTable.Initialise

And then I can continue,  but it doesn't show me any of the assigned security info for 
the table.

At the command line, here are the permissions:
plesionym-# \dp
 Access privileges for database "plesionym"
 Schema | Table | Access privileges
+---+---
 public | mtstb_plesmnt_context | {=,mirpub=r}
 public | mtstb_plesmnt_edit_session| {=,mirpub=r}
 public | mtstb_plesmnt_phrase  | {=,mirpub=r}
 public | mtstb_plesmnt_phrase_relation | {=,mirpub=r}
 public | mtstb_plesmnt_phrase_type | {=,mirpub=r}
 public | mtstb_plesmnt_source  | {=,mirpub=r}


If I try to do the same thing in pgadmin 3 I don't get any errors, and it shows me the 
proper security.  However, I do get an error here if I try to change any of the 
security settings.  I get
"ERROR: parser: parser error at or near "ALL" at character 58"

Can someone give me an idea of how to fix this? 

Thanks, 

Dan

---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings

Re: [pgadmin-support] Security settings

[Armbrust, Daniel C.]

I got the error figured out this morning... The clients were having issues, because 
the user that was removed was the owner of the tables.  So, the tables effectively had 
no owner, causing pgadmin do have different issues in different versions.

I was able to get it fixed (only with the new pgadmin however - the old one barfed to 
bad)

It does bring up what I would call a bug, however... Probably in the database, 
however, and not the gui.

I would think that you should not be able to remove a user from a database if that 
user owns tables.
Furthermore, if you remove a user, that user should have all of its security entries 
removed from all tables.

Dan

ps - sorry for the private mail Dave, all of the other mailing lists I am on change 
the Reply to to point back to the list, rather than the sender.


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

[pgadmin-support] trying to import mysql database - crash

[Armbrust, Daniel C.]

Title: Message



I'm trying to copy a 
database from mySql to postgres - I'd like to compare their performance in a 
specific application.
 
I'm trying to use 
the database migration wizard in pgadmin 1.6.0.  (Is there a better way 
to duplicate this database across?)  Right after I click next after 
specifying the odbc database, pgadmin ungracefully crashes.  And its not 
the new error catcher either, is the system level crash 
notification.
 
Here is all I can 
get out of a full debug log:
 
2003-08-04 14:36:29 
- Entering pgAdmin II:frmMain.mnuPluginsPlg_Click(4)2003-08-04 14:36:29 - 
Entering pgAdmin II:clsPlugins.Property Get Item("Database Migration 
Wizard")2003-08-04 14:36:29 - Entering pgAdmin II:clsPlugins.Property Get 
Item("Database Migration Wizard")2003-08-04 14:36:29 - Executing Plugin: 
Database Migration Wizard v1.6.02003-08-04 14:36:29 - Entering pgAdmin 
II:clsPlugins.Property Get Item("Database Migration Wizard")2003-08-04 
14:36:29 - Entering Database Migration 
Wizard:frmWizard.Initialise()2003-08-04 14:36:30 - Entering Database 
Migration Wizard:frmWizard.optType_Click()2003-08-04 14:36:44 - Entering 
Database Migration Wizard:frmWizard.cmdNext_Click()2003-08-04 14:36:44 - 
Entering Database Migration Wizard:frmWizard.dbConnect()2003-08-04 14:36:44 
- Opening and Examining Source Database...2003-08-04 14:36:44 - Opening DSN: 
mysql lvg2003-08-04 14:36:44 - Entering Database Migration 
Wizard:frmWizard.GetQuoteChar("DSN=mysql 
lvg;UID=mirpub;PWD=mirpub")
 
Help 
?
 
Thanks, 

 
Dan

[pgadmin-support] Implementing Replication via pgAdmin

[Daniel B. Thurman]

I have tried to follow the pgAdmin slony support in the help sections
of pgAdmin and it seems to be inconsistent.  For example, it is not
intuitively clear from the help sections how exactly to setup the master
and slave configurations.  From a windows client perspective, it seems
that one must use command-line operations in order to setup the slony
services, create and configure the configuration files, and then try to use
the pgAdmin replication objects to define the master/slave relationships?

Since it is possible to create new connections to all of the postgreSQL
servers within your network into the pgAdmin connections list, should it
also be possible to seamlessly perform (slony) replication for all of the
master/slaves databases with slony services automatically initialized and
completely within pgAdmin without having to resort to manual command-line
operations?

Perhaps this is already planned for future releases of pgAdmin?


No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.487 / Virus Database: 269.13.21/1012 - Release Date: 9/16/2007 
6:32 PM
 

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

Re: [pgadmin-support] Implementing Replication via pgAdmin

[Daniel B. Thurman]

Thanks Dave.

But I am having some trouble trying to get replication to work.

Here is what I did:

1) On master server:
   a) I registered: lib/slevent.dll
   b) I register as a service: slon -regservice
   c) slon -listengines
  2 engine(s) registered for service 'Slony-I'
  Engine 1: E:\Program Files\PostgreSQL\8.2\data\slon.conf
  Engine 2: E:\Program Files\PostgreSQL\8.2\data\master.conf
   d) Started the slon service via manage->services

2) On Slave Server
   a) I registered: lib/slevent.dll
   b) I register as a service: slon -regservice
   c) slon -listengines
  2 engine(s) registered for service 'Slony-I'
  Engine 1: E:\Program Files\PostgreSQL\8.2\data\slon.conf
  Engine 2: E:\Program Files\PostgreSQL\8.2\data\slave.conf
   d) Started the slon service via manage->services

3) Launched: pgAdmin3 (v1.6.2)
   a) Created Master Server Connection
   b) Selected database: MyTest
   c) Right-clicked Replication object, selected from menu: New slony-I Cluster 
...
   d) Join existsing cluster: [unchecked]
  Server:  [Greyed out]
  Database: MyTest [Entered data]
  Cluster Name: -Master-Cluster [entered data]
  Local Node: 1,  Value: "Master Node" [entered data]
  Admin Node: 99, Value: "pgAdmin Node" [entered data]
  Comment:  [no data entered]
   d) Clicked OK and Completed structure shows:
  -Master-Cluster
Nodes (2)
  Master Node
Paths (0)
listens (0)
  pgAdmin Node
Paths (1)
  Master Node
listens (1)
  Master Node (Master Node)
Replication Sets (0)

At this point, I tried to add a slave node but was unable to:
a) I tried (on Master server) connection:
  1) Right-clicked Replication object, selected from menu: New slony-I 
Cluster ...
  2) Join existing cluster: [checked]
 Server: Master-Server-Name [no change]
 Database: MyTest [no change]
 Cluster-name: 
 Local Node: 2, Value: "Slave Node" [entered data]
 Admin node: "99 - pgAdmin Node" [no change]
 Comment:  [no data entered]
  3) Clicked OK and...
 "An error has occurred:
  ERROR: schema "_-Master-Cluster" already exists
 "

  So, perhaps I should not have added a join here, in the master server 
connection,
  so I clicked CANCEL

b) Then I tried (on Slave Server) connection:
  1) Right-clicked Replication object, selected from menu: New slony-I 
Cluster ...
  2) Join existing cluster: [checked]
 Server:  [Initially was Greyed out, but active 
after a delay]
 Database: MyTest [unchanged]
 Cluster Name:  [dropdown shows empty list and not selecteable]
 Local Node: , Value: 
 Admin Node: , Value: 
 Comment: 

  At this point, it makes no sense to enter any fields after 'Cluster Name' 
since
  the 'Cluster Name' must have a value and 'OK' remains greyed out.

So I am at loss to go any further...

Any advice?

>-Original Message-
>From: Dave Page [mailto:[EMAIL PROTECTED]
>Sent: Monday, September 17, 2007 8:58 AM
>To: Daniel B. Thurman
>Cc: Pgadmin-Support (E-mail)
>Subject: Re: [pgadmin-support] Implementing Replication via pgAdmin
>
>
>Daniel B. Thurman wrote:
>> I have tried to follow the pgAdmin slony support in the help sections
>> of pgAdmin and it seems to be inconsistent.  For example, it is not
>> intuitively clear from the help sections how exactly to 
>setup the master
>> and slave configurations.  From a windows client 
>perspective, it seems
>> that one must use command-line operations in order to setup the slony
>> services, create and configure the configuration files, and 
>then try to use
>> the pgAdmin replication objects to define the master/slave 
>relationships?
>
>Yes.
>
>> Since it is possible to create new connections to all of the 
>postgreSQL
>> servers within your network into the pgAdmin connections 
>list, should it
>> also be possible to seamlessly perform (slony) replication 
>for all of the
>> master/slaves databases with slony services automatically 
>initialized and
>> completely within pgAdmin without having to resort to manual 
>command-line
>> operations?
>
>The slon daemon (on *nix) or service & engines (on Windows) must be
>configured from the command line. pgAdmin makes no attempt to do this
>because that is entirely OS dependent (in fact, it is distribution
>dependent because, for example, Redhat and Slackware start daemons in
>entirely different ways). In addition, you may not even want 
>to run slon
>on the machine that you're running pgAdmin on, or even that you're
>running the d

[pgadmin-support] pgAdmin3, v1.8.0 BETA-5

[Daniel B. Thurman]

As recommended, I downloaded and installed pgAdmin v1.8.0-beta5
and ran into some problems:

1) The update.bat script failed to update the v1.6.3 release that came
integrated with the postgreSQL v1.8.2 release.  Failing that, I proceeded
to install the complete program into a seperate directory.

2) The 'About' menu showed the logo with the version properly but was missing
 the dialog window, so I was not able to close it.

Thats it for now...


No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.487 / Virus Database: 269.13.21/1012 - Release Date: 9/16/2007 
6:32 PM
 

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

Re: [pgadmin-support] pgAdmin3, v1.8.0 BETA-5

[Daniel B. Thurman]

Uh, forgot to also mention that the pgAdmin exe icon is missing
and shows some sort of an image but not that of ol' ele ;)

>-Original Message-
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED] Behalf Of Daniel B.
>Thurman
>Sent: Monday, September 17, 2007 2:50 PM
>To: Pgadmin-Support (E-mail)
>Subject: [pgadmin-support] pgAdmin3, v1.8.0 BETA-5
>
>
>
>As recommended, I downloaded and installed pgAdmin v1.8.0-beta5
>and ran into some problems:
>
>1) The update.bat script failed to update the v1.6.3 release that came
>integrated with the postgreSQL v1.8.2 release.  Failing 
>that, I proceeded
>to install the complete program into a seperate directory.
>
>2) The 'About' menu showed the logo with the version properly 
>but was missing
> the dialog window, so I was not able to close it.
>
>Thats it for now...
>
>
>No virus found in this outgoing message.
>Checked by AVG Free Edition. 
>Version: 7.5.487 / Virus Database: 269.13.21/1012 - Release 
>Date: 9/16/2007 6:32 PM
> 
>
>---(end of 
>broadcast)---
>TIP 2: Don't 'kill -9' the postmaster
>
>No virus found in this incoming message.
>Checked by AVG Free Edition. 
>Version: 7.5.487 / Virus Database: 269.13.21/1012 - Release 
>Date: 9/16/2007 6:32 PM
> 
>

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.487 / Virus Database: 269.13.21/1012 - Release Date: 9/16/2007 
6:32 PM
 

---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

Re: [pgadmin-support] Implementing Replication via pgAdmin

[Daniel B. Thurman]

>> Thanks Dave.
>> 
>> But I am having some trouble trying to get replication to work.
>> 
>> Here is what I did:
>> 
>> 1) On master server:
>>a) I registered: lib/slevent.dll
>>b) I register as a service: slon -regservice
>>c) slon -listengines
>>   2 engine(s) registered for service 'Slony-I'
>>   Engine 1: E:\Program Files\PostgreSQL\8.2\data\slon.conf
>>   Engine 2: E:\Program Files\PostgreSQL\8.2\data\master.conf
>>d) Started the slon service via manage->services
>> 
>> 2) On Slave Server
>>a) I registered: lib/slevent.dll
>>b) I register as a service: slon -regservice
>>c) slon -listengines
>>   2 engine(s) registered for service 'Slony-I'
>>   Engine 1: E:\Program Files\PostgreSQL\8.2\data\slon.conf
>>   Engine 2: E:\Program Files\PostgreSQL\8.2\data\slave.conf
>>d) Started the slon service via manage->services
>
>Why did you register 2 engines on each? For a simple master-slave setup
>you would only need one engine for the master and one for the slave.
>

Because I did not know what I was doing. FYI: For the master and the slave
the configuration is taken directly from the slon-sample.conf CVS area and
I made no changes to it.  It turns out that the master.conf and slave.conf
was perhaps for an old version and caused errors to the slon service on the
slave and thus removing slave.conf from the service reported no more errors.
The error reported was that the service was not able to connect to the local
database, fwiw.

I am assuming that there is nothing needed to be changed to the config file
(all of the entries are commented out by default).  Restarting both the master
and slave service reports no errors at this time.

>> 3) Launched: pgAdmin3 (v1.6.2)
>
>You might want to try 1.8 beta 5. There have been some useful
>improvements to the Slony code.
>
>>a) Created Master Server Connection
>>b) Selected database: MyTest
>>c) Right-clicked Replication object, selected from menu: 
>New slony-I Cluster ...
>>d) Join existsing cluster: [unchecked]
>>   Server:  [Greyed out]
>>   Database: MyTest [Entered data]
>>   Cluster Name: -Master-Cluster [entered data]
>>   Local Node: 1,  Value: "Master Node" [entered data]
>>   Admin Node: 99, Value: "pgAdmin Node" [entered data]
>>   Comment:  [no data entered]
>>d) Clicked OK and Completed structure shows:
>>   -Master-Cluster
>> Nodes (2)
>>   Master Node
>> Paths (0)
>> listens (0)
>>   pgAdmin Node
>> Paths (1)
>>   Master Node
>> listens (1)
>>   Master Node (Master Node)
>> Replication Sets (0)
>
>OK.
>
>> At this point, I tried to add a slave node but was unable to:
>> a) I tried (on Master server) connection:
>
>Setup the slave on the slave, not the master.
>
>> 
>> b) Then I tried (on Slave Server) connection:
>>   1) Right-clicked Replication object, selected from 
>menu: New slony-I Cluster ...
>>   2) Join existing cluster: [checked]
>>  Server:  [Initially was Greyed 
>out, but active after a delay]
>>  Database: MyTest [unchanged]
>>  Cluster Name:  [dropdown shows empty list 
>and not selecteable]
>>  Local Node: , Value: 
>>  Admin Node: , Value: 
>>  Comment: 
>> 
>>   At this point, it makes no sense to enter any fields 
>after 'Cluster Name' since
>>   the 'Cluster Name' must have a value and 'OK' remains 
>greyed out.
>

Oh bust my knuckles.  NOW I understand what is going on!  I did
not realize that I needed to change the Server: 
dropdown to that of the MASTER-SERVER-NAME for which I wanted to add
my slave DB to.  Uh, duhoh!

Now I am able to join the slave to the master cluster.

>
>Yeah, iirc that could happen on earlier versions of pgAdmin. Install a
>copy of 1.8 beta 5 (it'll install alongside your current copy) and try
>that. It should work more as you would expect.
>
>Regards, Dave.

But uh, there is still another problems for me...

I changed an entry in the myTest database table and I do not see this value
replicated to the slave db.  Is there something more I need to do after coming
this far along?

So far I see:

   On Master Server:
   -Master-Cluster
 Nodes (3)
   Master Node
 Paths (0)
 listens (0)
   Slave Node
 Paths (0)
 listens (0)
   pgAdmin Node
 Paths (2)
   Master Node
   Slave Node
 listens (2)
   Master Node (Master Node)
   Slave Node (Slave Node)
 Replication Sets (0)

   On Slave Server:
   -Master-Cluster
 Nodes (3)
   Master Node
 Paths (0)
 listens (0)
   Slave Node
 Paths (0)
 listens (0)
   pgAdmin Node
 Paths (1)
   Master Node
 listens (1)

Re: [pgadmin-support] pgAdmin3, v1.8.0 BETA-5

[Daniel B. Thurman]

>
>Daniel B. Thurman wrote:
>> Uh, forgot to also mention that the pgAdmin exe icon is missing
>> and shows some sort of an image but not that of ol' ele ;)
>
>What colour depth is your display running at? Can you post a small
>screenshot?
>
>Thanks, Dave
>

My Color depth is 32 bits, or 16.7M colors.
Screen Res is 1600x1200

Attached is the image, in jpeg format.


No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.487 / Virus Database: 269.13.22/1013 - Release Date: 9/17/2007 
1:29 PM
 
  
<>
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

Re: [pgadmin-support] Implementing Replication via pgAdmin

[Daniel B. Thurman]

I have gone over the following document:
http://www.slony.info/documentation/firstdb.html

To get some idea of what is going on (at the manual level)
as to how replication services works.  From what I have done,
was to manually start the slon for the master and server sides
the following:

MASTER:
1) Set the privileges for the MyTest database so as to allow
   postgres user to access the table completely (ALL)
2) In the windows command window:
   a) set path variable to include the path to postgreSQL/bin
   b) set PGUSER=postgre
   c) set PGPASSWORD=*
   d)
slon Copper-Master-Cluster dbname=MyTest user=postgres host=copper.cdkkt.com

[I found initially tho, that slon complained that myTest did not exist, and I
 found that my entries in BOTH of server sides in the Replication tree contained
 a couple of dbname=myTest when they should have been dbname=MyTest (I did not
 know they were case sensitive), so I updated the entries via pgAdmin interface
 to proper values, then retried slon again, and the errors disappeared!]

SLAVE:
1) Set the privileges for the MyTest database so as to allow
   postgres user to access the table completely (ALL)
2) In the windows command window:
   a) set path variable to include the path to postgreSQL/bin
   b) set PGUSER=postgre
   c) set PGPASSWORD=*
   d)
slon Copper-Master-Cluster dbname=MyTest user=postgres host=raider.cdkkt.com

[I found an error reported for "duplicate key" violation on 
sl_table_tab_reliod_key
 and I compared the value of 18989 against that of the master side and the value
 there was found to be: 18988.  So I updated the slave side value to 18988 to 
match,
 updated the table, and the error disappeared and replication went on smoothly!]

I found that, if PGPASSWORD was not supplied, the connection will fail since 
slon
could not find the password, even if I provided the .pgpass file with the 
correct
information.

I had tested replication by changing a value in one of the columns in the 
MyTest.car
table and lo' and behold!  The slave server's MyTest table was updated!  For 
fun, I
also tried the converse, to change a value in the slave side table and the 
master car
table was not updated (as expected).

Now... here comes the hard part...

How to I put this slon replication service "into the background" on windows or
more to the point, how do I normally start the replication process normally (as
a service?) and not manually as I have done in the above steps?

I noticed that if I tried to "start" the replication via pgAdmin3 w/o having the
slon programs running by selecting: "Restart Node" menu item when slon 
replication
programs are not running on either the master or slaves, it would simply pop up 
an
error message saying that the replication services are not 'running'.  Shouldn't
there be some sort of a 'Start Node', 'Stop Node' type of menu item or what?

Again, what is the proper way to start the replication service w/o having to 
open
a command window and manually start it in the manner as I have done above?

Thanks!
Dan

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.487 / Virus Database: 269.13.22/1013 - Release Date: 9/17/2007 
1:29 PM
 

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly

[pgadmin-support] Seems that majordomo stopped working for pgAdmin-support?

[Daniel B. Thurman]

For some reason, I sent a post and it has never reached the pgAdmin-support
site, nor have I been receving any more new or replied postings?  I noticed this
problem occurred yesterday (9/18/07) somtime in the afternoon (~1:00PM PST)?

Thanks -
Dan

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.487 / Virus Database: 269.13.22/1015 - Release Date: 9/18/2007 
11:53 AM
 

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

Re: [pgadmin-support] [RESENT]Implementing Replication via pgAdmin

[Daniel B. Thurman]

>>> I changed an entry in the myTest database table and I do not 
>>> see this value replicated to the slave db.  Is there something
>>> more I need to do after coming
>>> this far along?
>>> 
>>> So far I see:
>>>   
>>> 
>>>   I am not sure where to look for any activities...
>>
>>I only see one listen on your slave. Make sure there is one there for
>>the master and not (just) the admin node.
>>
>>Regards, Dave.
>>
>
>I see that my Master and Slave replication process is not
>even running so at this point I am not sure how to start
>them running.  I have attached an image of my setup with
>full details and the file is a jpeg file of size 800K.
>
>Please review and let me know what I need to do.  The image
>shown has been static since yesterday and I have not done anything
>yet at this point.
>
>Thanks Dave!
>Dan

[RESEND]

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.487 / Virus Database: 269.13.22/1015 - Release Date: 9/18/2007 
11:53 AM
 

---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

Re: [pgadmin-support] Seems that majordomo stopped working for pgAdmin-support?

[Daniel B. Thurman]

>For some reason, I sent a post and it has never reached the 
>pgAdmin-support
>site, nor have I been receving any more new or replied 
>postings?  I noticed this
>problem occurred yesterday (9/18/07) somtime in the afternoon 
>(~1:00PM PST)?
>
>Thanks -
>Dan
>

I have received this message, but I resent what I thought I posted
but it did not appear and perhaps is blocked by majordomo due to an
attachment file that is too large?  I attached a jpeg image file that
was 830K in size?  Is there a size posting limit?

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.487 / Virus Database: 269.13.22/1015 - Release Date: 9/18/2007 
11:53 AM
 

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [pgadmin-support] Seems that majordomo stopped working forpgAdmin-support?

[Daniel B. Thurman]

>> >For some reason, I sent a post and it has never reached the 
>> >pgAdmin-support
>> >site, nor have I been receving any more new or replied 
>> >postings?  I noticed this
>> >problem occurred yesterday (9/18/07) somtime in the afternoon 
>> >(~1:00PM PST)?
>> >
>> >Thanks -
>> >Dan
>> >
>> 
>> I have received this message, but I resent what I thought I posted
>> but it did not appear and perhaps is blocked by majordomo due to an
>> attachment file that is too large?  I attached a jpeg image file that
>> was 830K in size?  Is there a size posting limit?
>
>Yes thankfully - it's around 40K iirc. I would be somewhat less than
>inclined to help had I had to download an unsolicited image of 
>that size
>on my pda (on which I regularly read email).
>
>If you need to provide images of that size, please bung them on a
>website and provide a link to them (with an appropriate warning). 
>
>What the heck is it anyway? 830K is one helluva size for a 
>screenshot...
>
>Regards, Dave.
>

I send an elaborate configuration image of the pgAdmin setup with all
the properties show for both the Master and Slave.  I was hoping that
you could see what I had done as far as setting things up.  I was also
hoping that this might aide others who may be trying to see the setup
for what it should/might be?  Perhaps this is over-the-top but I am
trying to figure out how to setup the replication implementation.

So far, I did get the (manual) slons working but as posted as a follow
up, I am having all sorts of issues now.

The problems I have encountered:

1) I was unable to run slonik with the configuration file that had the
   Cluster Name = Copper-Master-Cluster entry because I *think* that
   slonik did not like '-'.  So I ended up terminating the manually
   running slons, deleted the Replication for the master side, and
   attempted to do the same for the slave side, and I discovered that
   I was not allowed to do that because there was an error message saying
   that I was not allowed to delete the replication sets because there
   was a dependency issue that being it was a provider?

   So I went the whole hog trying to find every entry in the replication
   structure and tried to delete the listeners, the nodes, etc. and again
   was not able to because of another dependency (the replication sets),
   so it turned out to be circular.  Giving up, I ended up deleting the
   entire slave-side database, rebuilt it, and then was able to define a
   new Cluster Name but without the '-' in the name.

2) Now at this point, I am still having a problem trying to figure out why
   I am unable to get replication to work with the slons running.  I see no
   errors reported from the debug strings on both master/slave sides and the
   odd thing here is that, I tried to update an entry in the Master-side 
database
   for the MyTest.cars table and I get an error reporting: "An error has 
occurred:
   ERROR: Slony-I: Table cars is replicated and cannot be modified on a 
subscriber
   node"...

   The odd thing here (maybe?) that I was previously unable to define a new 
sequence
   because there was nothing available in the Sequence dropdown list, so I 
ignored
   this and proceeded to create a subscrition anyway.

   Again, once the subscription is created, I cannot 'start over' and delete 
the entire
   replication set both for the master and slave sides.

   Very odd, so it seems

   But then again, I am a newbie ;)

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.487 / Virus Database: 269.13.22/1015 - Release Date: 9/18/2007 
11:53 AM
 

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

Re: [pgadmin-support] Implementing Replication via pgAdmin

[Daniel B. Thurman]

As suggested by Dave,

The following link is a jpeg File, size 274K, showing the
pgAdmin3 setup I have so far.  Note that there are a couple
of problems already found:

1) The Cluster name is now: CopperMasterCluster.  I think that
   slonik does not like '-' characters.

2) The entries for dbname have all been updated to the correct
   case-sensitive names, ie, all 'myTest' are all 'MyTest'.
   I found these problems when I ran slon in the command windows
   for the master and slave and in debug mode, and there was connection
   errors reported.  This is all fixed now.

http://www.cdkkt.com/images/pgAdmin/Master-Slave.jpg

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.487 / Virus Database: 269.13.22/1015 - Release Date: 9/18/2007 
11:53 AM
 

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

Re: [pgadmin-support] Implementing Replication via pgAdmin

[Daniel B. Thurman]

>> >I see that my Master and Slave replication process is not
>> >even running so at this point I am not sure how to start
>> >them running.  
>
>Are the slons running? They should be started from the Services control
>panel applet after the engines are registered. When they are, check the
>connections on each server to ensure they have actually connected. If
>not, check the log files/event log for error messages to see 
>why not. If
>required, modify the config files or pgpass files are required and
>restart the slons.
>
>If they are connected and running, check that you have listens defined
>on each node in the cluster for every other node in the cluster (except
>the admin node).
>
>Regards, Dave.
>

Sigh, I am not getting anywhere, so it seems.

1) I have been able to completely reconstruct the replication
   structure using pgAdmin3
2) I was able to manually run on the Master server, in a command window:
   slon MasterCluster dbname=MyTest user=postgres host=copper.cdkkt.com

   But I noticed the error:
   "2007-09-19 17:42:39 Pacific Daylight Time ERROR  remoteWorkerThread_2:
"select "_MasterCluster".setAddTable_int(1, 3, '"public"."cars"',
'cars_pkey', ''); " PGRES_FATAL_ERROR ERROR:  Slony-I: setAddTable_int:
table id 3 has already been assigned!"

Ignoring this error for now,

3) I was able to manually run on the Slave server, in a command window:
   slon MasterCluster dbname=MyTest user=postgres host=copper.cdkkt.com
   [No errors reported]

4) Changed a value in MyTest.cars and it was successfully replicated to slave

5) Feeling that all was working, I proceeded on the master to run slonik:
   > slonik slonyReplication.txt
 [No errors reported]

   [File configuration is:
#--  This defines which namespace the replication system uses
cluster name = MasterCluster;

#-- Admin conninfo's are used by the slonik program to connect
#-- to the node databases.  So these are the PQconnectdb arguments
#-- that connect from the administrators workstation (where
#-- slonik is executed).
node 1 admin conninfo = 'dbname=MyTest host=copper.cdkkt.com user=postgres';
node 2 admin conninfo = 'dbname=MyTest host=raider.cdkkt.com user=postgres';

#-- Node 2 subscribes set 1
subscribe set ( id = 1, provider = 1, receiver = 2, forward = yes);
   ]

6) Proceeded on the slave to run slonik:
   > slonik slonyReplication.txt
   [No errors reported]

   [Same file configuration as above]

7) Restared master and slave services

8) Ran pgAdmin3 and noticed:

   on MASTER:
   a) Master Node: Running PID: not running
   b)  Slave Node: Running PID: administrative node

   on SLAVE:
   a) Master Node: Running PID: not running
   b)  Slave Node: Running PID: not running

   And of course, replication failed when a value is changed in MyTest.cars

9) So, I tried testing to see if the manually running slon on both
   servers would work showing:

   on MASTER:
   a) Master Node: Running PID: 1528
   b)  Slave Node: Running PID: administrative node

   on SLAVE:
   a) Master Node: Running PID: 1528
   b)  Slave Node: Running PID: 1752

   And of course, replication still fails.

   Seems that my running of slonik messed up the configuration
   as is shown where the slave Running PID = 'administrative node'

So -- what now?

What am I doing wrong with the slonik configuration file that so messed
it all up and is it possible to remove this configuration using pssql?

I know I can tear everything down again and start over, but I would end
up using manual slons.  Perhaps I do not have a good handle as to the
proper configuration files for slonik?

Thanks -
Dan

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.487 / Virus Database: 269.13.22/1015 - Release Date: 9/18/2007 
11:53 AM
 

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly

Re: [pgadmin-support] Implementing Replication via pgAdmin

[Daniel B. Thurman]

Configuring Replication on Windows,
using pgAdmin3 v8.0 Beta 5
==

On Master:
==
1) Adding a new Master Replication Set:
   a) Right-click 'Replication', and select: 'New slony-I Cluster...'
   b) UnCheck: Join existing cluster
   c) Enter: Cluster name: MasterCluster
   d) Enter: Local node: 1:  Master Node
   e) Enter: Admin node: 99: pgAdmin Node
   f) Click: OK

On Slave:
=
2) Adding a new Slave Replication Set:
   a) Right-click 'Replication', and select: 'New slony-I Cluster...'
   b) Check: Join existing cluster
  [wait for Server dropdown list to complete]
   c) Click Server dropdown list and select: 
  [Cluster name is filled automatically]
  [Database is filled automatically]
  [Admin Node   is filled automatically]
   d) Enter: Local node for slave: 2: Slave Node
   e) Click: OK

   Adding a new Master Path/listener:
   a) Refresh and expand all items in the Replication tree
   b) Right-click 'Path (0)', under 'Master Node'
and select: 'New Path' menu item
  [Server: '2 - Slave Node' appears]
  [Conn retry: '10' appears]
  Enter: Connect info:
 'host= dbname= user='
  Click: OK
   c) Click on Master Node: listens
  [Note that a master listener is automatically added]

   Adding a new Slave Path/Listeners:
   a) Right-click 'Path (0)', under 'Slave Node'
and select: 'New Path' menu item
  [Server: '1 - Master Node' appears]
  [Conn retry: '10'  appears]
  Enter: Connect info:
 'host= dbname= user='
  Click: OK
   b) Click on Slave Node: listens
  [Note that a slave listener is automatically added]

On Master:
==
3) Completely refresh the entire 'Replication' tree and expand fully.
   [Should see newly added sub-trees: 'Slave Node' and pgAdmin Node]

   Adding a new master Path/listeners:
   a) Right-click 'Path (0)', under 'Master Node'
and select: 'New Path' menu item
  [Server: '2 - Slave Node' appears]
  [Conn retry: '10' appears]
  Enter: Connect info:
 'host= dbname= user='
  Click: OK
   b) Click on Master Node: listens
  [Note that a listener is automatically added]

   Adding a new slave Path/listeners:
   a) Right-click 'Path (0)', under 'Slave Node'
and select: 'New Path' menu item
  [Server: '1 - Master Node' appears]
  [Conn retry: '10'  appears]
  Enter: Connect info:
 host= dbname= user='
  Click: OK
   b) Click on Slave Node: listens
  [Note that a listener is automatically added]

   Adding a new Replication Set:
  Right-click 'Replication Sets (0)' and select: 'New Replication Set'
  Enter: ID: '1'
  Enter: Comment: 'Hardware'
  Click: OK
  Fully expand tree: 'Replication Sets (1)'

   Adding a new table:
  Right click: 'Tables (0)' and select: 'New Table'
  Click table dropdown list and select: 
  Enter: ID: '1'
  Clieck: OK

   Adding a new sequence:
  Right-click 'Sequences (0)' and select: 'New Sequence'
  Click 'Sequence' dropdown list item.
  [This step does not work for me, as I find at this point,
   there are no sequence dropdown items so a sequence cannot
   be created at this point. Otherwise if you have a sequence
   dropdown item, continue...]
  Enter: ID: '2'
  Click: OK

   Adding a new Subscription:
  Right-click 'Subscriptions (0)' and select: 'New Subscription'
  [  Origin: '1',   appears]
  [Provider: '1 - Master Node', appears]
  [Reciever: '2 - Slave Node',  appears (a single item)]
  Check: 'Can forward' [If you want this.]
  Click: OK

   [At this point, you can check to see that 'Tables (1)' and
'Subscriptions (1)' can be expanded and contains sub-tree items
 so if desired, verify that your entries were properly set.]

On Slave:
=
   Adding a new Replication Set:
  Right-click 'Replication Sets (0)' and select: 'New Replication Set'
  Enter: ID: '1'
  Enter: Comment: 'Hardware'
  Click: OK
  Fully expand tree: 'Replication Sets (1)'

   Adding a new table:
  Right click: 'Tables (0)' and select: 'New Table'
  Click table dropdown list and select: 
  Enter: ID: '1'
  Clieck: OK

   Adding a new sequence:
  Right-click 'Sequences (0)' and select: 'New Sequence'
  Click 'Sequence' dropdown list item.
  [This step does not work for me, as I find at this point,
   there are no sequence dropdown items so a sequence cannot
   be created at this point. Otherwise if you have a sequence
   dropdown item, continue...]
  Enter: ID: '2'
  Click: OK

   Adding a new Subscription:
  Right-click 'Subscriptions (0)' and select: 'New Subscription'
  [  Origin: '2',   appears]
  [Provider: '2 - Slave Node',  appears]
  [Reciever: '1 - Master Node', appears (single item)]
  Check: 'Can fo

Re: [pgadmin-support] Implementing Replication via pgAdmin

[Daniel B. Thurman]

>> All is fine except that these slons are running as 
>> foreground processes and cannot be backgrounded and
>> killing the command window  will terminate the process!
>> How can I get the slons running without  resorting to
>> using command windows to start the replication processes?
>
>Install them as a service, eg.
>
>slon -regservice Slony-I
>
>The service can then be started from the services control panel
>applet or from the command line using:
>
>net start Slony-I
>
>It'll start automatically at next reboot as well.
>
>Regards, Dave
>

I think might I see what is happening and why I was not able to
get the nodes running for replication.

What I said before was that I grabbed a copy of slon.conf from
the CVS HEAD and used this file verbatim, i.e. no changes were
made at all to this file and I used this file as my engine.

First, I want to point out, that the slon service is using
LocalSystem account. I further note that I had to change the
password for the LocalSystem account to the password I am
using for the slon, then apply it.  Next, I had to define the
environment variable PGUSER=postgres and PGPASSWORD=***,
then start the service.  I found that if I did not do this,
then there is an error message reported that PostgreSQL
could not reach the local databases and pgAdmin was unable to
connect either as it was reporting TCP connection errors.

Anyway, after the service were started,

1) The Log Messages reported:
"INFO   started 0 slon engine(s)"

2) Followed with:
  "ERROR  Process for engine at 'E:\Program Files
  \PostgreSQL\8.2\Slony\slon.conf' died on startup. "

I had assumed all along that since the service was still running
all must be OK, but I assumed wrongly, I think.  The key point
here is that the slon.conf file has NO ENTRIES, they are ALL
COMMENTED OUT!

OK, with this line of thinking that *SOMETHING* has to be exposed
in the slon.conf file, then I proceeded to uncomment 2 lines.

More specifically:

# Set the cluster name that this instance of slon is running against
# default is to read it off the command line
cluster_name='MasterCluster'

# Set slon's connection info, default is to read it off the command line
conn_info='host=copper.cdkkt.com port=5432 dbname=MyTest user=postgres 
password=***'

Ok, then I restarted the slon service and then I get alot of slon Log
messages, but apparently at some intervals, I still get these errors
cropping up:
3) ERROR  slon_connectdb: PQconnectdb("host=raider.cdkkt.com dbname=MyTest
   user=postgres") failed - fe_sendauth: no password supplied

OK, seems that I finally was able to get at least the slon.conf files to be
accepted.  I find that without the password= entry, I would get a different
error message reported (unable to reach local databases), so it seems that
I need it.

I did the same thing for slave side, and I get an error message:
4) ERROR  slon_connectdb: PQconnectdb("host=copper.cdkkt.com dbname=MyTest
   user=postgres") failed - fe_sendauth: no password supplied

Seems that master cannot reach the slave and the slave cannot reach
the master?

I thought that perhaps this was due to the account being LocalSystem
accounts, for the both master and slave servers and perhaps network
access is not permitted with these accounts?

And yet, I note that the Nodes on both the master and slave are
running with PID and valid process id numbers.  However, changing
a value in the master database table does not replicate to the slave.

As a test, I tried to use a local user account for the slon service on
the master as 'postgres', which is a Windows 2000 Professional OS, which
allows local user accounts to be created and I was able to get slon to
run, but as for the slave server, which is a Windows 2000 Server, which
is also a secondary Domain Controller, I am not allowed to create local
user accounts, but instead must use the domain user account
as: '[EMAIL PROTECTED]' which differs from that used by PostgreSQL
as: 'postgres'?

This is getting really confusing...

Please advise?

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.487 / Virus Database: 269.13.27/1020 - Release Date: 9/20/2007 
12:07 PM
 

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

   http://archives.postgresql.org

[pgadmin-support] Replication Sets

[Daniel B. Thurman]

What are the "rules" when defining the ID's for the replication sets
for both the master and slaves?  I was not able to glean from the
online help if it makes any difference as to what values are chosen
for the IDs when creating a new replication set and whether or not
there should or should not be dependencies.  For example would
this work?

On Master:
Replication Set ID=1
Table = 2
Sequence ID=3

On Slave:
Replication Set ID=4
Table = 5
Sequence ID=6

Does this make any sense?

Please advise.

Thanks!
Dan



No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.487 / Virus Database: 269.13.27/1020 - Release Date: 9/20/2007 
12:07 PM
 

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

[pgadmin-support] 1 Master and 2 Slaves... (Replication)

[Daniel B. Thurman]

I started out with a simple master and slave server arrangement and was 
successfully
able to get the master to replicate to the slave. But once I added a second 
slave, things
got much more confusing.

I had assumed that adding replication to a second slave server, the 
relationship would
remain between the second slave and the master and that the second slave would 
not
know anything of the first slave and vice versa?

I have noticed that adding a second slave, there were additional objects added 
to
itself, the master, the first slave, and 1 additional subscription set, 1 
additional slave nodes!

In other words, the master and the slaves "know" about each other?

This means that for every additional server being added, you have to go back 
and configure
all of the other servers that "knows" about this new addition?

The odd thing so far, my master/slave replication still works, but I wonder 
when the shite will
hit the fan...

Is there any documentation that explains this somehwhere?

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.488 / Virus Database: 269.13.28/1021 - Release Date: 9/21/2007 
2:02 PM
 

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly

Re: [pgadmin-support] 1 Master and 2 Slaves... (Replication)

[Daniel B. Thurman]

>
>I started out with a simple master and slave server 
>arrangement and was successfully
>able to get the master to replicate to the slave. But once I 
>added a second slave, things
>got much more confusing.
>
>I had assumed that adding replication to a second slave 
>server, the relationship would
>remain between the second slave and the master and that the 
>second slave would not
>know anything of the first slave and vice versa?
>
>I have noticed that adding a second slave, there were 
>additional objects added to
>itself, the master, the first slave, and 1 additional 
>subscription set, 1 additional slave nodes!
>
>In other words, the master and the slaves "know" about each other?
>
>This means that for every additional server being added, you 
>have to go back and configure
>all of the other servers that "knows" about this new addition?
>
>The odd thing so far, my master/slave replication still works, 
>but I wonder when the shite will
>hit the fan...
>
>Is there any documentation that explains this somehwhere?
>

Sorry for replying to my own post, but I forgot to mention that when
the second replication set was added, it seems that the original
replication set got corrutped on the slaves and the master seems to
have the table and sequence objects moved into the subscription tree
and for the additional replication set, it has no table object, no
sequence object, and simply cannot be removed or objects added to it.

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.488 / Virus Database: 269.13.28/1021 - Release Date: 9/21/2007 
2:02 PM
 

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

[pgadmin-support] pgAdmin3 v1.8.0 Beta 5: Moves Windows desktop icons around.

[Daniel B. Thurman]

Strange as it seems, but that's right.  I noticed that the use of PgAdmin
has the habit of moving windows desktop icons around!  I keep trying to
but them back but it keeps doing it!  It does not happen every time but
randomly, so it seems.

Dan

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.488 / Virus Database: 269.13.28/1021 - Release Date: 9/21/2007 
2:02 PM
 

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

   http://archives.postgresql.org

Re: [pgadmin-support] 1 Master and 2 Slaves... (Replication)

[Daniel B. Thurman]

>On 22/09/2007 15:00, Daniel B. Thurman wrote:
>
>> I started out with a simple master and slave server 
>arrangement and was successfully
>> able to get the master to replicate to the slave. But once I 
>added a second slave, things
>> got much more confusing.
>
>As Dave said earlier, you really have a better chance of 
>getting answers 
>to your questions on the Slony-I list where you'll find the 
>Slony gurus 
>- this list is for pgAdmin.
>
>Sorry I can't be more help than that.
>
>Ray.
>

Except this is a pgAdmin issue, I think.  Because of the strange
arrangement of the replication objects for the master and slaves
and adding of a 2nd slave server, which is what pgAdmin attempts
to provide?

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.488 / Virus Database: 269.13.28/1021 - Release Date: 9/21/2007 
2:02 PM
 

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

[pgadmin-support]

[Daniel B. Thurman]

My objective is to setup and test replication, starting with a Master and 
Slave-1 server, and once
replication has worked, to add an additional Slave-2 server for replication. 
All of the replication
configuration was done strictly via pgAdmin3 v8.0-beta-5.

 M
  /  \
 vv
S1 S2

After I have been successful at getting a simple master/slave replication setup 
to work, I proceeded
to add Slave-2 and noticed many unexpected replicaton objects additions added 
to both the Master
and Slave-1 configurations as well as to the new Slave-2 server as shown in the 
link to the jpg image
(of 36KB):

http://www.cdkkt.com/images/pgAdmin/replication1.jpg

Adding Slave-2 results:

==
The Master now has two Replication Sets. The first "Hardware" set shows 
Sequences(0) as before,
the Tables(1) shows the public.cars object as before, and finally the 
Subscritions(1) shows the Slave
Node with the same properties as before.  So far it looks like there are no 
changes made here and all
looks good.

The second "Hardware" shows Subscriptions(0) under it.  Seems that I am unable 
to added a new
subscription here.

==
As for Slave-1, the first "Hardware" set, Subscriptions(1) is shown directly 
under it, and directly under
Subscriptions(1) is the Slave Node.  Under Slave Node are two objects, 
Sequences(0) and Tables(0).
As for trying to create New Sequences or Tables, the only menu items available 
for these objects are:
"Refresh" and "object list report". However, New Subscriptions can be created 
at Subscriptions(1) or
at Slave Node.

The second "Hardware" set shows three objects: Sequences(0), Tables(0), and 
Subscriptions(0).
Choosing a New Table menu item will result in an empty list items for this 
table but you can type
whatever you want in the fields for this table, but you will not be able to 
commit it.  The same is
true for the Sequences(0).  A New Subscription can also be added but shows:

Orgin: 2
Provider: 2 - Slave Node
Receiver: 1 - Master Node, 5 - Slave Node (dropdown list)
Can Forward: Unchecked

You can OK to save these settings, but you cannot get rid of these once 
committed.

==
As for Slave-2, and since we are adding a NEW slave here, two Hardware 
replication sets were
created.  The first shows "Hardware", with Subscriptions(1) having a Slave Node 
subscription
with:

Provider ID:   1
Provider Name:  Master Node
Receiver ID:   2
Recievier Name: Slave Node
Active:   Yes
May Forward: Yes
Is forwarded:   No

Under the Slave Node object, there are two objects under this, and these are 
Sequences(0) and
Tables(0).  The only menu items for both of these objects are: "Refresh" and 
"object list report".
The second "Hardware" object shows only the Subscriptions(0) object.  Selecting 
New Subscription
shows:

Origin:  2
Provider:   5 - Slave Node
Reciever:  1 - Master Node, 2 - Slave Node (dropdown list)
Can forward: Unchecked

Clicking: OK shows an error:
"ERROR: Slony-I: subscribeSet(): provider 5 is not an active forwarding node 
for replication set 3"

Clicking: OK after selecting Reciever as: 2 - Slave shows error:
"ERROR: Slony-I: subscribeSet(): set origin and received cannot be identical"

Sequences and Tables branches was moved directly under 'Slave Node', as shown.  
As for the additional
added Replication Sets with (0) Sequences, Tables, and Subscriptions, they 
cannot be deleted, the
missing tables and Sequences cannot be added, and Sequences, Tables, and 
Subscriptions cannot
be edited.

By the way, the Master to Slave-1 replication is still running fine at this 
time.  But I am unable to
get the Slave-2 replication configuation setup and joined to the replication 
group.

Hmm...  can someone tell me how it is possible to setup a Master and two-Slave 
replication via
pgAdmin3 and is it possible to do?

Thanks!
Dan

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.488 / Virus Database: 269.13.30/1030 - Release Date: 9/25/2007 
8:02 AM
 

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

   http://archives.postgresql.org

Re: [pgadmin-support]

[Daniel B. Thurman]

>Daniel B. Thurman wrote:
>> Thanks for some details and it helps, except the following step:
>> 
>> 10) Create Paths on the master to both slaves, and on each 
>slave back to
>> the master. Create the paths under each node on the master, using
>> the connection strings specified in the slon config 
>files. Note that
>> future restructuring of the cluster may require 
>additional paths to
>> be defined.
>> 
>> Can you please elaborate?
>> 
>> I am not clear if by "master" you mean "master server" or 
>"master node"
>> and likewise for "slave" you mean "slave server" or "slave node".
>
>Technically node (or database). That tutorial was written 
>using a single 
>server which is stated at the beginning so there is no master or slave 
>server.
>
>> It is not clear if I need only to update the paths only on the
>> master-server and if any work needs to be done for the paths on
>> the slave-servers.
>
>Check the slony docs for more info on paths, but essentially you need 
>paths on each node pointing to every other node it might talk 
>to. So in 
>the example given, the master has paths to both slaves, and each slave 
>has a path to the master. If you restructure the cluster, and make a 
>slave the master, you will need to add a path on that node to the 
>remaining slave, and on the remaining slave to the new master.
>
>Regards, Dave
>
>No virus found in this incoming message.
>Checked by AVG Free Edition. 
>Version: 7.5.488 / Virus Database: 269.13.33/1034 - Release 
>Date: 9/27/2007 5:00 PM
> 

Oh my.

My arrangement is for 1 master (on one server) and two slaves (on two other
servers).  With a little insight and with your help, I am able to replicate
the master to the two other slaves now!  I did this so that I can have harware
redundancy and seperate databases scattered around in my environment.

Thank you for all of your help and most importantly, your patience with a
really ignorant newbie! ;)

Kind Regards,
Dan

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.488 / Virus Database: 269.13.33/1034 - Release Date: 9/27/2007 
5:00 PM
 

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq

Re: [pgadmin-support] pgAdmin III v1.8.0 RC 1 released

[Daniel B. Thurman]

>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED] Behalf Of Dave Page
>Sent: Wednesday, October 10, 2007 1:31 AM
>To: pgadmin-hackers; pgAdmin Support; [EMAIL PROTECTED]
>Subject: [pgadmin-support] pgAdmin III v1.8.0 RC 1 released
>
>
>I'm pleased to announce the release of pgAdmin III v1.8.0 Release
>Candidate 1. We hope to turn this into a full release as soon as
>possible, so please, download, test and report any last-minute 
>issues so
>we can fix them for release!!
>
>pgAdmin is the leading graphical administration and 
>development tool for
>PostgreSQL, EnterpriseDB and most other PostgreSQL-derived 
>DBMSs. It can
>be used on Windows, Linux, FreeBSD, Mac and Solaris with servers on any
>platform. For more information, please see the website:
>http://www.pgadmin.org/
>
>For details of the changes since v1.6, please see the changelog at:
>http://www.pgadmin.org/development/changelog.php
>
>To download the release candidate, please visit the download page at
>http://www.pgadmin.org/download/. In addition to the source 
>code, binary
>downloads are currently available for Windows, Mac OS X and Slackware
>Linux. Additional binaries will be released as soon as possible.
>
>This is a pre-release version and should be used at your own risk!
>Please report any bugs or problems to [EMAIL PROTECTED]
>
>Regards, Dave.
>
>-- 
>Dave Page
>pgAdmin Project Lead
>
>---(end of 
>broadcast)---
>TIP 3: Have you checked our extensive FAQ?
>
>   http://www.postgresql.org/docs/faq
>

Please fix:

1) Exe icon.  It is still broken.  I think the 48x48 bitmap breaks
   older versions of Windows which supports only 16x16 or 32x32(?)
   bitmaps.

2) Running pgAdminIII or operations within pgAdminIII sometimes
   changes the window focus to that of another application. It is
   quite annoying.

I will play with RC1 release and see how it works!

Thanks!
Dan

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.488 / Virus Database: 269.14.6/1060 - Release Date: 10/9/2007 4:43 
PM
 

---(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

Re: [pgadmin-support] pgAdmin III v1.8.0 RC 1 released

[Daniel B. Thurman]

>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED] Behalf Of Hiroshi Saito
>Sent: Wednesday, October 10, 2007 10:22 AM
>To: Daniel B. Thurman; pgAdmin Support
>Subject: Re: [pgadmin-support] pgAdmin III v1.8.0 RC 1 released
>
>
>Hi.
>
>From: "Daniel B. Thurman" <[EMAIL PROTECTED]>
>
>> Please fix:
>>
>> 1) Exe icon.  It is still broken.  I think the 48x48 bitmap breaks
>>older versions of Windows which supports only 16x16 or 32x32(?)
>>bitmaps.
>
>I will it arrangement tomorrow.
>
>>
>> 2) Running pgAdminIII or operations within pgAdminIII sometimes
>>   changes the window focus to that of another application. It is
>>   quite annoying.
>
>Um, please send more phenomenon in detail.
>

This is the hard part!  It is random and does not occur all the
time, so how can I add more details?  As I explained, clicking on
objects within pgAdminIII works fine, but at random times, clicking
on a pgAdminIII object, the focus shifts to an application window
such as Outlook, Windows Explorer, FireFox, or whatever applications
I have up and running.

Do you have any suggestions as to how I can "trap" this phenomenon?

>Regards,
>Hiroshi Saito
>

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.488 / Virus Database: 269.14.6/1060 - Release Date: 10/9/2007 4:43 
PM
 

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

   http://archives.postgresql.org

[pgadmin-support] ERROR

[Leandro Daniel Seghezzo]

win XP SP2Spanishpgadmin3-1.12.1AVISO DE CONFIDENCIALIDAD: Este mensaje y cualquier archivo adjunto que lo acompañe es para ser utilizado por el receptor y contiene información que puede ser privilegiada, confidencial o de propiedad intelectual de acuerdo a la ley aplicable. Si Ud. no es el receptor interesado, por el presente se le notifica formalmente que cualquier uso, copia o distribución de este correo electrónico, en todo o en parte, está estrictamente prohibido. Por favor, notifique al remitente regresándole este correo y bórrelo de su sistema.Este correo electrónico no constituye una oferta de contrato, una modif!
 icación o aceptación de una oferta de contrato, a menos que explícitamente sea designado en esos términos. Este correo electrónico no constituye un consentimiento para el uso de la información del remitente, para propósitos directos o para transmisiones de información a terceros. No se puede responsabilizar a Quickfood S.A. y subsidiarias de ninguna forma por / o en relación con alguna consecuencia y/o daño que resulte del apropiado y completo envío y recepción del contenido de este mail.CONFIDENTIALITY NOTICE: This email and any attachments accompanying it are intended only for the use of the addressee, and may contain information that is privileged, confidential or protected by copyright according to the applicable law. If you are not the intended recipient, you are hereby formally notified that any use, copy or distribution of this email in whole or in part is st!
 rictly prohibited. Please advise the sender by returning this !
 email an
d delete it from your system.This email is not an offer of a contract, neither is it an amendment or an acceptance of an offer of a contract unless it is explicitly thus established in it. This email is not a consent to the use of the information supplied by the sender either directly or to be transmitted to third parties. Quickfood S.A. and its subsidiaries cannot be held responsible in any way for /or in relation to any consequence and/or damage resulting from the proper and complete transmission and receipt of the content of this email.

[pgadmin-support] RFE: Use JOIN instead of WHERE in Graphical Query Builder

[Daniel Serodio (lists)]

I'm using pgAdmin 1.14.3, and its Graphical Query Builder generates 
WHERE clauses for joins. It would be nice if it generated JOIN clauses 
instead.


Thanks in advance,
Daniel Serodio


--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] RFE: Use JOIN instead of WHERE in Graphical Query Builder

[Daniel Serodio (lists)]

Nelson A. de Oliveira wrote:

Hi!

On Tue, Jul 17, 2012 at 7:36 PM, Daniel Serodio (lists)
  wrote:

I'm using pgAdmin 1.14.3, and its Graphical Query Builder generates WHERE
clauses for joins. It would be nice if it generated JOIN clauses instead.


Is there any kind of difference between WHERE or JOINs in PostgreSQL?
Aren't they all a cartesian product internally?
They may be implemented the same way in PostgresSQL, but they're two 
different concepts. Because of this, I find it a lot easier to 
understand a complex query when the joins are in a JOIN clause.


In more practical terms, it's easier to change "a JOIN b ON a.pk = b.fk" 
to "a LEFT JOIN b ON a.pk = b.fk" (just have to type the LEFT keyword, 
regardless of which tables/columns are used) then change "WHERE a.pk = 
b.fk" to "WHERE a.pk = b.fk OR b.fk IS NULL" (have to add "OR b.fk IS 
NULL", which changes according to which tables/columns are used).


Regards,
Daniel Serodio

[pgadmin-support] RFE: Use JOIN instead of WHERE in Graphical Query Builder

[Daniel Serodio (lists)]

I'm using pgAdmin 1.14.3, and its Graphical Query Builder generates 
WHERE clauses for joins. It would be nice if it generated JOIN clauses 
instead.


Thanks in advance,
Daniel Serodio


--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] RFE: Use JOIN instead of WHERE in Graphical Query Builder

[Daniel Serodio (lists)]

Guillaume Lelarge wrote:

On Tue, 2012-07-17 at 20:06 -0300, Daniel Serodio (lists) wrote:

Nelson A. de Oliveira wrote:

Hi!

On Tue, Jul 17, 2012 at 7:36 PM, Daniel Serodio (lists)
   wrote:

I'm using pgAdmin 1.14.3, and its Graphical Query Builder generates WHERE
clauses for joins. It would be nice if it generated JOIN clauses instead.

Is there any kind of difference between WHERE or JOINs in PostgreSQL?
Aren't they all a cartesian product internally?

They may be implemented the same way in PostgresSQL,


They are.


  but they're two different concepts.


How so?
My relational algebra is a little rusty, but from what I recall plus a 
quick Wikipedia read, WHERE is a "selection (σ)" while JOIN is a "join 
(⋈, θ, ⋉ or ▷"): 
http://en.wikipedia.org/wiki/Relational_algebra#Set_operators

  Because of this, I find it a lot easier to
understand a complex query when the joins are in a JOIN clause.



I do agree here.


In more practical terms, it's easier to change "a JOIN b ON a.pk = b.fk"
to "a LEFT JOIN b ON a.pk = b.fk" (just have to type the LEFT keyword,
regardless of which tables/columns are used) then change "WHERE a.pk =
b.fk" to "WHERE a.pk = b.fk OR b.fk IS NULL" (have to add "OR b.fk IS
NULL", which changes according to which tables/columns are used).



Yes, and it's less risky. If you use a JOIN, you have to add a ON clause
if you don't want to get a syntax error. That protects you from
cartesian product.

To get back on the request, that could be interesting to do, and
probably not hard.

Thanks.

Regards,
Daniel Serodio

[pgadmin-support] Horizontal scroll on OS X bug

[Daniel Serodio (lists)]

Horizontal scroll using the mouse wheel (while holding Shift) or by 
dragging on the touchpad with two fingers doesn't work on OS X. I can 
only scroll horizontally using the scrollbar.


Regards,
Daniel Serodio

--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[pgadmin-support] RFE: Alises in WHERE clauses

[Daniel Serodio (lists)]

It would be nice if PostgreSQL supported column aliases in WHERE 
clauses, eg:


SELECT left(value, 1) AS first_letter
FROM some_table
WHERE first_letter > 'a';

Is this the proper mailing list for such feature requests?

Thanks in advance,
Daniel Serodio



--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] RFE: Alises in WHERE clauses

[Daniel Serodio (lists)]

Raymond O'Donnell wrote:

On 17/09/2012 21:24, Daniel Serodio (lists) wrote:

It would be nice if PostgreSQL supported column aliases in WHERE
clauses, eg:

SELECT left(value, 1) AS first_letter
FROM some_table
WHERE first_letter>  'a';

Is this the proper mailing list for such feature requests?


No. :-)

Try pgsql-general instead; this list is for PgAdmin.

Oops. I meant to post to pgsql-general but autocomplete failed me :-)

Regards,
Daniel Serodio

[pgadmin-support] problem with pgAdmin 4 on Windows

[Harasty, Daniel J]

Greetings,

I'm trying to install pgAdmin 4 on my Windows laptop (without installing the 
full version of PostgreSQL) so that I can admin my 9.3 server on a nearby 
Ubuntu box.

The download of version 1.1 and install seemed to work fine.  However, upon 
launching, I get stuck in a loop of where the app states:

Failed to connect to the pgAdmin application server. Retrying in 3 seconds, or 
click here to try again now.

If I click the "here" link, I get a SMALL portion of some GUI rendered (just 
some tabs and a close box), but nothing to do there.

First: is this a supported configuration: pgAdmin4 running on a box WITHOUT the 
server installed?  If so... what can I do next to get this working?  Thanks.

Dan