Re: [pgadmin-support] bug report
Krzysztof Kajkowski wrote: Hi! Thanks for making one of the most usable program for PostgreSQL! I think I've found a bug. Steps to reproduce: - open program and a connection to remote postgres db (via ssh tunnel for example) - click on desired table - click on SQL console - in the opened console delete "--" sign before DROP statement. SQL will look like this (for example): This is probably a problem (refresh of dropped object) we fixed in January for CVS head, and which will be included in 1.0.3. Regards, Andreas ---(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] problems in connecting to a server
Em Terça, 11 de Maio de 2004 19:49, escreveste: > hi! > > in my pg_hba.conf file i have this: > local all all trust > # IPv4-style local connections: > hostall all 127.0.0.1 255.255.255.255 trust > # > > and everything works w/o problems. can you try it also? > this way, pgsql shouldn't ask for a password an authentication without a > password (what you're trying to do now as seen from the log) shouldn't be a > problem any more. > Thank you it worked. I had already tried the line "local ... trust", but it seems that I need the line "host ... trust". -- Pedro Henrique e Figueiredo Quaresma de Almeida ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [pgadmin-support] varchar[] !?
Em Terça, 11 de Maio de 2004 01:08, escreveste: > > When I try to create a new column with the varchar datatype I obtain a > > "varchar[]" type, and I cannot specify the max limit. What is the > > problem? > > You are going VARCHAR[n] instead of the correct VARCHAR(n) > > Chris Yes, but when I try to choose the type in the types-menu the options that I have are all with square brackets "[]" and not with "()" -- Pedro Henrique e Figueiredo Quaresma de Almeida ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[pgadmin-support] problems in connecting to a server
Hi I have two Debian systems, both with psql (PostgreSQL) 7.4.2 pgadmin3 1.0.2 but in one of them (the laptop) I am unable to make a connection with pgadmin3, I always get: -- 2004-05-11 10:13:12 ERROR : Error connecting to the server: FATAL: IDENT authentication failed for user "pedro" -- The "pedro" user has been created previously with the "createuser" command -- [EMAIL PROTECTED]:~$ psql template1 Welcome to psql 7.4.2, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit template1=> \du List of database users User name | User ID | Attributes ---+-+ fpam | 101 | create database pedro | 100 | create database postgres | 1 | superuser, create database (3 rows) --- Any help will be appreciated, thank you. -- Pedro Henrique e Figueiredo Quaresma de Almeida ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[pgadmin-support] bug report
Hi! Thanks for making one of the most usable program for PostgreSQL! I think I've found a bug. Steps to reproduce: - open program and a connection to remote postgres db (via ssh tunnel for example) - click on desired table - click on SQL console - in the opened console delete "--" sign before DROP statement. SQL will look like this (for example): DROP TABLE public.artykuly; CREATE TABLE public.artykuly ( numer int8, autor text, podtytul text, tytul text ) WITHOUT OIDS; REVOKE ALL ON TABLE public.artykuly FROM public; GRANT ALL ON TABLE public.artykuly TO postgres; GRANT ALL ON TABLE public.artykuly TO cayco; - run the statement - if you close the SQL window the program will immediately terminate (in 90% of cases) and throw a memory protection fault. I attached a valgrind log from the program crash. I don't know what could be more helpful - feel free to ask me! cheers P.S. 11:27 ([EMAIL PROTECTED])~$ apt-cache show pgadmin3 Package: pgadmin3 Priority: optional Section: misc Installed-Size: 10440 Maintainer: Raphael Enrici <[EMAIL PROTECTED]> Architecture: i386 Version: 1.0.2-4 Debian Sid. -- Krzysztof KajkowskiGG: 176706 jabber: [EMAIL PROTECTED] Gazeta Studenckahttp://www.studencka.pl/ Registered Linux user:237605 IT professional. Linux. Administration. Programming. ==11255== Memcheck, a memory error detector for x86-linux. ==11255== Copyright (C) 2002-2004, and GNU GPL'd, by Julian Seward. ==11255== Using valgrind-2.1.1, a program supervision framework for x86-linux. ==11255== Copyright (C) 2000-2004, and GNU GPL'd, by Julian Seward. ==11255== ==11255== My PID = 11255, parent PID = 9939. Prog and args are: ==11255==pgadmin3 ==11255== For more details, rerun with: -v ==11255== ==11255== warning: Valgrind's pthread_getschedparam is incomplete ==11255== your program may misbehave as a result ==11255== Syscall param write(buf) contains uninitialised or unaddressable byte(s) ==11255==at 0x3C856F1E: write (in /lib/tls/libc-2.3.2.so) ==11255==by 0x3C916E0F: (within /usr/X11R6/lib/libX11.so.6.2) ==11255==by 0x3C9179FE: _X11TransWrite (in /usr/X11R6/lib/libX11.so.6.2) ==11255==by 0x3C8F7261: (within /usr/X11R6/lib/libX11.so.6.2) ==11255== Address 0x3CC4957C is 92 bytes inside a block of size 2048 alloc'd ==11255==at 0x3C01FC03: calloc (vg_replace_malloc.c:141) ==11255==by 0x3C8E909C: XOpenDisplay (in /usr/X11R6/lib/libX11.so.6.2) ==11255==by 0x3C40CED1: gdk_display_open (in /usr/lib/libgdk-x11-2.0.so.0.200.4) ==11255==by 0x3C3EE195: gdk_display_open_default_libgtk_only (in /usr/lib/libgdk-x11-2.0.so.0.200.4) ==11255== ==11255== Invalid read of size 4 ==11255==at 0x3C808C76: wcslen (in /lib/tls/libc-2.3.2.so) ==11255==by 0x8590697: wxLocale::Init(wchar_t const*, wchar_t const*, wchar_t const*, bool, bool) (in /usr/bin/pgadmin3) ==11255==by 0x85911FB: wxLocale::Init(int, int) (in /usr/bin/pgadmin3) ==11255==by 0x81991ED: pgAdmin3::OnInit() (in /usr/bin/pgadmin3) ==11255== Address 0x3CEA9074 is 0 bytes inside a block of size 24 free'd ==11255==at 0x3C01F918: free (vg_replace_malloc.c:127) ==11255==by 0x83A7508: wxWCharBuffer::~wxWCharBuffer() (in /usr/bin/pgadmin3) ==11255==by 0x859067D: wxLocale::Init(wchar_t const*, wchar_t const*, wchar_t const*, bool, bool) (in /usr/bin/pgadmin3) ==11255==by 0x85911FB: wxLocale::Init(int, int) (in /usr/bin/pgadmin3) ==11255== ==11255== Invalid read of size 4 ==11255==at 0x3C808C81: wcslen (in /lib/tls/libc-2.3.2.so) ==11255==by 0x8590697: wxLocale::Init(wchar_t const*, wchar_t const*, wchar_t const*, bool, bool) (in /usr/bin/pgadmin3) ==11255==by 0x85911FB: wxLocale::Init(int, int) (in /usr/bin/pgadmin3) ==11255==by 0x81991ED: pgAdmin3::OnInit() (in /usr/bin/pgadmin3) ==11255== Address 0x3CEA9078 is 4 bytes inside a block of size 24 free'd ==11255==at 0x3C01F918: free (vg_replace_malloc.c:127) ==11255==by 0x83A7508: wxWCharBuffer::~wxWCharBuffer() (in /usr/bin/pgadmin3) ==11255==by 0x859067D: wxLocale::Init(wchar_t const*, wchar_t const*, wchar_t const*, bool, bool) (in /usr/bin/pgadmin3) ==11255==by 0x85911FB: wxLocale::Init(int, int) (in /usr/bin/pgadmin3) ==11255== ==11255== Invalid read of size 4 ==11255==at 0x3C808C89: wcslen (in /lib/tls/libc-2.3.2.so) ==11255==by 0x8590697: wxLocale::Init(wchar_t const*, wchar_t const*, wchar_t const*, bool, bool) (in /usr/bin/pgadmin3) ==11255==by 0x85911FB: wxLocale::Init(int, int) (in /usr/bin/pgadmin3) ==11255==by 0x81991ED: pgAdmin3::OnInit() (in /usr/bin/pgadmin3) ==11255== Address 0x3CEA907C is 8 bytes inside a block of size 24 free'd ==11255==at 0x3C01F918: free (vg_replace_malloc.c:127) ==11255==by 0x83A7508: wxWCharBuffer::~wxWCharBuffer() (in /usr/bin/pgadmin3) ==11255==by 0x859067D: wxLocale::Init(wchar_t const*, wchar_t const*, wchar_t const*, bool, bool) (in /usr/bin/pgadmin3) ==11255==by 0x85911FB: wxLocale::Init(int, int) (in /usr/b
Re: [pgadmin-support] varchar[] !?
Pedro Quaresma de Almeida wrote: Em Terça, 11 de Maio de 2004 01:08, escreveste: When I try to create a new column with the varchar datatype I obtain a "varchar[]" type, and I cannot specify the max limit. What is the problem? You are going VARCHAR[n] instead of the correct VARCHAR(n) Chris Yes, but when I try to choose the type in the types-menu the options that I have are all with square brackets "[]" and not with "()" Use varchar (varchar[] is the array version) and fill the length field. Regards, Andreas ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [pgadmin-support] problems in connecting to a server
Em Terça, 11 de Maio de 2004 10:25, Pedro Quaresma de Almeida escreveu: > Hi > >I have two Debian systems, both with > > psql (PostgreSQL) 7.4.2 > pgadmin3 1.0.2 > > but in one of them (the laptop) I am unable to make a connection with > pgadmin3, I always get: > > -- > 2004-05-11 10:13:12 ERROR : Error connecting to the server: FATAL: IDENT > authentication failed for user "pedro" > -- > > The "pedro" user has been created previously with the "createuser" command > With the debug output option on I get: --- 2004-05-11 13:46:58 INFO : Creating pgConn object 2004-05-11 13:46:58 INFO : Server name: localhost (resolved to: 127.0.0.1) 2004-05-11 13:46:58 INFO : Opening connection with connection string: hostaddr=127.0.0.1 dbname=template1 user=pedro port=5432 2004-05-11 13:46:58 STATUS : Connecting to database without password... (0,01 segundos) 2004-05-11 13:46:58 ERROR : Error connecting to the server: FATAL: IDENT authentication failed for user "pedro" 2004-05-11 13:46:59 INFO : Destroying pgConn object my "/var/lib/postgres/data/pg_hba.conf" file has in it the lines # All other connections by UNIX sockets local all all ident sameuser The user "pedro" is a valid Unix and PostgreSQL user. ??? Any help will be appreciated, thank you. -- Pedro Henrique e Figueiredo Quaresma de Almeida ---(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] not able to log in to PostgreSQL from webmin
mailer ID: [EMAIL PROTECTED] Hi !!! I am pretty new to linux and I need your help to go on with PostgreSQL database server. I did manage to install PostgreSQL on RH 9.0 and I would like to manage from webmin, I guess which is a lot easier to do not only me also for some of my co-worker. Problems, When I click on PostgreSQL Database Server icon on Webmin, there have a login dialog box appears and asking me to type user name and password as well as there have check box for Connect as same Unix user ?. No matter what I do I just got the message said that " Incorrect administration username or password. I have tried in terminal windows, I just need to type su - postgres , then I am log in to the PostgreSQL server. Please help me to able to connect or login from webmin. One other things that I need to tell you that I did download the pgAdmin III to run and create table from there. That is awesome program to run it. Anyway please help me out how to solve this problems. Thank You, Myo Htut Oo Access Spectrum Co., Ltd ---(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
