[pgadmin-support] dump and restore in pgadmin
Does pgadmin have support for dumping and restoring a database? ---(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] How to use the SET data type? Help plz!
When I add a column a table I am able to choose the SET DataType, but there is no obvious way to define the acceptable values for the set. I'd like to use the gui that I use for creating all my other columns rather than doing it by hand. The generated sql from the gui doesn't even seem right because it puts set in quotes. I can't even enter sql by hand that should add a set with values, of course my syntax might not be right as I can't seem to find a good example for creating a set. Can anyone help me in using sets with pgadmin? ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[pgadmin-support] Re: How to use the SET data type? Help plz!
Odd that it is a selectable datatype in pgadmin then huh? If there are no sets, then is there anythign else that can be used to represent that type of data. I used them a lot in a mySQL database that I am migrating from. It is very useful to have a predefined set of values to choose from, otherwise it would just be a text field with no constraints as to the contents. It is also nice to have the popup menus of the selecable values when inputing data like how phpmyadmin handles sets. It seem slike a huge oversight to not support them. > U...PostgreSQL doesn't support sets... > > Chris > > [EMAIL PROTECTED] wrote: > > > When I add a column a table I am able to choose the SET DataType, but there is > > no obvious way to define the acceptable values for the set. > > I'd like to use the gui that I use for creating all my other columns rather > > than doing it by hand. The generated sql from the gui doesn't even seem right > > because it puts set in quotes. I can't even enter sql by hand that should add > > a set with values, of course my syntax might not be right as I can't seem to > > find a good example for creating a set. > > Can anyone help me in using sets with pgadmin? > > > > ---(end of broadcast)--- > > TIP 4: Don't 'kill -9' the postmaster > > > ---(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 > --- Begin Message --- U...PostgreSQL doesn't support sets... Chris [EMAIL PROTECTED] wrote: When I add a column a table I am able to choose the SET DataType, but there is no obvious way to define the acceptable values for the set. I'd like to use the gui that I use for creating all my other columns rather than doing it by hand. The generated sql from the gui doesn't even seem right because it puts set in quotes. I can't even enter sql by hand that should add a set with values, of course my syntax might not be right as I can't seem to find a good example for creating a set. Can anyone help me in using sets with pgadmin? ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster ---(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 --- End Message --- ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[pgadmin-support] Re: How to use the SET data type? Help plz!
I see your points. So how is the best way to implement this type of "set" idea in something like postgres? Say I have a column named primary colors, and I want to limit this to red, blue, and yellow. How is the best way to do this without a mysql set? Thanks > > Odd that it is a selectable datatype in pgadmin then huh? > > That's a question for the pgAdmin guys, but I know that PostgreSQL has a > type called 'set', which is nothing to do with sets as you understand > them. > > > If there are no sets, then is there anythign else that can be used to > > represent that type of data. I used them a lot in a mySQL database that I am > > migrating from. It is very useful to have a predefined set of values to > > choose from, otherwise it would just be a text field with no constraints as to > > the contents. It is also nice to have the popup menus of the selecable values > > when inputing data like how phpmyadmin handles sets. It seem slike a huge > > oversight to not support them. > > Look up CHECK constraints. > > Lack of 'MySQL sets' in Postgres is NOT an oversight. It's a random, > non-SQL standard type that the MySQL developers made up one day that no > other database on Earth supports. Why should Postgres support it? It's > just a lame workaround for MySQL not supporting constraints. > > (Sorry to sound all worked up about it, but it's one of the things I > find annoying about MySQL...) > > Chris > > --- Begin Message --- Odd that it is a selectable datatype in pgadmin then huh? That's a question for the pgAdmin guys, but I know that PostgreSQL has a type called 'set', which is nothing to do with sets as you understand them. If there are no sets, then is there anythign else that can be used to represent that type of data. I used them a lot in a mySQL database that I am migrating from. It is very useful to have a predefined set of values to choose from, otherwise it would just be a text field with no constraints as to the contents. It is also nice to have the popup menus of the selecable values when inputing data like how phpmyadmin handles sets. It seem slike a huge oversight to not support them. Look up CHECK constraints. Lack of 'MySQL sets' in Postgres is NOT an oversight. It's a random, non-SQL standard type that the MySQL developers made up one day that no other database on Earth supports. Why should Postgres support it? It's just a lame workaround for MySQL not supporting constraints. (Sorry to sound all worked up about it, but it's one of the things I find annoying about MySQL...) Chris --- End Message --- ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[pgadmin-support] TUNNEL PROBLEMS
LeavesThis is the error message from an SSH-TUNNEL connection.(MESSAGE BELOW) I have compared the postgres configuraition files and cannot see any difference in them. I use this exact same scheme on two different systems, the obivous one works and the other does not. System One work, yet System Two does not and get the errors indicated below. Does anyone know of issues with 7.3.2 vs 7.1.3 in this area or pgadminII v1.6.0 IE: System One Postgres: 7.1.3 OpenSSH_3.1p1, SSH protocols 1.5/2.0, OpenSSL 0x0090602f = localall trust host all 127.0.0.1 255.255.255.255 trust host all 172.16.0.0255.255.0.0 trust = IE: System Two psql (PostgreSQL) 7.3.2 OpenSSH_3.5p1, SSH protocols 1.5/2.0, OpenSSL 0x0090701f = hostall all 172.16.1.17 255.255.255.255 trust local all all trust hostall all 127.0.0.1 255.255.255.255 trust hostall all 172.16.1.0255.255.255.0trust = IE Client System Windows XP Professional PuTTy 0.52 ssh client == Output from PuTTy Log 2003-10-03 08:24:33 Looking up host "jdoherty.net" 2003-10-03 08:24:33 Connecting to 208.180.XXX.XXX port 433 2003-10-03 08:24:33 Server version: SSH-1.99-OpenSSH_3.5p1 2003-10-03 08:24:33 We claim version: SSH-1.5-PuTTY-Release-0.52 2003-10-03 08:24:33 Using SSH protocol version 1 2003-10-03 08:24:33 Received public keys 2003-10-03 08:24:33 Host key fingerprint is: 2003-10-03 08:24:33 1024 64:4b:92:37:02:30:e2:cc:ed:4d:2f:03:32:ee:80:9b 2003-10-03 08:24:33 Encrypted session key 2003-10-03 08:24:33 AES not supported in SSH1, skipping 2003-10-03 08:24:33 Using Blowfish encryption 2003-10-03 08:24:33 Trying to enable encryption... 2003-10-03 08:24:33 Initialised Blowfish encryption 2003-10-03 08:24:33 Installing CRC compensation attack detector 2003-10-03 08:24:33 Successfully started encryption 2003-10-03 08:24:33 Sent username "jmd" 2003-10-03 08:24:36 Sending password with camouflage packets 2003-10-03 08:24:36 Sent password 2003-10-03 08:24:36 Authentication successful 2003-10-03 08:24:36 Local port 8887 forwarding to jdoherty.net:5432 2003-10-03 08:24:36 Allocated pty 2003-10-03 08:24:36 Started session 2003-10-03 09:19:24 Opening forwarded connection to jdoherty.net:5432 2003-10-03 09:22:34 Forwarded connection refused by server == =====BELOW IS THE PGADMIN LOG 2003-10-03 09:22:34 - *** 2003-10-03 09:22:34 - Error(s) 2003-10-03 09:22:34 - *** 2003-10-03 09:22:34 - Error in pgAdmin II:frmConnect.cmdConnect_Click: -2147217843 - Unexpected protocol character during authentication; Error while reading from the socket. 2003-10-03 09:22:34 - Windows Version: Windows XP v5.1 build 2600 Service Pack 1 2003-10-03 09:22:34 - pgSchema Version: 1.6.0 2003-10-03 09:22:34 - MDAC Version: 2.7 2003-10-03 09:22:34 - cnPostgreSQL.State = adStateClosed James M Doherty [EMAIL PROTECTED] Georgetown, TX 78626 "There is no luck without discipline" IRISH PROVERB ---(end of broadcast)--- TIP 8: explain analyze is your friend
[pgadmin-support] TUNNEL RESOLVED
LeavesThe problem I was having with ssh tunneling was resolved by making the following change to the port forward scenario: pg_hba.conf: #TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD local all all trust hostall all127.0.0.1 255.255.255.255 trust hostall all 172.16.1.0 255.255.255.0 trust <<<-Added -L8887:172.16.1.17:5432 <<<--Used the local private IP addres in the port forward argument. Without this I get the connection refused by host in the Putty log . Jim ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-support] connection dropping
If you are working from a windows machine and using putty there is a time-out setting which you can enable. This basically sends a null byte every (seconds you specify) to the far end. Most firewall allow a tcp connection but if data is not transmitted withing (firewall timeout) your connection will be dropped by the firewall, this is usually around 120 seconds. Jim - Original Message - From: <[EMAIL PROTECTED]> To: "bill" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, October 16, 2003 11:31 AM Subject: Re: [pgadmin-support] connection dropping > > Hello, > > I love pgAdmin III. I use it when working at home. I'm stuck with II at > > work since my machine is W98, although it (II)has a feature I prefer > > over III. Anyway, here on the homefront, I'm connected via high-speed > > cable connection (1.5 meg). I get excellent performance, however, I find > > that pgAdmin drops the DB connection rather quickly if there is no > > activity. If I leave the interface for any amount of time, when I come > > back and click on anything, I get the error message: > > "An error has occurred: > > > > server closed the connection unexpectedly > > This probably means the server terminated abnormally before of while > > processing the request." > > > > After this I usually have to click through many dialog boxes telling me > > that there is no connection to the server. > > > > If I look at the process list in the DB server, I can see all the > > connections I have made over a period just sitting there 'idle'. > > There is nothing in the log that corresponds with the drop that I can > > tell except with the possibility of: > > LOG: pq_recvbuf: recv() failed: Connection reset by peer > > ,but these may be from other clients. > > > > What can I do to maintain the connection even if its idle? > > > > I don't know how much help I can be, but I'll see if I can give you some > suggestions, or things to look at, to at least isolate the problem. > > Do you experience this with other applications? I.e., if you open a ssh > connection to a server, and leave it sitting for a while, does the session > close/timeout? > > The odds are good that the problem here is that a router or firewall (most > likely a firewall) between you and the database server is killing your > connection, but not telling the server about it. This happens quite a bit > to me behind NAT'ing firewalls. OTOH, behind my NAT'ing linksys cable > router at home, my connections never time out, even if I leave them up for > days. > > We've had the discussion before about adding support to pgAdmin3 for > trying to keep connections alive through bad firewalls, but we've come to > the conclusion that there isn't a "good" way to do this in the > application, and that these sort of network problems are better solved by > the end-user, not the application, since they are likely to affect lots of > applications, not just pgAdmin3. > > If you can provide me some further information about your network setup, > maybe I can give you some suggestions for trying to fix it that way. > > ahp > > ---(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 > ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [pgadmin-support] connection dropping
Also, if you use an SSH tunnel you can get around the timeout issue... Jim - Original Message - From: <[EMAIL PROTECTED]> To: "bill" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, October 16, 2003 11:31 AM Subject: Re: [pgadmin-support] connection dropping > > Hello, > > I love pgAdmin III. I use it when working at home. I'm stuck with II at > > work since my machine is W98, although it (II)has a feature I prefer > > over III. Anyway, here on the homefront, I'm connected via high-speed > > cable connection (1.5 meg). I get excellent performance, however, I find > > that pgAdmin drops the DB connection rather quickly if there is no > > activity. If I leave the interface for any amount of time, when I come > > back and click on anything, I get the error message: > > "An error has occurred: > > > > server closed the connection unexpectedly > > This probably means the server terminated abnormally before of while > > processing the request." > > > > After this I usually have to click through many dialog boxes telling me > > that there is no connection to the server. > > > > If I look at the process list in the DB server, I can see all the > > connections I have made over a period just sitting there 'idle'. > > There is nothing in the log that corresponds with the drop that I can > > tell except with the possibility of: > > LOG: pq_recvbuf: recv() failed: Connection reset by peer > > ,but these may be from other clients. > > > > What can I do to maintain the connection even if its idle? > > > > I don't know how much help I can be, but I'll see if I can give you some > suggestions, or things to look at, to at least isolate the problem. > > Do you experience this with other applications? I.e., if you open a ssh > connection to a server, and leave it sitting for a while, does the session > close/timeout? > > The odds are good that the problem here is that a router or firewall (most > likely a firewall) between you and the database server is killing your > connection, but not telling the server about it. This happens quite a bit > to me behind NAT'ing firewalls. OTOH, behind my NAT'ing linksys cable > router at home, my connections never time out, even if I leave them up for > days. > > We've had the discussion before about adding support to pgAdmin3 for > trying to keep connections alive through bad firewalls, but we've come to > the conclusion that there isn't a "good" way to do this in the > application, and that these sort of network problems are better solved by > the end-user, not the application, since they are likely to affect lots of > applications, not just pgAdmin3. > > If you can provide me some further information about your network setup, > maybe I can give you some suggestions for trying to fix it that way. > > ahp > > ---(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 > ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [pgadmin-support] Copy between Databases
look at pg_dump. If you want to do this in real-time please specify ? Jim - Original Message - From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 26, 2004 11:58 AM Subject: [pgadmin-support] Copy between Databases > Is there a way to copy tables, functions, etc. between databases and servers > within pgAdmin? > > For example, within pgAdmin we have: > Server1 has a database called DB1 with a table called Table1. > Server2 has a database called DB2 with a table called Table2. > > I want to copy the data and metadata from Table1 to Table2. Is this > possible? If so, how? > > Thanks, > Derrick > > > ---(end of broadcast)--- > TIP 8: explain analyze is your friend > ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[pgadmin-support]
Ctrl+Ins works in query editor window, but does not work in results grid. Ctrl+C works in both places. Very strange, isn't it? The version of pgAdmin you are running - 1.16.0 The operating system and version details - Windows 7 64 bit Steps required to reproduce the problem - create any query, run, go to results, press ctrl+ins - result is not copied to buffer. -- Sent via pgadmin-support mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
