[ADMIN] Problems with pg_restore

Hi,   I've made a dump from PostgreSQL 7.2.2 under Win2k with the command:       $pg_dump -o -C -b -Ft -i -O -v DataBaseName > DBN.dump   Then I've tried to restore it to another instalation, in another server (RedHat 7.3, PostgreSQL 7.2.4)       $pg_restore -Ft DBN.dump -d DataBaseName   Bu

Re: [ADMIN] pg_restore problem

> Are you sure your restoring to an empty database? If you try to restore > your dump into the database you dumped it from (without first > drop/create) it will take forever as you'll have all kinds of data > collisions (imagine every insert into a table erroring out due to > duplicate primary key)

Re: [ADMIN] pg_restore problem

> $pg_restore -a -d DB2 -Fc -o -v DB1.dump As I'm running pg_restore like this and is taking to long, is there any other way to restore OIDs/lo objects? TIA Ricardo ---(end of broadcast)--- TIP 2: you can get off all lists at once

[ADMIN] restore time

Hi, I'm trying to restore a database, btu I couldn't so far. It's taking more than 14 hours to complete, and we make a valuation of more than 22 hours to complete restore a 1,5 Gb database, from a 60 mb dump.   This only happen when I use the binary mode (-Fc) with plain text it takes at mo

[ADMIN] 7.4 and schema 'maintainance'

So.. I wanted to move some tables out of 'public' and put 'em into a schema. Seemed like a pretty simple thing to do. The problem is that the data export includes the search path. So, it overrides the default $user,public and forces public. If I export with a filetype of plain then I can edit t

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 ConnectionName = Console as suggest

[ADMIN] Checkpoint Location Format

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 regu

[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,

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 +0000, 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

Re: [ADMIN] Finding out free space?

I'm not too sure where the default Postgres data directory is, but to find out how much free space a database is using, you need to know it's OID. Run the query: SELECT OID, Datname FROM pg_database; to get a list of database names and their corresponding OIDs. Then you can do (standard Uni

Re: [ADMIN] Checkpoint Location Format

7 at 13:12 +0000, Andy Shellam (Mailing Lists) wrote: 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 u

Re: [ADMIN] Postgres at startup

I'm guessing by the "postmaster.exe" that this is on Windows. In that case, find "PostgreSQL X.Y" in Control Panel>Administrative Tools>Services (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.)

Re: [ADMIN] Lost password to user postgres

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 restore

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

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

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

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, recoveri

Re: [ADMIN] pgadmin firewall configuration

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

Re: [ADMIN] Backup

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 -

Re: [ADMIN] DB problem

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, an

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 started after installin

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] Dump and Query

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

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

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 yo

Re: [ADMIN] Postgres and Firewall

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 need

Re: [ADMIN] Frustrating LO problem

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: { WARNI

Re: [ADMIN] Windows Dependency Issue

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 binpath= "" (eg.) sc config "PostgreSQL Dat

[ADMIN] Recovering a deleted database problem

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

Re: [ADMIN] Connectionstring

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 con

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

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] 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] Recovering a deleted database problem

Well, I'd be a little worried about whether the base backup was self-consistent, but if it was taken at a time where the DB was idle then you can probably get away with this. It gets backed up at 2am in the morning and AFAIK there'd be very few (if any) transactions going through until abo

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

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

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

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

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] Database Create Date

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 modif

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

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] 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 Regards, Andy. Josef Springer w

Re: [ADMIN] configuring the postmaster.log

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 log_fil

Re: [ADMIN] windows silent installer .msi file

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] [mai

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] Incremental Backup of a particular database

/17/07, *Andy Shellam (Mailing Lists)* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote: 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

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] 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] unsubscribe

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

Re: [ADMIN] Postgres is not starting or stopping

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 insi

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

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 t

Re: [ADMIN] PgAdmin : table backup problem

rsion of PgAdmin then you need to complain to the PgAdmin developers (not here --- they have their own mailing lists). FYI (the OP's original e-mail was copied in to pgadmin-support) this is fixed in the upcoming PgAdmin 1.6.3.

Re: [ADMIN] rename a cluster

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 Postgr

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] WAL files backup

Chad Wagner wrote: On 2/15/07, *Eduardo J. Ortega* <[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,

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

[ADMIN] 8.2 Admin Pack broken?

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] /endeavour/software/cache/postgresql-8.2.3/contrib

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

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?

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] log_duration?

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 EST,4

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] PostgreSQL and VB.net

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 sugge

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] [INTERFACES] where postgres 8.1.8 log messages go

ar/log/pgsql the same thing happen. what else I need to do to make things 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: [INTERFAC

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 1

Re: [ADMIN] Help With Database Backup

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

Re: [ADMIN] Help me understanding the schema

Hi Scott, >> 7. we can set the privilege of user x for schema y >> ie. database aaa contains schema a1, a2 and a3. user xx can query from >> schema a1 only, user yy can query from schema a2 only? > No, perms on schemas control schema actions like create. perms on > tables control user access.