Hi,
I want to Install postgresql server in windows platform, kindly any one
help for this.
Thanks & Regards
Jayakumar M
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Vishal Arora
Sent: Thursday, June 21, 2007 4:28 PM
To: [EMAIL PROTECTED]
Cc: pgsql-ad
Hi Joe,
This has got to be the longest thread ever to get PostgreSQL running
on the Mac -- but I'm glad you have not given up :).
On Jun 21, 2007, at 12:49 AM, Joe Barwell wrote:
acorn$ sudo su postgres -c 'pg_ctl start -l logfile -D
/Library/PostgreSQL8/data'
Password:
sh: line 1: logfile:
Did you run the SQL script in postgres database or anywhere else. When I
tried to run that pgagent.sql in some other database I did not find jobs in
pgAdminIII. If you try to run it in postgres database (default one created
while installation). I think this should work for you.
- Vishal
Fro
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> Doesn't MacOSX install postgresql by default for one of their management
> services?
Good point --- IIRC, there is a PG 7.3.something embedded in Apple
Remote Desktop. I'm not sure whether it starts automatically on boot;
I seem to recall a recent
Tom Lane wrote:
Joe Barwell <[EMAIL PROTECTED]> writes:
I get the same result trying to initdb after rebooting, the
end of which is:
/Library/PostgreSQL8/data/base/1 ... FATAL: could not
create shared memory segment: Cannot allocate memory
DETAIL: Failed system call was shmget(key=2, size=164
Joe Barwell <[EMAIL PROTECTED]> writes:
> I get the same result trying to initdb after rebooting, the
> end of which is:
> /Library/PostgreSQL8/data/base/1 ... FATAL: could not
> create shared memory segment: Cannot allocate memory
> DETAIL: Failed system call was shmget(key=2, size=1646592,
> 0
Tom Lane <[EMAIL PROTECTED]> wrote:
> Ugh. I don't recall exactly when Apple got around to
> including ipcs, but I guess it wasn't in 10.3.9. Your
> problem is that you're flying blind because you cannot
> tell what's going on in shared memory.
>
> What I suspect is that there's an unused shared
Dear Vishal,
I have installed pgAgent as a services on windows and then I open the
pgAdmin III but I cannot read Jobs(1) like image pgAgent's help.
Could you like to help me again, how to connect pgAdmin III and pgAgent to
create a schedule
Thank you for your help.
Regards,
Nyoman/Bali
Joe Barwell <[EMAIL PROTECTED]> writes:
> acorn$ sysctl -a | grep shm
> kern.sysv.shmmax: 4194304
> kern.sysv.shmmin: 1
> kern.sysv.shmmni: 32
> kern.sysv.shmseg: 8
> kern.sysv.shmall: 1024
OK, so you should be able to do 4MB without problems.
> acorn$ sudo ipcs -a
> Password:
> sudo: ipcs: comma
Hi Tom,
acorn$ sysctl -a | grep shm
kern.sysv.shmmax: 4194304
kern.sysv.shmmin: 1
kern.sysv.shmmni: 32
kern.sysv.shmseg: 8
kern.sysv.shmall: 1024
acorn$ sudo ipcs -a
Password:
sudo: ipcs: command not found
> Also, which OSX release is this again?
10.3.9 on a g4.
Joe
--
Joe Barwell <[EMAIL PROTECTED]> writes:
> Fixing the postgres user's home may have been an
> improvement, but now I get problems with the shared memory
> segment:
Hmm ... Apple's default for SHMMAX is definitely penurious, but it's not
so small that PG shouldn't be able to start at all. What do y
Hello people,
Fixing the postgres user's home may have been an
improvement, but now I get problems with the shared memory
segment:
acorn$ sudo su postgres -c 'initdb -D
/Library/PostgreSQL8/data'
Password:
The files belonging to this database system will be owned by
user "postgres".
This user mus
Hi,
Am able to figure out the solution for the issue. I accomplish the task by
writing the ant script and batch file. In the batch file am passing the
table name as arguments.
Only thing I had to do manually is to list out the name of the tables in
batch file.
Cheers,
Cha
cha wrote:
>
> Hi A
Hi All,
Am able to resolve the problem by setting PGPASSWORD=password in my
environment variables and passing the -q(quiet) command in my ant script.
Cheers,
Cha
cha wrote:
>
> Hi All,
>
> Am using the following command to import tables in my database. I got list
> of tables which i need to
Hi All,
Am using the following command to import tables in my database. I got list
of tables which i need to import.
So have made ant script and batch file to accomplish the purpose.
Ant script contains all the configurations with following command :
To call this ant file am passing the foll
Joe Barwell <[EMAIL PROTECTED]> writes:
> The following, however, makes me suspect it's still a
> problem with initdb:
> acorn$ postgres
> postgres cannot access the server configuration file
> "/Library/PostgreSQL8/data:/postgresql.conf": No such file
> or directory
What's that colon doing in th
Karl Wright <[EMAIL PROTECTED]> writes:
> (a) How do I get around the "out of memory" error for pg_restore?
Does this table have foreign key constraints? I imagine you're running
out of space for the deferred-trigger list.
> (b) How can I get the restore performance up to the level where it take
Tom Lane wrote:
Karl Wright <[EMAIL PROTECTED]> writes:
and then I installed 8.1, and attempted the following:
pg_restore --file dbsnapshot --format=t --table=ingeststatus -a
But, I get the following error:
pg_restore: [tar archiver] could not find header for file toc.dat in tar
archive
Oh, I
You can also use the pg_dump utility and put it on a cron (in Linux) to schedule
backups.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Vishal Arora
Sent: Thursday, June 21, 2007 6:58 AM
To: [EMAIL PROTECTED]
Cc: pgsql-admin@postgresql.org
Subject: Re:
Hi
You can do it with the pgAdmin III
Please check the following link -
http://www.pgadmin.org/docs/dev/pgagent.html
PgAgent can help in scheduling jobs for you.
- vishal
From: "gunartha.nyoman" <[EMAIL PROTECTED]>
Reply-To: "gunartha.nyoman" <[EMAIL PROTECTED]>
To:
Subject: [ADMIN] back
hi guys,
I just trying to install postgres 8.2 in windows xp and success.
But I don't know to create schedule backup. Could you like to help me to solve
my problem
Many thank for your kindly attention
Regards,
Nyoman/bali
21 matches
Mail list logo
