Re: [pgadmin-support] Query tool not working
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ryan DobbsSent: 03 March 2006 03:20To: pgadmin-support@postgresql.orgSubject: [pgadmin-support] Query tool not working Hi,I am new to postgeSQL and have recently installed version 8.1 on my local machine.I am running Windows XP Pro and am using pgAdmin III version 1.4.1I created a database with all the required tables and columns. I have also created all the primary keys and foreign keys and can view/ created columns and tables and sequences. At the moment there is no data within the tables. The problem is, when I use the query tool to do a select all statement, It comes back with an error message saying the the table could not be found. I have tried it on most of the tables, but get the same error message. I am spelling the name of the table correctly. Any ideas on how to fix this? Would it have something to do with permissions? Unlikely - it would say so if that were the case. I suspect you have either used upper case characters in your table name, and then not quoted it in your query - eg. SELECT * FROM "FoO" or, created the table in a schema not in the current search path, and not qualified the name, such as: SELECT * FROM myschema.foo Regards, Dave.
Re: [pgadmin-support] Difficulties Connecting on localhost
Lane Van Ingen wrote: Thanks for your suggestions. I followed through on suggestions below, but I am having a lot of problems. Probably the basic problem is that I have RedHat ES (Enterprise) 3.0, and the nearest I can find on www.postgres.org for pgAdmin3 is a Fedora version; it keeps asking me for more and more libraries as I try to install the rpm. That is part of the reason I tried to install an older version of pgAdmin, as I was hoping to avoid a lot of new requirements that might not be supported on an older (2 yrs old?) Linux server. If I drop back from PostgreSQL v 8.1.2 to 8.0.7, will pgAdmin 1.2 work with it? Yes, but I certainly won't recommend downgrading (while pgsql backports fixes, we don't because pgAdmin is always backward compatible). I'd suggest building the latest pgAdmin from source. Regards, Andreas ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[pgadmin-support] Unicode characters in query results
Hello, I am using pgAdmin III 1.4.1 on windows xp(sp2). I am having trouble viewing unicode characters in the query results window. I have tried a couple of different fonts that I know should display the characters properly (mostly french accented characters) but they still don't come out right. Any ideas? Thanks Adam ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[pgadmin-support] Compiling pgadmin on Red Hat Enterprise 4
Hi,I was trying to install pgadmin with src packs. I installed all requirements but i founded some errors.Report: - The version of pgadmin: pgadmin3-1.4.1- Operational system: Red Hat Enterprise 4, kernell version 2.6.9-11.ELsmp- wxGTK-2.6.2 if below command lines: cd wxWidgets* ./configure --with-gtk --enable-gtk2 --enable-unicode --enable-mimetype=no make sudo make install- libxml2-2.6.16-1.i386.rpm- PostgreSQL version: postgresql-8.1.3 ./configure gmake su gmake install adduser postgres mkdir /usr/local/pgsql/data chown postgres /usr/local/pgsql/data su - postgres /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 & /usr/local/pgsql/bin/createdb test /usr/local/pgsql/bin/psql testWhen i tried to instal do pgadmin: ./configure .. Ok! make all . Error! ... In file included from ../src/include/pgAdmin3.h:22, from ./pgAdmin3.cpp:13: ../src/include/ctl/ctlSQLBox.h:17:24: wx/stc/stc.h: File not founded! In file included from ../src/include/pgAdmin3.h:22, from ./pgAdmin3.cpp:13: ../src/include/ctl/ctlSQLBox.h:23: error: expected class-name before '{' token ./pgAdmin3.cpp:60:24: wx/ogl/ogl.h: File or Directory not founded ./pgAdmi
n3.cpp:
In member function `virtual bool pgAdmin3::OnInit()': ./pgAdmin3.cpp:341: error: `wxOGLInitialize' undeclared (first use this function) ./pgAdmin3.cpp:341: error: (Each undeclared identifier is reported only once for each function it appears in.) make[2]: ** [pgAdmin3.o] Error 1 make[2]: Leaving directory `/usr/local/pgadmin3-1.4.1/src' make[1]: ** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/pgadmin3-1.4.1' make: ** [all] Error 2
How to
solve this problem? Best regards,Rômulo.
Yahoo! Search
Dê uma espiadinha e saiba tudo sobre o Big Brother Brasil.
[pgadmin-support] Compiling pgadmin on Red Hat Enterprise 4
Hi,I was trying to install pgadmin with src packs. I installed all requirements but i founded some errors.Report:- The version of pgadmin: pgadmin3-1.4.1- Operational system: Red Hat Enterprise 4, kernell version 2.6.9-11.ELsmp- wxGTK-2.6.2 if below command lines: cd wxWidgets* ./configure --with-gtk --enable-gtk2 --enable-unicode --enable-mimetype=no make sudo make install- libxml2-2.6.16-1.i386.rpm- PostgreSQL version: postgresql-8.1.3 ./configure gmake
su gmake install adduser postgres mkdir /usr/local/pgsql/datachown postgres /usr/local/pgsql/data su - postgres /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 & /usr/local/pgsql/bin/createdb test /usr/local/pgsql/bin/psql testWhen i tried to instal do pgadmin:./configure .. Ok!make all . Error!...In file included from
../src/include/pgAdmin3.h:22, from ./pgAdmin3.cpp:13:../src/include/ctl/ctlSQLBox.h:17:24: wx/stc/stc.h: File not founded!In file included from ../src/include/pgAdmin3.h:22, from ./pgAdmin3.cpp:13:../src/include/ctl/ctlSQLBox.h:23: error: expected class-name before '{' token./pgAdmin3.cpp:60:24: wx/ogl/ogl.h: File or Directory not
founded./pgAdmin3.cpp: In member function `virtual bool pgAdmin3::OnInit()':./pgAdmin3.cpp:341: error: `wxOGLInitialize' undeclared (first use this function)./pgAdmin3.cpp:341: error: (Each undeclared identifier is reported only once for each function it appears in.)make[2]: ** [pgAdmin3.o] Error 1make[2]: Leaving directory `/usr/local/pgadmin3-1.4.1/src'make[1]: ** [all-recursive] Error 1make[1]: Leaving directory `/usr/local/pgadmin3-1.4.1'make: ** [all] Error 2How to solve this problem? Best regards,Rômulo.
Yahoo! Acesso Grátis
Internet rápida e grátis. Instale o discador agora!
Re: [pgadmin-support] Compiling pgadmin on Red Hat Enterprise 4
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Rômulo Lucio
Vale de MoraesSent: 03 March 2006 16:08To:
pgadmin-support@postgresql.orgSubject: [pgadmin-support] Compiling
pgadmin on Red Hat Enterprise 4
When i tried to instal do
pgadmin:./configure .. Ok!make all .
Error!...In file included from
../src/include/pgAdmin3.h:22,
from ./pgAdmin3.cpp:13:../src/include/ctl/ctlSQLBox.h:17:24: wx/stc/stc.h:
File not founded!In file included from
../src/include/pgAdmin3.h:22,
from ./pgAdmin3.cpp:13:../src/include/ctl/ctlSQLBox.h:23: error: expected
class-name before '{' token./pgAdmin3.cpp:60:24: wx/ogl/ogl.h: File or
Directory not founded./pgAdmi n3.cpp: In member function `virtual bool
pgAdmin3::OnInit()':./pgAdmin3.cpp:341: error: `wxOGLInitialize'
undeclared (first use this function)./pgAdmin3.cpp:341: error: (Each undeclared
identifier is reported only once for each function it appears in.)make[2]: **
[pgAdmin3.o] Error 1make[2]: Leaving directory
`/usr/local/pgadmin3-1.4.1/src'make[1]: ** [all-recursive] Error 1make[1]: Leaving
directory `/usr/local/pgadmin3-1.4.1'make: ** [all]
Error 2How to solve this problem?
Install the wx contrib modules, per the instructions at http://www.pgadmin.org/download/source.php
Regards, Dave.
[pgadmin-support] How to run pgAdmin?
Hi! I installed the pgAdmin III, but when i try to run: bin/pgamin ... bin/pgadmin3: error while loading shared libraries: libpq.so.4: cannot open shared object file: No such file or directory How to run? Regards, Rômulo. __Faça ligações para outros computadores com o novo Yahoo! Messenger http://br.beta.messenger.yahoo.com/
Re: [pgadmin-support] Unicode characters in query results
Adam Albrechtas wrote: Hello, I am using pgAdmin III 1.4.1 on windows xp(sp2). I am having trouble viewing unicode characters in the query results window. I have tried a couple of different fonts that I know should display the characters properly (mostly french accented characters) but they still don't come out right. Any ideas? Data is probably stored in a database with incorrect encoding. Regards, Andreas ---(end of broadcast)--- TIP 6: explain analyze is your friend
[pgadmin-support] PgAgent should probably exclude Power Users group on Windows
Just chased this one down. I knew that neither PostgreSQL nor PgAgent would let you fire up under an Administrator account, but since PgAgent would work under a Power User account, I left my PgAgent account as a Power User and then switched PG to that account. Big oopsie. For uniformity, PgAgent should check for the Power User thing as well. Also, where do the log entries go that indicate failure because the user account is too powerful? Thanks, Steve Carrow ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[pgadmin-support] Run pgadmin3. Problem with libpq.so.4.
Hi, I just try to run ./pgadmin3 , but i found the error: ./pgadmin3: error while loading shared libraries: libpq.so.4: cannot open shared object file: No such file or directory Thanks, Rômulo. __Faça ligações para outros computadores com o novo Yahoo! Messenger http://br.beta.messenger.yahoo.com/
Re: [pgadmin-support] PgAgent should probably exclude Power Users
On 3/3/06 18:35, "Steve Carrow" <[EMAIL PROTECTED]> wrote: > Just chased this one down. I knew that neither PostgreSQL nor PgAgent > would let you fire up under an Administrator account, but since PgAgent > would work under a Power User account, I left my PgAgent account as a > Power User and then switched PG to that account. Big oopsie. For > uniformity, PgAgent should check for the Power User thing as well. Also, > where do the log entries go that indicate failure because the user > account is too powerful? PgAgent doesn't care what account you run it under at all. PostgreSQL runs under a limited account only to minimise the damage that can be done by an attacker that manages to compromise the server somehow. PgAgent is a different class of app - it's not a server and doesn't allow a (potentially unknown) attacker any way to connect to it. PgAgent has legitimate uses that may require administrative rights. The security risk in this case is allowing low privilege users to schedule jobs to be run by an agent with privileges they don't have. To prevent this, you must secure the pgagent schema & configuration tables in the database, and ensure that the unprivileged user cannot modify the database connection in any way, for example by hacking the service config in the registry, or by modifying DNS or hosts file entries to cause the agent to connect to the wrong server. Regards, Dave. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [pgadmin-support] Run pgadmin3. Problem with libpq.so.4.
Title: Re: [pgadmin-support] Run pgadmin3. Problem with libpq.so.4. On 3/3/06 19:18, "Rômulo Lucio Vale de Moraes" <[EMAIL PROTECTED]> wrote: Hi, I just try to run ./pgadmin3 , but i found the error: ./pgadmin3: error while loading shared libraries: libpq.so.4: cannot open shared object file: No such file or directory Hi, You need to add the PostgreSQL lib directory that pgAdmin was compiled against to /etc/ld.so.conf and run ldconfig. Assuming you’re running linux that is. Not sure about FreeBSD or Solaris. Regards, Dave.
