[ADMIN] file permissions for /usr/bin/postgres

Hi Can someone please advise what the most secure permissions are allowed for /usr/bin/postgres ? At the moment we have: -bash-3.2# ls -lt /usr/bin/postgres -rwxr-xr-x 1 root root 4574696 Jan 28 19:31 /usr/bin/postgres This is not considered secure. Regards, Andy V Smith Global Database

Re: [ADMIN] file permissions for /usr/bin/postgres

Hi Can someone please advise what the most secure permissions are allowed for /usr/bin/postgres ? At the moment we have: -bash-3.2# ls -lt /usr/bin/postgres -rwxr-xr-x 1 root root 4574696 Jan 28 19:31 /usr/bin/postgres This is not considered secure. Regards, Andy V Smith Global Database

[ADMIN] PostgreSQL 9.0

Hi We are looking to use PostgreSQL as a database for our development community and I would like to know if I can be guided to a list of packages and dependencies, which will allow me to install the product in a Red Hat Linux 5.5. environment. Thanks and regards, Andy V Smith CATE - Global

Re: [ADMIN] Help me understanding the schema

bles control user access. I thought that a user also had to have the USAGE right on a schema? In an application I'm working on at the moment, it threw the error "permission denied on schema xxx" even if permissions on the tables within the schema were OK - I had to assign the US

Re: [ADMIN] Help With Database Backup

ta at once). I believe if you don't select "schema only" you get schema and data. Regards, Andy -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Avoid duplicated rows when restoring data from pg_dumpall ??

atabase - it's an empty database that's created when the server is initialised so you've got something to connect to. It's safe to delete, as long as you have another database you can connect to, but there's no real reason to unless it's in your restore script

Re: [ADMIN] Background color in query tool

question on the PgAdmin list - http://archives.postgresql.org/pgadmin-support/. This list is for administration of the PostgreSQL server, not the client tools. Cheers, Andy -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http

Re: [ADMIN] Compile errors when building 32-bit on 64-bit system

FWIW, it does appear that 8.4 makes this better. OK cheers, I have got plans to migrate over the next month or two; just wanted to point out the issue. Andy -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [ADMIN] Compile errors when building 32-bit on 64-bit system

That sounds like you hadn't yet figured out to set CFLAGS too. Google or no Google, you're setting the wrong variable. I had to install PG 8.3.7 on another couple of machines today, and got exactly the same issue (setting all 3 variables) again on the SPI module. Please see as follows

Re: [ADMIN] Compile errors when building 32-bit on 64-bit system

Tom, That sounds like you hadn't yet figured out to set CFLAGS too. Actually if you see my first post, the only thing I'd changed was replaced "LDFLAGS="-m32"" with the "LD" variable and I had also tried adding that back in alongside CFLAGS and LD but to no avail. I compiled the module by

Re: [ADMIN] Compile errors when building 32-bit on 64-bit system

(which it was trying to create as 32-bit.) A quick Google revealed setting that flag in the LD environment variable, which got it a bit further but then bought up this error. Everything else compiled fine then, it's just the contrib/spi module. Andy -- Sent via pgsql-admin maili

[ADMIN] Compile errors when building 32-bit on 64-bit system

o refint.o The first command (the compile) has the "-m32" flag set, however the linking command doesn't - causing the above message. If I run the above 2 commands manually, but add "-m32" in the second one (i.e. gcc -m32 -shared -o refint.so refint.o) it succeeds. Th

Re: [ADMIN] PHP cann't access to postgres databse

If it was trying to get that sort of connection, rather than TCP/IP, the message would be different. Something like: # could not connect to server: No such file or directory # Is the server running locally and accepting # connections on Unix domain socket "/tmp/.s.PGSQL.5432"? Ah ye

Re: [ADMIN] PHP cann't access to postgres databse

Because the error is "Permission denied", I'm guessing it's permissions on the /tmp/.s.PGSQL.5432 socket that will need checking? The OP's PHP script when run standalone is probably running as root. don...@caltech.edu wrote: the error message in Apache error-log is " PHP Warning: pg_connect()

Re: [ADMIN] Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data unusable

different directory to be able to dump/reload the database. My 2p. Regards, Andy -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] pg_dump not appending sequence to default values

7;t appear to be the case. You need to show us what you actually did, not an interpretation of what happened that is based on a faulty mental model. I've outlined the exact steps above using as minimal a test case as possible, and attached the associated SQL dump. Regards,

Re: [ADMIN] pg_dump not appending sequence to default values

lause, then after pg_dump has "dumped" it, within the SQL file it's gone and been replaced with a "SET search_path..." clause. When this SQL dump is restored, the schema is missing from the nextval() clause because of the "SET search_path" that pg_dump set. I

[ADMIN] pg_dump not appending sequence to default values

ave to manually edit it. Is this a known issue? I know a work-around is to include every schema name in the user's search path, but it's still annoying it's not re-created as it was originally. Thanks, Andy -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] reindexdb -t schema.table name

d mydb -t "system"."supplier" -e REINDEX TABLE "system"."supplier"; but: # ./reindexdb -h localhost -d mydb -t system.supplier -e REINDEX TABLE "system.supplier"; would still remain the same because it wasn't correctly quoted. Note: this does

Re: [ADMIN] reindexdb -t schema.table name

REINDEX TABLE "system.supplier"; According to the documentation for 8.3.7 (the version I'm running) this syntax should work: Name REINDEX— rebuild indexes Synopsis REINDEX { INDEX | TABLE | DATABASE | SYSTEM } name [ FORCE ] . name ... Index and table names can be schem

Re: [ADMIN] Security question UNIX Sockets vs CIDR style access

I think you're confusing the here. PS. That should have been "I think you're confusing concepts here" - deleted the wrong word! -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Security question UNIX Sockets vs CIDR style access

commended for trusted networks where it's not possible for a hacker to gain access (i.e. a private network not connected to the outside world) so is insecure. The remaining options, in my opinion, are only useful if they fit your particular environment - for example, LDAP to authentic

Re: [ADMIN] Getting image from a DB

user's browser from your application. Regards, Andy Félix Sánchez Rodríguez wrote: Hi: Has anybody here had to capture an image from a PostgreSQL Data Base using PHP?? I used a simple query: select photo from people where id = 3, for instance. The problem is that when I write the image

Re: [ADMIN] How to run PostgreSQL?

PostgreSQL server, why are you using 8.2.11? For starters, the 8.3 branch is the most recent, with 8.3.7 being the current release of that branch, but there's also a more recent 8.2 release than the one you've just installed, 8.2.13. Ray, I agee with your comment; I always prefer sour

Re: [ADMIN] 8.3 RC1 - Logging and filenames

o I can predict what the log file's name is. Our rotation system will then rotate the log and keep the name in the same format as all our other services. Andy On 1/11/08, Tom Lane <[EMAIL PROTECTED]> wrote: > > "Joshua D. Drake" <[EMAIL PROTECTED]> writes: > >

[ADMIN] 8.3 RC1 - Logging and filenames

Default is # off, meaning append to existing files # in all cases. log_rotation_age = 0# Automatic rotation of logfiles will # happen after that time. 0 to disable. log_rotation_size = 0 # Automatic rotation of logfiles will Regards, Andy

Re: [ADMIN] Configure pg_hba.conf

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

Re: [ADMIN] Parse the DF file to table

docs/8.2/static/sql-copy.html Andy. Trula Thomas wrote: Hello, please show me how to parse the disk file to table. Thank you in advance. Trula Ahhh...imagining that irresistible "new car" smell? Check out new car

Re: [Spam] Re: [ADMIN] How to compile with different MAXALIGN?

is is possible with Slony? Andy. Sean Murphy wrote: We're talking about 12 GB of data... to do the [probably ill-fated] binary copy in any reasonable amount of time required a portable hard drive and sneaker-net... That's why I'm anxious, probably to the point of stupidity, to avo

Re: [ADMIN] How to compile with different MAXALIGN?

the data, the time it takes to transfer the dump to your new machine, and the time it takes to restore it. Andy. Sean Murphy wrote: I'm in the process of moving a large database from an in-house Win32 server to a co-located Ubuntu Linux server. The data's in constant use, so I can&

Re: [ADMIN] security question

One quick point - you don't need to alter anything in the template1 database to set user's passwords. In PgAdmin III - use the "Login roles" section to set the passwords - that way everything will get committed correctly. Also, have you restarted PostgreSQL since changin

Re: [ADMIN] Running in single instance mode

Remove other users' entries in pg_hba.conf so it only allows your username from your machine. Andy. Karthikeyan Sundaram wrote: Hi Everybody, We are using postgres 8.1.0. I want to do some maintenance work. Hence, I want to run postgres in single user mode so that external p

Re: [ADMIN] pg_hba.conf & putty

What address are you using for "server.ip.address"? I believe this is the address you should put in your pg_hba.conf, not 127.0.0.1. Then in PgAdmin, connect to localhost:5432. You can always check your PostgreSQL logs and see what source address the request is coming from. And

Re: [ADMIN] [INTERFACES] where postgres 8.1.8 log messages go

it's on the right list, more people can chip in and help - I'd advise joining pgsql-admin if you haven't already. Andy. jing han wrote: Hi Andy, Thank you so much for your help. I think what you said are perfectly right. But I still encountered strange problem. I added

Re: [ADMIN] host name?

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?

Re: [ADMIN] PostgreSQL and VB.net

Npgsql hang out on [EMAIL PROTECTED] so could be worth dropping a question on there. http://pgfoundry.org/projects/npgsql Andy.

Re: [ADMIN] [pgadmin-support] UNSUBSCRIBE

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? http://www.postgresql.org

Re: [ADMIN] log_duration?

broadcast)--- TIP 5: don't forget to increase your free space map settings !DSPAM:37,45d9d01c18514452914812! Probably best to restart Postgres, yes. I've observed logging functions to not take effect without a restart. Andy.

Re: [ADMIN] 8.2 Admin Pack broken?

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 &&

Re: [ADMIN] 8.2 Admin Pack broken?

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

Re: [ADMIN] 8.2 Admin Pack broken?

sion of make exists under "/usr/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, An

[ADMIN] 8.2 Admin Pack broken?

r/software/cache/postgresql-8.2.3/src/../src/nls-global.mk", line 29: Need an operator --8<-- 4 more of the above line--8<-- Error expanding embedded variable. [EMAIL PROTECTED] /endeavour/software/cache/postgresql-8.2.3/contrib/adminpack]$ This is on FreeBSD 6.1, I've built

Re: [ADMIN] Debug (is it PostgreSQL?)

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: Conne

Re: [ADMIN] WAL files backup

the full backup runs at 2am, so it's a waste of resources to keep them around or to worry about backing them up after this time. Andy.

Re: [ADMIN] rename a cluster

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

Re: [ADMIN] rename a cluster

--(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster !DSPAM:37,45d4a8511420134615! -- Andy Shellam NetServe Support Team the Mail Network "an alternative in a standardised world" p: +44 (0) 121 288 0832/0839 m: +44 (0) 7818 000834

Re: [ADMIN] PgAdmin : table backup problem

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)

[ADMIN] Re: Θέμα: Re: [ADMIN] possi ble Bug in windows version ?

432 before you turn the firewall back on. Andy. gpio Oxxce wrote: Hi Paul, All, My host pg_hba.conf: host all all 127.0.0.1/32 md5 hostall all 192.168.1.1/32 trust hostall all 192.168.1.2/32

Re: [ADMIN] Postgres is not starting or stopping

ous fares is fun. Let Yahoo! FareChase search your favorite travel sites <http://farechase.yahoo.com/promo-generic-14795097;_ylc=X3oDMTFtNW45amVpBF9TAzk3NDA3NTg5BF9zAzI3MTk0ODEEcG9zAzEEc2VjA21haWx0YWdsaW5lBHNsawNxMS0wNw--> to find flight and hotel bargains. !DSPAM:37,45c34f2c118211085466303! -- Andy Shellam NetServe Support Team the Mail Network "an alternative in a standardised world" p: +44 (0) 121 288 0832/0839 m: +44 (0) 7818 000834

Re: [ADMIN] unsubscribe

are not necessarily the views of the RTA. If you receive this e-mail in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or use any part of this e-mail if you are not the intended recipient. !DSPAM:37,45c11c5f118218703124696! -- Andy

Re: [ADMIN] Another way to Replicate

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!!

Re: [ADMIN] Another way to Replicate

Chad Wagner wrote: On 1/19/07, *Alexander B.* <[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,

Re: [ADMIN] Incremental Backup of a particular database

new WAL logs 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

Re: [ADMIN] Incremental Backup of a particular database

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

Re: [ADMIN] windows silent installer .msi file

TIP 6: explain analyze is your friend ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate !DSPAM:37,45a79d8913710645842! -- Andy Shellam Net

Re: [ADMIN] configuring the postmaster.log

I set redirect_stderr = on in postgresql.conf ? Setting "redirect_stderr = on" will mean that all errors that would normally appear on the console that started the Postmaster will be sent to log_filename instead.. -- Andy Shellam NetServe Support Team the Mail Network "an alt

Re: [ADMIN] Can not connect to database in Workgroup-Net on Windows-XP

Firstly it would be helpful to say what error you're getting on the client side. At a quick guess, I would say it's because you've got 2 "0.0.0.0" declarations in your pg_hba.conf - you only need the one - like this: hostall all 0.0.0.0/0 md5 Regard

Re: [ADMIN] Database Create Date

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 t

Re: [ADMIN] Database Create Date

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) do

Re: [ADMIN] Database Create Date

w the last modified time using "ls -l --time=atime" Also in FreeBSD (at least, 6.1) there is no "-U" option to ls; there is a "-u" option but this shows the last access, not the creation time. -- Andy Shellam NetServe Support Team the Mail Network

Re: [ADMIN] Database Create Date

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 atm)

Re: [ADMIN] Can't See Data - Plz Help!

and see if that comes back.) Andy. Jeanna Geier wrote: Thanks for the reply, Andy. No, no error from pgadmin, and, yes, I can see all the properties of the tables before opening it. You can open the tables and see menu bars and what-not, just no data in the tables/views, but like I said,

Re: [ADMIN] Can't See Data - Plz Help!

t pgAdmin does not. EMS is at www.sqlmanager.net. Might be worth asking on pgadmin-support@postgresql.org as the developers of pgAdmin can have a look-see too and might be able to suggest other ideas. Regards, Andy. Jeanna Geier wrote: Hi List! I'm really in need of some guidance h

Re: [ADMIN] Recovering a deleted database problem

that Tom, after glancing through the online documentation, I've enabled logging of checkpoints etc. by setting "log_min_messages" to "log" - is this enough to log the times that transactions are committed, so I can find this info should I need it again in the future? Thanks

Re: [ADMIN] Recovering a deleted database problem

relevant, or is it just when 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

Re: [ADMIN] Connectionstring

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)" <[EMA

Re: [ADMIN] Connectionstring

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 str

Re: [ADMIN] Connectionstring

uot;Encoding" in the connectionString using pgOleDB with Visual Basic.? !DSPAM:37,459e5d08137101549039207! -- Andy Shellam NetServe Support Team the Mail Network "an alternative in a standardised world" ---(end of broadcast)---

[ADMIN] Recovering a deleted database problem

t exist DETAIL: The database subdirectory "base/35290" is missing. But the [dbname] database is still in the system catalogues: /usr/local/pgsql/bin/psql -U postgresql -d postgres -c "select datname from pg_database;" datname postgres [db1] template1 tem

Re: [ADMIN] Windows Dependency Issue

g.) sc config "PostgreSQL Database Server " binpath= "C:\Program Files\PostgreSQL\bin\" If it's successful, you'll get the message: "[SC] ChangeServiceConfig SUCCESS" Also note there's a space between "binpath=" and the EXE name - that to

Re: [ADMIN] Frustrating LO problem

estfile\\056contents') ERROR: invalid input syntax for type oid: "testfile\056contents" ^^ here it seems to be thinking that column 'template' is of type 'oid', not 'lo' (if I'm reading the error right: "invalid inp

Re: [ADMIN] Postgres and Firewall

lient library using the PostgreSQL protocol that does the talking. You sound like you're using a fairly restrictive firewall, generally allowing traffic from/to a certain IP and port number is all that is required - is there a "generic TCP" option at all in your firewall? -- A

Re: [ADMIN] How do you upgrade for production servers?

old server (so no updates can get in after your backup), restore the backup into the new server, and restart your new server on port 5432. It all depends on how big your databases are, and the length of time it'll take to restore your backup. Happy New Year to you too. Andy. Arnau wrote

Re: [ADMIN] Dump and Query

me | sur_name -++-- CUS002 | Andy | Shellam Or you can dump a specific table: # /usr/local/pgsql/bin/pg_dump --table=[tablename] [database] Regards, Andy. Enrico wrote: Is there any way to make a dump from a query? For example if my query is: select field1,field2 from table Do

Re: [ADMIN] pgAdmin crashes

give 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 wrot

Re: [ADMIN] pgAdmin crashes

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 sta

Re: [ADMIN] DB problem

d, you should be thinking of upgrading to at minimum 8.1. Andy. [EMAIL PROTECTED] wrote: Hi, We are using PostgreSQL 7.3 version, installed in linux system. Only DB is getting shut down 3-4 times a day. From my application end I get "Sorry too many clients" error. Refering the FAQ I ma

Re: [ADMIN] Backup

rth of WAL files, and it took 10 hours!) "a lack of -i in cp, for example" FWIW, -i in copy won't render a backup useless - only if the file to be archived has already been archived (in which case it stands a chance it's the same file anyway as PG rotates/recycles WAL file

Re: [ADMIN] pgadmin firewall configuration

s keeping state) or rule 1 AND 2: Rule 1: Allow from to destination port 5432 source port any Rule 2: Allow from to destination port any source port 5432 If that doesn't work, post the relevant section of your firewall configuration. Andy. Ronny Ritongadi (LINC Solution) wrote:

Re: [ADMIN] how to recover database back from /data folder [ Possibly

ted to too liberal permissions. Probably the original poster was doing the same mistake. Regds mallah. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster !DSPAM:37,457d667230861609539772! -- Andy Shellam NetServe Suppor

Re: [ADMIN] .bat file to access postgreSQL command line from C:\

bat ending. Or, when you go to Save As in Notepad, wrap the filename in quotes, e.g. File > Save As > "pgsql.bat" This will tell Notepad that you've already added the extension and don't need .txt adding on as well. -- Andy Shellam NetServe Support Team the Mail Netwo

Re: [ADMIN] Lost password to user postgres

ange the postgres user password, then edit your pg_hba.conf file again, to: host all all 127.0.0.1/32 md5 And restart the service, then you should be able to login with that password. Andy. Scott Marlowe wrote: On Sat, 2006-12-02 at 11:44 -0800, Philippe Salama wrote: 2 years ago,

Re: [ADMIN] Postgres at startup

ot; (so you can start it yourself when needed.) Andy. Kis János Tamás wrote: 2006. November 8. 02.34 dátummal Michael McCloskey ezt írta: Postgres is starting automatically for me at startup. When I boot up my machine and then check the running processes I see postmaster.exe and 4 postgr

Re: [ADMIN] Checkpoint Location Format

WAL LOCATION). I've yet 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-0

Re: [ADMIN] Finding out free space?

DIR" (replace $PGDIR with your PG data root.) Hope this gets you started. To find your cluster root, you could do a "find / -name PG_VERSION", as these files will only be under your data root - this highest-level one returned will be your data root. Andy. Hans Guijt wrote:

Re: [ADMIN] Checkpoint Location Format

aracters before 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_st

[ADMIN] [Fwd: Checkpoint Location Format]

ost 6 digits). 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,

[ADMIN] Checkpoint Location Format

chive, has a filename of the form: .00XX.backup where is the name of the "STARTING WAL LOCATION" directive in the backup_label file, and XX is the last 6 digits of the checkpoint (after the / )? Thanks, Andy. ---(end of broadcast)--

Re: [ADMIN] installation into virtual server

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 Connect

Re: [ADMIN] Vacuum error on database postgres

ebsite for a developer to download. Please contact me privately for a link: [EMAIL PROTECTED] ...Oh, also, this box has locked up on me a few times, so its not the most stable thing in the world. It did not lock up during import of this data, but there is flaky hardware in there someplace, so it co

Re: [ADMIN] problem with initlocation

Compile it from source - 8.1.4 is the latest stable version. The 6.5 series is not just old, it's ancient. It hasn't been updated since 1999. There are some serious bugs in the earlier versions, even in the early 7.x series that do and have resulted in data loss. At least get and test out a

Re: [ADMIN] Why so long between archive calls?

Chris, I take it you've checked that the archive_command is actually succeeding (check the postgresql log file.) Perhaps try running it manually with an early log file as the PostgreSQL user account? When you say you're 500 files behind, how old is the earliest log? Andy. Ch

Re: [ADMIN] CMS - portal server Question

ation is also fairly lack, but you can get some decent help on their forums. The wizard-based installer gets you up and running in very little time (provided you already have mySQL optimally set up and configured.) Definitely worth more than just a look! Andy. Achilleas Mantzios wrote: Hi, i

Re: [ADMIN] Installing Postgres 8.1.4 on Linux RedHat

ocation (or for linking to non-standard libraries such as OpenSSL (which is in a non-standard directory on my machine).) Andy. Amit Phatarphekar wrote: I'm trying to install Postgres 8.1.4 server on our CentOS distribution of RedHat Linux environment. I have 2 choices 1. Build it groun

Re: [ADMIN] WAL log switch: 8.1.4 and current log

time how long it takes until that file is archived. Do it a couple of times at different times of the day and you'll see roughly how much data you'll lose on the off-chance the server fails immediately after a full backup. Hope this helps some! Andy. [EMAIL PROTECTED] wrote: I

Re: [ADMIN] On-line backup - /bin/tar: Error exit delayed from previous

files that are different sizes (e.g. 874MB, 5GB, 9GB) and then compare the sizes of the unzipped data. If it differs greatly in the same fashion, you've got a problem. Also just double check you're not backing up WAL logs as well (i.e. excluding pg_xlog.) Andy. Mr. Dan wrote: A

Re: [ADMIN] online backup - v810 vs. v814

'm off to replace my keyboard andy. Mr. Dan wrote: Hey Andy, Sorry for the confusion. That file and the one in archive_status (*.backup.done) are from v810. I'm wondering why my PITR backup in v814 doesn't leave me with similiear files. Neither *.backup in pg_xlog or *.backup.done

Re: [ADMIN] online backup - v810 vs. v814

That looks to be a file hanging around from a previous PITR backup. That file should be in your xlog archive. cat the contents and you'll see which backup it belongs to. Andy. Mr. Dan wrote: Hi, I do an online backup with v814 and v810. I've noticed that there is a file showing

Re: [ADMIN] libpqxx + postgresql connection

You might be better off asking this on the pgsql-interfaces list - that's geared more towards programming with libpq and other interfaces. Andy. LiveShell wrote: Hi all,   I am using libpqxx to connct to Pgsql database. Following is my code in a connect method of a

Re: [ADMIN] Read db files directly

. Run the same SELECT query in 7 - SELECT * FROM public.alias; 10. Check the data bought back is the same - YEP Obviously worthy of note is that the server versions of the one you're working on, and the one you're data directory is from should be the same (this is given in PG_VER

  1   2   3   >