Hi,
Hello there, I am new to PostgreSQL, succeded in running a little
database on
my dev. machine and now I am having problems exporting the local
database to
the one I want to use on my site online. I am getting errors when I
try to
run the SQL online with phpPgAdmin.
What errors are
Hi Alexander,
Use 0.0.0.0/0. You can of course add multiple lines to match all your
ranges (e.g. 192.168.0.0/24, 10.0.0.0/8 etc.)
Regards,
Andy.
Alexander B. wrote:
Hi people,
I would like to configure pg_hba for any IP.
I have several network mask, some times 192..., or 10, or
right?
jing
- Original Message
From: Andy Shellam (Mailing Lists) [EMAIL PROTECTED]
To: jing han [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, February 27, 2007 10:57:09 AM
Subject: Re: [INTERFACES] where postgres 8.1.8 log messages go
Don't forget to copy back to the list
Igor Neyman wrote:
Is there a function (or catalog view) that I can call in psql and that
will tell me host name of the machine on which Postgres database is
running?
Igor
Surely you need to know this to connect to it in the first place?
Vishal Mailinglist wrote:
Hi ,
I have a program already working on LAMP architecture. Now since the
business logic is in PostgreSQL. We were interested to build the
front end on VB.net. Would like to know the readiness of PostgreSQL
working with VB.net . Would appreciate If anyone can
To all who want unsubscribing, it is best to fill out this form:
http://www.postgresql.org/community/lists/subscribe
Regards,
Andy.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
Ray Stell wrote:
I toggle log_duration:
wiki=# \!date
Mon Feb 19 11:14:35 EST 2007
wiki=# set log_duration=off;
SET
wiki=# SELECT current_setting('log_duration');
current_setting
-
off
(1 row)
yet duration continues to be logged:
wiki,13190,wiki,2007-02-19 11:16:00.926
Peter Eisentraut wrote:
Andy Shellam (Mailing Lists) wrote:
Not particularly!! Don't know what it is but it doesn't _appear_ to
be GNU. According to man make it is a FreeBSD General Command. I
can tell you that ./configure make make install works and
builds a working Postgres server just
I'm trying to compile in the adminpack into PostgreSQL 8.2.3, but it
doesn't want to build.
According to the instructions, I change into contrib/adminpack and run
make followed by make install.
However, make fails:
[EMAIL PROTECTED]
/bin/make.
Just typing make builds PostgreSQL just fine with the Unix make.
However, the contrib modules *won't* build with the Unix make - I had to
run /usr/local/bin/make instead of just make.
HTH someone,
Andy.
Andy Shellam (Mailing Lists) wrote:
I'm trying to compile in the adminpack
Tom Lane wrote:
Andy Shellam (Mailing Lists) [EMAIL PROTECTED] writes:
FYI: Reports on Google are wrong - they say that you need to use gmake
to build the PostgreSQL server source. You don't.
I can assure you that you need GNU make to build any part of Postgres.
Perhaps what you're
Chad Wagner wrote:
On 2/15/07, *Eduardo J. Ortega* [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
After erasing the less than names WAL files, we add to tar the
remaining
WAL records (0003B, 0003C and so on on the example). The more WAL
files you
have after 0003B, the
A quick Google search reveals it looks like PgAdmin's job scheduling queue:
http://archives.postgresql.org/pgadmin-support/2006-06/msg5.php
Might be worth asking on [EMAIL PROTECTED]
Andy.
Ezequias Rodrigues da Rocha wrote:
My Linux is reporting the following message:
DEBUG: Connection
Tom Lane wrote:
Cassiano, Marco [EMAIL PROTECTED] writes:
If I understand well, PgAdmin fails in composing the correct pg_dump command.
The switch combination -t collezioni -n anamat doesn't work. The
manual says that the -n switch is ignored when -t is used
The right (at least, working)
The cluster's name is only the file-system's directory path.
You can easily rename this directory, as long as you pass the relevant
directory name to pg_ctl's -D parameter (which tells PostgreSQL which
database cluster to use.)
It goes without saying, don't move the directory while
It comes under Server Startup:
http://www.postgresql.org/docs/8.2/static/server-start.html
Ray Stell wrote:
Many thx. It that in the doc?
On Thu, Feb 15, 2007 at 06:21:05PM +, Andy Shellam (Mailing Lists) wrote:
The cluster's name is only the file-system's directory path.
You
If you're running one of Windows XP SP2 or Windows Server 2003, the
Windows Firewall will be blocking the connection.
If you have the Windows Firewall option in Control Panel, check it's
disabled, then try again.
If that cures your problem, add an exception in for port 5432 before you
turn
You will always have a postmaster binary - do a find / -name
postmaster to find it.
If your secondary production server hasn't gone live yet, I'd seriously
consider starting it up on the 8.2 series.
Manish Pillai wrote:
I have installed it using rpm..So bin folder is not available
inside
You might have more luck here: http://archives.postgresql.org/pgsql-admin/
GURON Rawender wrote:
Before printing, please consider the environment.
IMPORTANT NOTICE: This e-mail and any attachment to it are intended
only to be read or used by the named addressee. It is confidential and
may
Chad Wagner wrote:
On 1/19/07, *Alexander B.* [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
I would like to know if is possible to replicate in postgres applying
binary logs (wal logs) like the same way is done on Oracle!!
Did anybody tried to do that?
You could do it, yes,
Andy Shellam (Mailing Lists) wrote:
Chad Wagner wrote:
On 1/19/07, *Alexander B.* [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
I would like to know if is possible to replicate in postgres
applying
binary logs (wal logs) like the same way is done on Oracle!!
Did anybody
I believe the option for a warm standby (which sounds like it is what
you need) was made available in 8.2.0.
You'd have to look at the manual though, I haven't had time to
investigate, and I'm not sure whether it's cluster-wide, or
database-specific.
Yogvinder Singh wrote:
Hi Ppl,
I have
to arrive and apply them on top of a base
backup.
There is a project in PgFoundry to allow for warm-standby in the 8.0 and
8.1 series, however this is reportedly built-in to 8.2 now.
-
Shoaib Mir
EnterpriseDB (www.enterprisedb.com http://www.enterprisedb.com)
On 1/17/07, *Andy Shellam
Unzip the zip file - then you'll have the MSI package.
Vasu Kamma (vakamma) wrote:
Thanks Mr Radev.
Instructions are given for .msi file , but the link has .zip file
Could you help me how I can do the silent installation.
Thanks
Vasu
-Original Message-
From: [EMAIL PROTECTED]
Marc Mamin wrote:
Hello,
I'm confused about the logging destination parameters in postgresql.conf
My Problem is that the postmaster.log is getting too large and I want
to roll it (once per day)
Following parameters apply to optional postgresql...log.
log_rotation_age = 1440
Bruno Wolff III wrote:
On Wed, Jan 10, 2007 at 10:00:37 +0200,
Achilleas Mantzios [EMAIL PROTECTED] wrote:
Στις Τρίτη 09 Ιανουάριος 2007 18:10, ο/η Andy Shellam (Mailing Lists) έγραψε:
Achilleas Mantzios wrote:
I was able to find that in FreeBSD the -U in ls (1) does the job
Andy Shellam (Mailing Lists) wrote:
Bruno Wolff III wrote:
On Wed, Jan 10, 2007 at 10:00:37 +0200,
Achilleas Mantzios [EMAIL PROTECTED] wrote:
Στις Τρίτη 09 Ιανουάριος 2007 18:10, ο/η Andy Shellam (Mailing
Lists) έγραψε:
Achilleas Mantzios wrote:
I was able to find
Negandhi, Nishith wrote:
Hi,
I need to know the create date of databases on PosegreSQL.
PG_DATABASE does not provide this information.
Are there any other system catalogs that can provide the above
information??
Thanks
!DSPAM:37,45a3b385137101969839670!
I'm sure there is (not known to me
Achilleas Mantzios wrote:
I was able to find that in FreeBSD the -U in ls (1) does the job.
However i could not find any inode creation time related info for linux
(ext3).
Anyone has any clue on that?
I believe ls -l by default shows the created time, you can switch to
show the last
Earlier this evening I made the usual mistake someone makes at some
point in their lives - and dropped a database thinking I didn't need it,
then realised later I did.
So, because I have DDL statement logging turned on, I could find the
exact time/date it happened, and attempted to restore from
Doing a quick Google search, it appears to be, you add
*Encoding*=UNICODE or whatever you want your encoding to be, in your
connection string.
Try the pgsql-interfaces list - that's more appropriate for this sort of
thing.
Sistemas C.M.P. wrote:
How can I specify the Encoding in the
Excuse the asterisks - they were added in by my mail client - it should
be Encoding=UNICODE
Andy Shellam (Mailing Lists) wrote:
Doing a quick Google search, it appears to be, you add
*Encoding*=UNICODE or whatever you want your encoding to be, in your
connection string.
Try the pgsql
Hmm OK was worth a shot - probably best bet would be to ask on
pgsql-interfaces.
Andy.
Sistemas C.M.P. wrote:
With or without asterisks it doesn't work. This string work on ODBC but not
with pgOLEDB
- Original Message -
From: Andy Shellam (Mailing Lists) [EMAIL PROTECTED]
To: pgsql
dropping a complete database?
Many thanks,
Andy.
Tom Lane wrote:
Andy Shellam (Mailing Lists) [EMAIL PROTECTED] writes:
(Note, after writing this, I tried restoring to a minute earlier (ie.
18:57:40) and still have the same problem.
The PITR recovery process in effect rolls forward until
Hi Jeanna,
Does pgAdmin give you back any error, like permission denied, or
anything like that? Can you see all the properties of the table, such
as indexes, tables etc before you open it?
As it's happening on various PCs and versions of pgAdmin, I'd hazard a
guess that it's server-side, but
One other thing I've just thought of, if you issue a manual query from
within pgAdmin - does this succeed?
Also roughly how big are the tables (i.e. number of rows) - does it help
if you set a LIMIT in the SQL clause (by default I think it's 1000 rows
but try setting a LIMIT of 1 row and see if
Hello Pete,
There is certainly a Windows command you can run that will alter the
command used to start a service - it's sc (which can also be used to
start/stop a service programmatically.)
The command syntax to modify the EXE path is:
sc config service name binpath= path to EXE
(eg.)
sc
If upgrading between minor versions in the same series (e.g. 8.1.3 -
8.1.5) you can simply use the same data directory.
However, if the major version changes (e.g. 8.1.x - 8.2.x), you must:
1. Dump the databases from your old server (preferably using the new
version client, I believe) while
Chetan Parekh wrote:
We have Postgress Database running on machine with ip address
192.168.0.1 on port no 5432.
We want to access this database from outside the firewall. Hence we
need to open port no 5432 of 192.168.01 in firewall for outside users.
But in firewall configuration we
Hi Sean,
I'm certainly not a PostgreSQL expert when it comes to large objects
etc, but there's one thing that jumps out at me here (perhaps someone
else can see the same line of thought and into more depth as I can't
think of much else to suggest?)
The logfile lines when it doesn't:
{
Hi Enrico,
The following command will get you a text file of your result-set:
# echo SELECT customer_id, first_name, sur_name FROM
users;|/usr/local/pgsql/bin/psql -U [username] -d [database] myfile.txt
# cat myfile.txt
customer_id | first_name | sur_name
Vinayak,
Please don't post twice to two different lists (four of the same posts
to both pgsql-admin and pgadmin-support.)
This clearly isn't a problem with PG Admin - so don't clutter that list
up, and don't multiple-post - it won't change anything posting twice,
and if anything you'll only
Hi Bobby,
I'd ask on the pgadmin-support list - PgAdmin's developers live there
more-so than here.
Regards,
Andy
Bobby Gontarski wrote:
I am experiencing pgAdmin (windows xp) crash whenever I try to connect to the
postgresql server (type password and hit enter). It started after
them more to go on and they'll be more likely to answer you.
Thanks,
Andy.
Iannsp wrote:
Andy Shellam (Mailing Lists) escreveu:
Hi Bobby,
I'd ask on the pgadmin-support list - PgAdmin's developers live there
more-so than here.
Regards,
Andy
Bobby Gontarski wrote:
I am experiencing
This could be implemented as a fairly simple script that does:
- Specify a base backup name (e.g. with date/time)
- Connect to postgres database
- Issue pg_start_backup('base backup name')
- Tar the data cluster directory, excluding pg_xlog
- Issue pg_stop_backup
- Compress the created archive
-
No, Pg Admin connects to 5432 as that is PostgreSQL's server port.
One popular misconfiguration I've seen is that the connection/traffic is
*to* port 5432 on the server, not from port 5432 on the client.
So, depending on your firewall you need rule 1 on it's own (if it
supports keeping
I think the above messages support the fact that the database was
shutdown
properly before the filesystem level backup.
Can anyone kindly confirm it ?
LOG: database system is ready
Says it all - if it hadn't been, you'd have gotten LOG: database system
was not shut-down cleanly, recovering
For a long time, I did not know how to use notepad to save something
with a suffix other than .txt
and then someone showed me that if you psql.bat , and choose
allfiles type, then it will save with the .bat ending.
Or,
Regarding point 1, Scott, the user is on Windows.
Windows binaries are available at www.postgresql.org and a lot has
changed in the last 2 years, so if you do go down the re-install route,
I'd recommend upgrading, although you'll have to dump your old data out
of the server first, then
I'm guessing by the postmaster.exe that this is on Windows.
In that case, find PostgreSQL X.Y in Control PanelAdministrative
ToolsServices (where X.Y is your major.minor version number of Postgres.)
Change the services' start-up type to Manual (so you can start it
yourself when needed.)
to run a restore test, but the backup and automatic archive
clearout is working nicely.
I'm not too worried about the SQL function to find the current WAL file,
although I can see this could be useful too.
Thanks,
Andy.
Simon Riggs wrote:
On Tue, 2006-11-07 at 13:12 +, Andy Shellam
and
after the /, which works.
Andy.
Jim C. Nasby wrote:
On Tue, Nov 07, 2006 at 01:12:53PM +, Andy Shellam (Mailing Lists) wrote:
Hi,
I'm writing an automated file-system level backup application for use
with WAL archiving, that will issue the pg_start_backup call, tar and
gzip
Hi,
I'm writing an automated file-system level backup application for use
with WAL archiving, that will issue the pg_start_backup call, tar and
gzip the cluster data directory, issue the pg_stop_backup call, and
remove all previous un-needed WAL files from the archive.
I need to write a
).
Can someone confirm this is the correct case?
Thanks,
Andy.
Original Message
Subject:Checkpoint Location Format
Date: Tue, 07 Nov 2006 13:12:53 +
From: Andy Shellam (Mailing Lists) [EMAIL PROTECTED]
To: pgsql-admin@postgresql.org
Hi,
I'm writing
On a standard Windows client connecting to a 2003 server, you can run
mstsc /console to force Windows to re-direct the console to you.
Andy.
[EMAIL PROTECTED] wrote:
Hi,
hope to not be OT. I'm trying to install PostGresql into a virtual sever,
I've set the ConnectionName = Console as
55 matches
Mail list logo