[3]['pg_dumpall_path'] = '/usr/bin/pg_dumpall';
> Not sure if that is what your question refers to...
>
I was referring to the "host" setting. If you get the password fixed where it
works with psql and it still does not work with phpPgAdmin, try changing the
host setting to 127.0.0.1.
John DeSoi, Ph.D.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
it is not
127.0.0.1, you might need to use the explicit IP address in your pg_hba.conf.
Best,
John DeSoi, Ph.D.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
you changed "trust" to "md5" host or local? I
think phpPgAdmin uses only host connections.
John DeSoi, Ph.D.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
d talk directly to Postgres from the browser:
http://ajaxian.com/archives/tcpsocket-sockets-in-the-browser
http://www.postgresql.org/docs/9.0/interactive/protocol.html
I'm not saying this is the right approach, but if that is what you are really
after...
John DeSoi, Ph.D.
--
Sent
hen you want to apply the changes to your production database?
John DeSoi, Ph.D.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
ibpq library for querying database.
> I am having two different processes accessing the same database.
Are you using a different connection for each process?
John DeSoi, Ph.D.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http:/
options where it would be huge code bloat to include sufficient
alternatives?
John DeSoi, Ph.D.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
You might also try setting
the logging to the highest level and then generate your diagrams with
ADS. Check to see if there are errors or any differences in the SQL
statements executed.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(e
p; /
usr/bin/tar xf - )
/usr/bin/tar: index.html: Cannot open: File exists
/
Why not just move (or delete) the existing PostgreSQL directory
before make install?
If you want to check out what is already there, start Terminal and type:
open /usr/local/pgsql
John DeSoi, Ph.D.
http://pged
. Change newvalue to text and cast it from an integer, if
necessary. Then you want:
execute 'ALTER sequence safeopencloseoperation_id_seq restart with
' || newvalue ;
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of b
down another path when you are close, you
might want to look at this distribution and instructions:
http://www.entropy.ch/software/macosx/postgresql/
If you still don't have initdb working, you might want to rename your
postgres user and create a new one as described in these instru
QL8/data -l /Library/PostgreSQL8/log/PostgreSQL8.log -o -i'
Is there a valid cluster created in /Library/PostgreSQL8/data? You
should also be able find what went wrong by looking in the PostgreSQL
log file which is the path specified by -l above.
John DeSoi, Ph.D.
http://pgedit.com/
P
rge.net/project/showfiles.php?
group_id=133151&package_id=147282
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
eforge project admins for
help on their list or forum. They just put out a new version, so I'm
sure they would be interested to know if there are problems.
John
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)-
admin tools:
http://sourceforge.net/projects/pgsqlformac/
It appears to have been updated recently with the latest version of
PostgreSQL.
John
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 4
large amounts of data.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
ee the issue if users don't connect directly to the
database, only through your web application. You then have complete
control over any query executed. You should not have to worry about
SQL injection if you use prepared queries and stored procedures.
John DeSoi, Ph.D.
http://pgedit.
Jeffrey J. Early wrote:
Picking up a database cluster and moving it from system to system
*does*
seem to work without a hitch as long as the username is the same on
each
system. So it seems to me there has to be a fairly simple solution
to make
this work.
John DeSoi, Ph.D.
http://
changing time value, but any looping you do in plpgsql will eat a lot
of CPU cycles. The only other solution I recall was to use a
different pl language like perl which has a proper sleep function.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
, it is correct assuming the data in the file is really latin1 :).
You tell PostgreSQL what character set you are using on the client
side and it takes care of converting it to the encoding used for the
database.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
On Jul 19, 2006, at 12:21 AM, vamsee movva wrote:
could you please tell me if there are any dataware housing tools
for postgresql
http://www.greenplum.com/products/bizgresMpp.php
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of
thread for some ideas and solutions.
http://archives.postgresql.org/pgsql-general/2006-05/msg01457.php
It would be nice to have a built-in function to make a best effort
character conversion rather than generating errors.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
actly what the error is. Show the
commands you used to dump and restore and include the exact error
output from the restore operation.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 5: don'
been dumping and rebuilding for
the
last 6 years (pg version 7).
I would have concerns about going from a newer version to an older
version (the other way around is less problematic). But you gave no
clues about specific errors or the format of the dump you are trying
to load.
John
, you need to look at your client setup especially
encoding issues.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe
jects.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
very different.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
My reason for wanting to turn it off is that every time it would run
the fans on my development system would rev up. Very annoying in a
quiet environment where you are working on throw away tests that
don't need to eat CPU for vacuuming.
John DeSoi, Ph.D.
http://pge
hing else.
inconv might be able to help you fix encoding problems
http://www.gnu.org/software/libiconv/documentation/libiconv/iconv.1.html
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 4: Have you searched
bottom of the page (and in the readme file) has
links for step-by-step instructions and frequently asked questions.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 5: don't forget to increase
pg_hba.conf entries and the exact psql
connect command/error.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail
ddress changes. I would also like to see DNS names supported in
pb_hba.conf.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On Sep 9, 2005, at 2:06 PM, [EMAIL PROTECTED] wrote:
Hi, how can I run a pg_dump from window Xp without ask me the password
so I can scheduling my database backup?
Thx!
http://www.postgresql.org/docs/8.0/interactive/libpq-pgpass.html
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for
/8.0/interactive/libpq-pgpass.html
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
fficient wastes CPU cycles busy looping. I use the version below
for some simple testing, but it is not useful for a production
system. It would be nice to have a sleep function that does not
require anything beyond plpgsql.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreS
it'd
be nice to have some functions in core that did the same thing; or
maybe
some ability in psql to do it.
Also, there are some pl/pgsql functions available from here which
will GRANT/REVOKE on all tables:
http://pgedit.com/node/20
John DeSoi, Ph.D.
http://pgedit.c
columns as primary key also provides
metadata about the design of the schema, as a primary key implies that
other tables may rely on this set of columns as a unique identifier
for rows.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of
On May 18, 2005, at 9:27 AM, Ing. Jhon Carrillo wrote:
I need to transfer the database/server A to database/server B through
the
some command directly.
pg_dumpall might be what you are looking for.
http://www.postgresql.org/docs/8.0/interactive/app-pg-dumpall.html
John DeSoi, Ph.D.
http
master.
Any suggestion ?
A few options -
Free:
http://gborg.postgresql.org/project/slony1/projdisplay.php
Commercial:
http://www.commandprompt.com/products/mammothreplicator/
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast
. every time I try to use:
pg_passwd or alter user
I get the following message:
command not found
createdb and createuser are command line utilities. For executing other
SQL commands such as "ALTER USER" you want to use psql. Look in the
documentation index under "psql" for d
service.
Look in the pg_log folder inside your data directory. The latest log
file might give a better clue as to why the database server won't
start.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)--
Slony:
http://www.onlamp.com/pub/a/onlamp/2004/11/18/slony.html
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
teractive/postmaster-start.html
I have not installed this way, but maybe there is (or should be) a
script in the Start menu group to do this?
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
backup databases
of the correct version.
One idea is to use "pg_ctl.exe status" to determine if the server
associated with the registry entry is running. I think you'll also need
to specify the data directory with this command, so hopefully that is
in the registry also.
John De
, you might want to take a look
at the installer source file (a Wix xml document) for the exact
registry setup.
http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broa
a way to
directly query the database. There are may companies providing shared
hosting. I'm not aware of any security issues.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 2: you can get off al
ght way to add a user ? am i wrong ?
i dont want to let my new user view the others databases on the server.
Viewing the information in the system catalogs is open to all users.
There is not a way to hide it unless you build an interface on top of
PostgreSQL that limits the queries the user can exec
On Mar 22, 2005, at 12:19 PM, Dr. Roger Wießner wrote:
Is there an easy way to ´GRANT ALL TO PUBLIC´?
It is very tedious to write all the necessary grant-statements...
You can find some functions to do this at
http://pgedit.com/node/view/20
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for
.
But I did not understand that syntax well enough from the response.
Any one do this in 8 (I am on 8.01) or no of a gui tool?
phpPgAdmin has an interface for altering column types.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast
n see the problem.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
messag
unicode character.
See http://www.unicode.org/ and
http://www.unicode.org/faq/utf_bom.html.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
you started:
http://www.devx.com/opensource/Article/21674
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
On Mar 16, 2005, at 8:09 AM, Wes Williams wrote:
phpPgAdmin was as exhaustive as phpMyAdmin,
more users might be FIRST inclined to start with Postgres
I'm not familiar with phpMyAdmin. Could you give a few examples of
things it has that phpPgAdmin is lacking?
Thanks,
John DeSoi, Ph.D.
mme\PostgreSQL\8.0\bin\phprvitadb200503082100.dump -U gsc
phprvitadb
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
ough the Sys V init scripts as stated in the
PostgreSQL INSTALL file that came with the source
code.
Restarting the machine is just fine. But in cases where you want to
keep the database operational and have configuration file changes take
effect, you signal the postmaster process. You can use the
md5
After changing this be sure to signal or restart PostgreSQL.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
On Mar 9, 2005, at 4:24 PM, Scott Marlowe wrote:
assuming you're on an rpm based system, look for the readline-devel rpm
package and install it. Same a go for a few other packages, like
zlib-devel.
And if not and you don't need readline just use
./configure --without-readline
John D
if you startup psql with the
-E option it will show you all the SQL it is using to run the \d
command. It should be fairly easy to get the strings you need from the
results of running a similar query. The psql source is a good place to
look also.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools
you can
use to determine if there is a mismatch.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
y sees the service a/c). Even if it did i
think there might be issues when it prompts for a password. I am
logged into my machine as my Windows user name.
The password issue can be resolved with the pgpass file:
http://www.postgresql.org/docs/8.0/interactive/libpq-pgpass.html
John DeSoi,
ql.org/docs/8.0/interactive/installation.html
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(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
set of users.
http://www.postgresql.org/docs/8.0/interactive/sql-creategroup.html
The GRANT command is used to give permissions for specific operations
to users and/or groups.
http://www.postgresql.org/docs/8.0/interactive/sql-grant.html
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for Postgr
also a PGPASSWORD environment variable, but this is
depreciated for security reasons.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
sults if any problems arise.
$psql -o myoutput dbname < sqlfile
See the psql section in the manual for more options to control the
output.
Best,
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 9: the p
nd prompt (not the psql prompt). Apologies if
you know all this and I have just misunderstood your description of the
problem.
Post the error output from createdb if you still can't get it to work.
Best,
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
-
65 matches
Mail list logo
